SAVE FILE - PROTECTED MACRO

  • Thread starter Thread starter Tobie Hanekom
  • Start date Start date
T

Tobie Hanekom

I have developed a file with a macro which is protected by a password. A
"Save" button with the assigned macro calls the procedure in the macro and
when I am trying to save a file the following message appears

"You cannot save this file format when the VBA Project is protected

You may unprotect the VBA Project by......"

What do you suggest I do to save a file with a protected macro? The macro
must be protected, it is very important for me not to allow access to the
macro in totallity.

I am using certain cells' information to name the file

My code looks like this

ActiveWorkbook.SaveAs "C:\Anchor\PersLine Quotes\" &
Range("FileName").Value

Tobie
 
I'm guessing that you are trying to save the file in Excel 95 format. At
least I get the same error message as you're reporting when I manually try
to save a protected VB project in Excel 95 format. This isn't permitted
since Excel 95 does not support protect projects.
 
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

Excel 2007: Saving a file with a Macro 1
Modifying a protect unprotect macro 10
Word Macro to insert text and save as PDF 4
Save file as todays date 3
problem with macros and protections 5
Run Macros in a Password-protected workbook? 1
Qualifying permissions in protect unprotect macro. 3
Save a file with Protected Macro 2

Back
Top