What are possible reason when protection with "userinterfaceonly:=True" won't work?

[pedie]

What are possible reason when protection with "userinterfaceonly:=True" won't work?
Below is my code. It works now but @ work it wont work. It keeps repeating that sheet/chart is protected....unlock it...

I dont want the code to unlock and then protect it back everytime i run macro....

Please suggest!

[/FONT]
[FONT=Courier New]Sub try()
 Sheet2.Protect Password:="123", userinterfaceonly:=True
End Sub[/FONT]
[FONT=Courier New]

PS. The ribbon is completly hidden with excel4macro


Thanks.

Pedie

 

[Jonmo1]

This is one reason I don't like using userinterfaceonly...

The userinterfaceonly setting is NOT saved when you save/close/reopen the book.
You have to use the
Private Sub Workbook_Open()
event code to set it every time you open the book.

Hope that helps.

 

[VoG]

Hi Pedie. You will need to unprotect it then re-protect it.

 

[pedie]

Do i have to unprotect it when the workbook closes and then let the workbook open event protect it again?
is that what you guys mean?

Thanks again for suggestions.

 

[Jonmo1]

No (provided you have the correct password).
Just protect it with the userinterfaceonly option using the workbook open event.

 

[pedie]

Works perfect here at home. Will try back tomorrow if it still persist.
Thanks for your time Peter, and jonmo1.