How can I save a macro to an excel 2007 woorkbook

  • Thread starter Thread starter help
  • Start date Start date
H

help

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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

[VBA] How to convert an Excel woorkbook completely from Excel 2003to Excel 2007? 3
Lose macros before saving 4
Open Workbook Macro - with a twist 1
VBA referencing disappears with 2007 upgrade 1
2007 vs 2003 2
security, enabling macros to enable a disabling saving function 12
Change workbook name to a generic name 4
Just switched to Excel 2007 from 2003 - Unclear how to enable macros 2

Back
Top