Hi All
i have a template file (XLT) that saves a copy of the file with file name from specified cells in workbook to specified folder ,which works great after some help from the guys here .
what id like to do is remove all the macros in the workbook when the file is saved,ive tried serching but cant find a macro todo this,
the save macro runs from a button in the sheet
heres the code that i use to save
any help would be great.
Thanks
Please Login or Register to view this content.
You can't have code in the template that saves itself as a different filename sans macros; think about it: where would the code be running that does the Save?
You could do SaveCopyAs, opend the copy, delete the code, and save again, but that seems way more complicated than necessary. Why not have the code running in a separate sheet (not the template), have it open the code-free template, do whatever it needs to do, and then save the template as a workbook?
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks