Display "macro-free workbooks - VB project message" on closing Exc

  • Thread starter Thread starter Gary Nguyen
  • Start date Start date
G

Gary Nguyen

My codes image a table in Office 2003 excel template with macro enable, after
I update to Office 2007, I get this error message on closing the workbook:
The following features cannot be saved in macro-free workbooks:
VB project
To save a file with these features, click No, and then choose a
macro-enabled file type in the File Type list.
To continue saving as a macro-free workbook, click Yes.

Is there a way I can suppress this message programmatically? Or using Office
2007 policy?
It seems that Office 2007 does not allow to save as .xlsx with macro.
Thanks for your help.
 
You need to save it once as a 'macro-enabled workbook' in 2007...
I think the type is xlsm... After that you can save the file without getting
this message...
 
Thanks for your reply.
But everytime after the user images the template, then he closes this
template, the error message diplays again.
Is there a way, I can default this template to .xlsm (or .xls) on saving
when user closes the template?
Thanks
 
Hi Gary

A template will try to save the file in the default format of Excel 2007
You can change the default file format to xlsm(with macros)
See Office Button>Excel Options...Save

I send a suggestion to MS to always default the save for a template with code as xlsm
 

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

Excel 2007: Saving a file with a Macro 1
Macro help 2
Save Macro enabled WB as w/o macro 13
enable macros in 2007 1
Default a workbook to save as a xlsm (macro-enabled) in 2007 3
Excel 2007 Can't Save File with VB Script but it can in 97/2003format??? 2
Excel Macro-enabled Workbook 2
How to make a .XLTM template file default to save as .XLSM type? 1

Back
Top