Thread: Saving a spreadsheet without saving the Macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Saving a spreadsheet without saving the Macro
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.


Reply With QuoteReply With Quote