Automatic unlocking and locking worksheet on opening excel

H

Hari

Hi,

I checked the newsgroup but couldnt find my message posted hence, Im
reposting .( Strangely my sent items shows that this message has been
sent ).

Please tell me how to set up the same.

Regards,
Hari
India
 
T

Tom Ogilvy

Sheets("Report Data").Unprotect Password:="Hotdog"



Sheets("Report Data").protect Password:="Hotdog"
 
Top