Saving up to xlsm

  • Thread starter Thread starter Deb
  • Start date Start date
D

Deb

I am trying to save xls to a xslm and get this message. "This workbook
contains excel 4.0 and excel 5.0 macros. If you would like to password
protect / restrict permission these macros need to be removed" I have gone
into the macros listed for this workbook and deleted them.. It still gives me
thsame message..
Help please.
 
In addition to removing the code, you need to remove any modules as
well. Alt-F11 will bring up the VBE, then right-click on any Module
listed and click on Remove Module - Excel will ask if you want to
Export the module before removal, but just click on No.

Hope this helps.

Pete
 

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 Save as .xlsm 3
How to make a .XLTM template file default to save as .XLSM type? 1
XLSM File Will Not Save Macros in Quick Access Toolbar 4
how can i convert .xlsm to xls 1
Default a workbook to save as a xlsm (macro-enabled) in 2007 3
How do I save a password protected .xlsm file containing old macro 2
Save as, changing default fileformat in Excel 2007 4
2007: xlsm format holds how many columns? 4

Back
Top