Thread: How can I save a macro to an excel 2007 woorkbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How can I save a macro to an excel 2007 woorkbook
You need to change the Save As Type from "Excel Workbook xlsx" to "Excel
Macro Enabled Workbook xlsm"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"help" wrote in message
...
I am getting an error that says can not save in a macro free workbook.
This
workbook resides on a pub share. I can not even get it to let me save the
VBA file. I just updated to 2007.

Reply With QuoteReply With Quote