How can I save a macro to an excel 2007 woorkbook

's Computer Specifications

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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:6EBEC3C6-09D4-4E41-8DE2-(E-Mail Removed)...
>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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[VBA] How to convert an Excel woorkbook completely from Excel 2003to Excel 2007?	Peter Müller	Microsoft Excel Programming	3	30th Jan 2011 07:03 PM
Office 2007 Excel Macro to save Active Worksheet to HTML by name	daviller	Microsoft Excel Programming	1	6th Nov 2009 06:20 AM
Re: Cannot save event macro, Excel 2007	Chip Pearson	Microsoft Excel Programming	0	6th Sep 2009 01:19 AM
Re: Cannot save event macro, Excel 2007	Don Guillett	Microsoft Excel Programming	0	5th Sep 2009 11:57 PM
save excel 2007 worksheet as pdf in macro	Jania	Microsoft Excel Programming	2	29th Sep 2008 03:16 PM