excel - macro code to open a protected sheet, enter passowrd, and then protect sheet

  • Thread starter Thread starter arunjoshi
  • Start date Start date
A

arunjoshi

i want to open a protected sheet - where protection has been done usin
a passowrd. and then later protect the sheet again using a password
 
Hi
use something like
activesheet.unprotect password:="yourpassword"
'some code
activesheet.protect password:="yourpassword"
 
You must log in or register to reply here.

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

Hide VB Scripts & macro from user 1
Excel Protection 2
Sheet protection complications 4
Chartobjects protected but it can still be deleted, edited and movedby the user (yes, the sheet is p 5
Spell Checking on a protected sheet 1
Modifying a locked/protected sheet 3
Need to protect with Password 2
Protecting & Unportecting the sheet. 5

Back
Top