Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing Workbook_Open code
Hi Paige;
You could try using an Auto_Open macro instead of the workbook object or changing the code in either case to reading the workbook name and then skipping all the routines if it is not the original name. It might look something like this; Sub try() If activeworkbook.name = "TheOrigianlName.xls" then 'do the stuff End If End Sub Thanks, Greg -----Original Message----- I am building a file that when opened it begins a series of userforms for selection by the user. Once completed I have it so it automatically deletes all the modules & userforms in visual basics and saves the file as a different name. Is there a way to delete the Workbook_Open code so that the next time I open the new file no macros are prompted? Thank you for any help. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving & Removing VB Code from WB | Excel Worksheet Functions | |||
Workbook_Open code help | Excel Discussion (Misc queries) | |||
Deleting Workbook_Open code | Excel Discussion (Misc queries) | |||
problem with code in workbook_open event | Excel Programming | |||
Removing VBA Code (programatically) | Excel Programming |