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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"jillc" wrote in message
...
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?
--
Thanks in advance, Jill C