I am using the (2) Two workbook setup
#1 Data workbook (Active Workbook)
#2 Macro workbook (Hidden)
When the Macro WB is open the ListBox works, it is slow on the Scroll, I have 42,000 items to lookup, but when the Macro WB is closed the ListBox is Empty.
I can not leave the Macro WB open...
Corrected
I was using the Macro file to hold the Source, Criteria and the Filter Range which looked @ the Upload file for Criteria, I move the criteria to the Upload file ( Activeworkbook) whith the VBA in the macro file.
When I file same as a NEW file Name the file still has the Criteria...
http://hotfile.com/dl/145671340/3f94c2e/MACROS.xlsm.html
http://hotfile.com/dl/145671630/5f27eec/SB25_UPLOAD.xlsm.html
The UPLOAD file also opens the the Macro File (ussing Sharepoint)
The UPOAD is the Active file
The Macro is Hidden
If I can not Save the New file without Renaming the...
I am using a (2) Two file system
1 file holds the Macros (Hidden Workbook)
1 file holds the Form (Initial File Name as the ActiveWorkbook)
The Form alows the user to enter
the Administrator,
the Account# and then to choose
the Agreement that they want to work on.
When they choose an...