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

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

--
Message posted from http://www.ExcelForum.com

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


i want to open a protected sheet - where protection has been done
using a passowrd. and then later protect the sheet again using a
password.


---
Message posted from http://www.ExcelForum.com/