Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 74
Default Buttons and Sheet Protection?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sheet Protection Mark Wolf New Users to Excel 5 October 2nd 11 04:59 PM
Excel Data Protection Best Practice: AKA: Real Sheet Protection Mushman(Woof!)[_2_] Excel Discussion (Misc queries) 4 December 30th 09 01:20 AM
Excel Data Protection- AKA: Sheet/Macro Password Protection Mushman(Woof!) Setting up and Configuration of Excel 0 December 29th 09 06:50 AM
Option Buttons vs Sheet Protection? Ken Excel Discussion (Misc queries) 2 May 23rd 07 06:43 PM
Sheet protection error msg - Unrequested sheet activation deltree[_3_] Excel Programming 0 January 28th 04 06:20 PM


All times are GMT +1. The time now is 05:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"