UserInterfaceOnly not being recognised

[jillc]

I add the following code into a workbook_open sub

Worksheets("DataInputSheet").Protect userinterfaceonly:=True

the phrase 'userinterfaceonly' does not capitalise as expected, and the
macros do not work as expected. Is my syntax wrong?

 

[Jon Peltier]

These named parameters do not autocapitalize.

I find that some things do not work unless the sheet is truly unprotected.
The UI Only setting doesn't seem to work. It may vary on Excel version.

- Jon

 

[Jim Rech]

The UI Only setting doesn't seem to work.

I find it works "most of the time". I slap it on, see what chokes, and put
unprotect/protects around them.

 

[Jon Peltier]

I meant to say "The UI Only setting doesn't always work." I do the same
check as you, and wrap the broken code with un/protect.

- Jon