 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / December 2007UserInterfaceOnly 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?  SignatureThanks in advance, Jill C 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 _______ >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? >>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. SignatureJim > These named parameters do not autocapitalize. > [quoted text clipped - 14 lines] >> the phrase 'userinterfaceonly' does not capitalise as expected, and the >> macros do not work as expected. Is my syntax wrong? 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 _______ >>>The UI Only setting doesn't seem to work. > [quoted text clipped - 20 lines] >>> the phrase 'userinterfaceonly' does not capitalise as expected, and the >>> macros do not work as expected. Is my syntax wrong? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.