View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tobie Hanekom Tobie Hanekom is offline
external usenet poster
 
Posts: 4
Default Save a file with Protected Macro

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 rename the file different from the
master

My code looks like this

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

Tobie