Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Dave, thanks for the suggestion - a solution ended up being down this path.
Specific steps to remedy the problem: unlock the cell where the buttons are located, and .Protect Contents:=False at opening to initialize. Don't understand the intuitive logic of the latter, but it works. Regards, George "Dave" wrote in message ... If the code run by the button tries to change a protected cell, the protection interrupts the code. Try inserting these 2 lines into your code, one at the beginning, the other at the end. ActiveSheet.Unprotect <Your Code ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True "G Lykos" wrote in message ... Greetings! Have a worksheet with a button and event code. When the sheet is unprotected, the button and code work fine. When the sheet is protected, and some cells are selected to be locked but the one with the button is not, the button doesn't work. There is a host of options for sheet protection, allowing the user to change this, that, and the other while the sheet is protected, but none of them seem directly related to this. What would be interfering with button operation, and/or how can it be enabled on the protected sheet? Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sheet Protection | New Users to Excel | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Option Buttons vs Sheet Protection? | Excel Discussion (Misc queries) | |||
Sheet protection error msg - Unrequested sheet activation | Excel Programming |