UserInterfaceOnly not being recognised
 

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

UserInterfaceOnly not being recognised
 

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

UserInterfaceOnly not being recognised
 

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.

--
Jim
"Jon Peltier" wrote in message
...
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

UserInterfaceOnly not being recognised
 

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


"Jim Rech" wrote in message
...
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.

--
Jim
"Jon Peltier" wrote in message
...
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