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

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
 
F

Frank Kabel

Hi
use something like
activesheet.unprotect password:="yourpassword"
'some code
activesheet.protect password:="yourpassword"
 
Top