How do I set worksheet protection automatically?

[Sri Rahm]

Can someone help me to automatically set the worksheet protection to UserInterfaceOnly automatically every time the workbook opens? This allows VBA to write to cells but not the user.

II can do it with VBA code but I want this code to run automatically. When the workbook opens again, the protection is full protection and I get error messages when VBA tries to write.

I have put a button which the user has to click manually to set protection to UserInterfaceOnly after the worksheet opens. I tried setting code in th worksheet.activate avent but it does not fire if anyone comes in to the worksheet through a hyperlink. (It does fire if someone clicks on the tab to get to the worksheet.

Thanks
Sri

 

[Sri Rahm]

I just figured out that I can use the Workbook Open event to place the code to set protection for one of the worksheets. Perhaps there is another way connected only with that worksheet, but tis works.
Thanks