Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2003, sp2
Hi, I'm trying to hide columns X:IV so that the user only can see columns A:W. However Selection.EntireColumn.Hidden = True raises an error - "The hidden property cannot be set for the range class" (roughly translated from swedish). As far as I can see there aren't any objects in those columns. I also tried selection.clear but it still doesn't work. The area is totaly empty. If I try to hide the columns manualy from within excel I get the error message "Object cannot be moved outside sheet". Any ideas? Regards Pete |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hide columns but not the top rows | Excel Discussion (Misc queries) | |||
Hide rows when specified columns equal zero | Excel Discussion (Misc queries) | |||
Hide columns and rows | Excel Worksheet Functions | |||
Auto Hide Columns & Rows | Excel Discussion (Misc queries) | |||
Hide Rows and Columns | Excel Programming |