Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove macros in xls file, but keep macros in xlt file
I have a "Master" Excel template ".xlt" that contains macros to create, format and protect a new worksheet. After the "Master" "xlt" file is opened, and used to create, format, and protect a worksheet, the macros are no longer needed or wanted in the new "xls" file (but the macros are still wanted and needed in the "Master" "xlt" file). How do you save the resulting "xls" file, keeping the formatting and worksheet protection, without the "Master" template's macros? Is there a macro that can be created, that will not save the macros in the "xls" file, but will keep the macros in the "Master" template "xlt" file? -- nulad ------------------------------------------------------------------------ nulad's Profile: http://www.excelforum.com/member.php...o&userid=33248 View this thread: http://www.excelforum.com/showthread...hreadid=530713 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
Excel '00, 1st file has macros, how to stop macro in 2nd file? | Excel Discussion (Misc queries) | |||
Remove excel macros from a file to be sent | Excel Programming | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
creating an exe file with visual basic (installation file for Macros and Userforms) | Excel Programming |