I have a subroutine that runs for the worksheet_selectionchange event on a protected sheet. Apparently, subs don't work on protected sheets. I found online a method that is supposed to allow subroutines while keeping the worksheet protected. There is an argument of the protect method that should protect the user interface, but allow macros.
The UserInterfaceOnly argument is supposed to allow VBA changes to the worksheet, even while it's protected, if set to TRUE. Default value is FALSE, from what I've read. However, even when I set this to true immediately before the subroutine runs, I encounter a run-time error on a specific piece of the sub that handles the data validation of particular cells. (Note, the sub works perfectly when the sheet is not protected.)Please Login or Register to view this content.
Anyone know anything about this? Also, is it significant that it does not auto-capitalize "userinterfaceonly" when I type it in?
Thanks a lot.
Bookmarks