Thanks I will check that out.
Maybe I am going about this the wrong way. When the user opens my
spreadsheet it opens a text file, does lots of formating and totalling, and
then saves the spreadsheet in a folder with a different name.
I thought that there might be something I could add to the code that saves
the spreadsheet so that it no longer has the macro.
I tried saving it as a template but it still runs the macro. The user can
always disable macros but I would rather they didn't have to do that.
Thanks
"Ron de Bruin" wrote:
Another way is to delete the VBA
See Chip Pearson's site
http://www.cpearson.com/excel/vbe.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"tedd13" wrote in message ...
Sorry, no it's just a spreadsheet. I guess I shouldn't call it that. Would
it make a difference if I saved it as a template?
Thanks
"Ron de Bruin" wrote:
Is it a real template ? xlt
--
Regards Ron de Bruin
http://www.rondebruin.nl
"tedd13" wrote in message ...
I have a spreadsheet that I use as a template. When a user opens the
spreadsheet it runs a macro (using Auto_Open). This macro does its thing
with the data and then saves the spreadsheet.
The problem is that the macro is saved with the spreadsheet. Because of the
Auto_Open, the user has to dispable macros when they open the saved
spreadsheet.
Is there a way, using VBA, to save the spreadsheet without the macro?
Thank you.