| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro statement when opening file, but no macro
Hi Robert,
'----------------- Thanks Norman. Worked like a charm ... save for having to scroll through 40-60 worksheets in 4 different workbooks. Lots of work, but it worked. '----------------- I am glad that you have resolved your problem. However, had the extent of your problem been apparent, I would have referred you to Chip Pearson at: Deleting All VBA Code In A Project http://www.cpearson.com/excel/vbe.htm#DeleteAllVBA and I would have suggested code to loop through the required workbooks. --- Regards, Norman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Statement not to update the file while opening through Macro | Excel Programming | |||
| Can a macro be run on opening the file? | Excel Discussion (Misc queries) | |||
| opening ftp-file from macro | Excel Programming | |||
| Opening a file with a Macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
