"Dennis Marks" <[EMAIL PROTECTED]> asked:
I created a macro that unlocks the sheet, copies values from one spot to
another, and then relocks the sheet. I have a couple of problems.
1. When I run the macro from the menu it works but at the end it stops at
the enter password to lock box. In the macro I did enter a null value and
entered it. Why is it asking for one to set again?
< snipped >
I'm not sure of all the steps in your macro, or how the components and
variables are defined, so this may not mean much, but I think the command
you need to use to "quietly" protect the sheet, without the password dialog
box is: oSheet.Protect("")
You need to be sure that oSheet is properly defined. If this doesn't make
any sense, and your macro is not too large, copy it to a new message, and
include enough comments so we know what you are trying to do.
-- John Viestenz
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
