ActiveWorkbook.Protect password:=range("rangename") does not work

W

WimR

I am trying to have macro protecting a workbook, with a password
specified by an administrator in one of the hidden worksheets.
The cell in the hidden worksheet in which the password is specified is
named, so I want to use the range name in the macro that
protects/unprotects the workbook.


It all works well when I try to unprotect the workbook, using the code
: ActiveWorkbook.Unprotect password:=range("rangename").
However, I get an error when I try to protect the workbook with the
code: ActiveWorkbook.Protect password:=range("rangename")
The error message is: Runtime Error "1004, Application-defined or
Object-defined error.


Can anybody help ?


Many Thanks
Wim Ruepert
Sydney, Australia
 
A

abcd

the cell is not a password, but its content (the value) may be one:

try:

range("rangename").value
 

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

ActiveWorkbook.Protect password:=range("rangename") does not work 2
Using Activebook.Unprotect in macro giving errors (Password) 1
Macro to Protect workbook using a password 10
Macro to Protect workbook using a password 2
activate workbook w/unknown name 2
Macro to Protect workbook using a password 1
macro for protection 3
Qualifying permissions in protect unprotect macro. 3

Top