Automatic unlocking and locking worksheet on opening excel

  • Thread starter Thread starter Hari
  • Start date Start date
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
 
Sheets("Report Data").Unprotect Password:="Hotdog"



Sheets("Report Data").protect Password:="Hotdog"
 
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

Execution on opening the workbook. 3
Opening excel files automatically 6
including macro in protected worksheet 2
Closing excel and saving workbooks 2
Unlocking a Project 3
Checking whether a workbook has been unlocked 4
How to make web image on Excel worksheet permanent 3
Omitting displayalerts set to true Vs. Automatic reset 4

Back
Top