UserInterfaceOnly Issues....new issue (I think)

Sorry, my bad. Thanks for your assistance. I have edited to correct.

Originally Posted by :) Sixthsense :)

Don't worry about the Text Capitalization just place the cursor in that Optional Argument userinterfaceonly:= part and press Ctrl+I and in the popup information box it will show the userinterfaceonly part highlighted in Bold if it so.. then don't worry the syntax is right

Many thanks for this. I was not aware of it. However it appears to work only with the method and not the arguments. I tried it with the Password:= part and it did not show anything...even though this part is working OK and is also capitalised. Likewise the UserInterfaceOnly:= does not show anything.
I am still stumped.
Thanks again.

Originally Posted by Izandol

Your code is correct. What is your problem with it? (as Sixthsense says, the 'userinterfaceonly' name will not capitalise)

The parameter is not effective. As soon as the macro runs and tries to alter a cell in the sheet, it generates an error. I was suspecting that not capitalising was a symptom. Generally I find that the capitalisation occurs when excel encounters a valid command. When I put the "nested protect/unprotect back the sheet runs OK.
Thanks....

Dear Sixthsense,

I am sorry I don't quite understand.....
The module that I posted is in the Workbook_open() module. The protection is not applied manually but is applied on opening using the coding that I posted.....

Still working on this one......
Here is how I am working. When I close the sheet I am unprotecting, and hiding the tabs and columns which need security (so that if someone with the incorrect security level opens, they do not see confidential information). Before I close I am protecting again with the "UserInterfaceOnly parameter.
When I open, I am reading the environment userID and then writing this to a cell in the sheet (this is where it falls over), then depending on the value of this I validate against a lookup table, and unhide the sheets that they are authorised to see. In order to do this I am having to unprotect and reprotect each tab.
Am I correct in assuming that UserInterfaceOnly does not work with setting the hidden or visible property and that I will still have to unprotect and protect in order to set this property?
I have checked by rem'ing out the protect/unprotect loops on other areas in the code and it still runs OK (using outlining and autofilter) but in the open routine it falls over. It is like UserInterfaceOnly has to be re-applied when the sheet is opened (the property is not retained when the sheet is closed....like "EnableOutlining"....am I right??

Thanks.

Thanks Sixth,

So it appears that like the EnableOutlining, the property is lost on closing and will need to be re-established on opening. That really explain my issue I guess. If I remove the statement from the open event then the autofilter and outlining do not work (regardless of the protect arguments). When I put back the UserInterfaceOnly........the autofilter and outlining work again....I guess it is working as well as it can.

Many thanks for your assistance and comments.......sorry for my poor understanding.

Thanks Sixth....I have marked as "Solved".....