SAVE FILE - PROTECTED MACRO

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
 
J

Jim Rech

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.
 
Top