Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activate ChartObjects on protected sheet??
Hello,
I am selecting various ChartObjects (stacked charts) on a worksheet and want to protect the sheet. When I select the protection and run the macro that selects the appropriate chart, I get the a code break at: ActiveSheet.ChartObjects("Chart1").Activate I have all cells on the sheet locked, with 3 exceptions: the 2 cells linked to my dropdowns and one behind the sheets that I select after activating my macro to hide the activecell. (I cannot get rid of the activecell border) ? Is there a way to lock/unlock or protect the charts in similar fashion? My sheet protection selections are 1. Select unlocked cells and 2. Format cells. I would like to protect the page while allowing the macro to select the charts as needed. Thanks for any help and advice, Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I activate spell check in a protected sheet | Excel Worksheet Functions | |||
how to activate controls in protected sheet | Excel Worksheet Functions | |||
How to export all chartobjects in a sheet to powerpoint (creating a new ppt file) as pictures? | Charts and Charting in Excel | |||
Return to Current Sheet in On (sheet activate) event macro | Excel Programming | |||
How can I activate cell shading in a protected worksheet? | Excel Discussion (Misc queries) |