Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hola,
I'm using Excel 2007. I have a table defined on a protected worksheet. It works great when the worksheet is unprotected, but when I protect the worksheet (within a macro) and then try to sort, filter, etc. (outside of the macro), I get the following error message: "The cell or chart you are trying to change is protected and therefore read-only." I've read similar entries within this site, and it looks that I´m still missing something. Here is the code: ' Range("Dashboard_Data_Table[[#Headers],[Project ID]]").Select ActiveSheet.ListObjects("Dashboard_Data_Table").Ra nge.AutoFilter Field:=3, _ Criteria1:="<" Range("A1").Select ' ActiveSheet.Protect DrawingObjects:=False, contents:=True, Scenarios:= _ True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _ AllowFormattingRows:=True, AllowSorting:=True, AllowFiltering:=True, _ AllowUsingPivotTables:=True, userInterfaceOnly:=True, Password:="password1" ' Help is higly appreciated. Regards OMER |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table in Protected Worksheet | Excel Programming | |||
Enable page area of pivot table on protected worksheet | Excel Programming | |||
Enable the page area only of a pivot table for protected worksheet | Excel Discussion (Misc queries) | |||
Enable OLAP Pivot Table in Protected Excel 2003 Worksheet | Excel Programming | |||
Enable OLAP Pivot Table in Protected Excel 2003 Worksheet | Excel Programming |