unlocking cells using VBA in protected sheet

T

tj_b

If I try to unlock cells in a protected sheet using VBA
code it gives me an error.

Is there a way to run the password that opens the file in
the sheet protect and unprotect function?

Any other ideas?
 

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

Unlocking Protected Cells 1
VBA Password 1
Deleting Rows Containing Protected Cells 2
Modifying a locked/protected sheet 3
Inserting rows in a protected sheet - Office 2003 2
Protected cells can't be grouped 1
Protecting Cells In A Worksheet 1
Inserting Comments into Cells of Protected Worksheet 1

Top