| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2007 errors on chart changes
In excel 97 & 2000, everything works fine. Not in 2007
My macro changes chart type. It works in excel 2007 too untill I protect the worksheet. Then I get errors on this ActiveSheet.ChartObjects("Chart 1").Activate I assume it is because the chart is protected. How do I change the charts protected status so that I can make changes to the chart with macros and yet keep certain rows and colums hidden? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel 2007 errors on chart changes
I can record a macro in protected mode. But when I try to run it, I
get an error.??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Errors in Excel 2007 Calculation | Excel Discussion (Misc queries) | |||
| Excel 2007 UDFs result in #REF! errors | Excel Programming | |||
| excel 2007 getting errors with mround | Excel Worksheet Functions | |||
| print errors excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 charting errors with pivot tables | Charts and Charting in Excel | |||
Linear Mode
