View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Default a workbook to save as a xlsm (macro-enabled) in 2007

Office buttonExcel options..Save

You can change it there

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Razzer204" wrote in message ...
Is there a way to have a single workbook default to save as a xlsm
(macro-enabled) file type instead of xlsx when the template it was created
from was a xltm (macro-enabled) template?

Currently it brings up a message about saving macros in a macro-free
workbook. Most of our uses will not even read/understand this and will just
save the workbook without the macros.

We would prefer not to change the default save type for workbooks from xlsx
if we don't have to.