Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
Try this...
Columns("X:IV").EntireColumn.Hidden = True Rick "PO" <h wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
That doesn't work either. If I try the same code on a new worksheet it
works. It's just this sheet which contains some formulas and formatting - nothing special. As I said, the cells are empty, they don't contain any named ranges and they aren't part of any print area. It's some kind of a mystery really :( Regards Pete "Rick Rothstein (MVP - VB)" skrev i meddelandet ... Try this... Columns("X:IV").EntireColumn.Hidden = True Rick "PO" <h wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
You have your sheet protected, don't you? Try these 3 lines instead...
ActiveSheet.Unprotect Columns("X:IV").EntireColumn.Hidden = True ActiveSheet.Protect or, if not running from worksheet's code window, change the ActiveSheet reference to the worksheet's name reference... Worksheets("Sheet1").Unprotect Worksheets("Sheet1").Columns("X:IV").EntireColumn. Hidden = True Worksheets("Sheet1").Protect Rick "PO" <h wrote in message ... That doesn't work either. If I try the same code on a new worksheet it works. It's just this sheet which contains some formulas and formatting - nothing special. As I said, the cells are empty, they don't contain any named ranges and they aren't part of any print area. It's some kind of a mystery really :( Regards Pete "Rick Rothstein (MVP - VB)" skrev i meddelandet ... Try this... Columns("X:IV").EntireColumn.Hidden = True Rick "PO" <h wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
Hi
Neither the sheet nor the book are protected. The funny thing is, if I broaden col W (columnwidth = 39) I can hide the rest of the columns. Pete "Rick Rothstein (MVP - VB)" skrev i meddelandet ... You have your sheet protected, don't you? Try these 3 lines instead... ActiveSheet.Unprotect Columns("X:IV").EntireColumn.Hidden = True ActiveSheet.Protect or, if not running from worksheet's code window, change the ActiveSheet reference to the worksheet's name reference... Worksheets("Sheet1").Unprotect Worksheets("Sheet1").Columns("X:IV").EntireColumn. Hidden = True Worksheets("Sheet1").Protect Rick "PO" <h wrote in message ... That doesn't work either. If I try the same code on a new worksheet it works. It's just this sheet which contains some formulas and formatting - nothing special. As I said, the cells are empty, they don't contain any named ranges and they aren't part of any print area. It's some kind of a mystery really :( Regards Pete "Rick Rothstein (MVP - VB)" skrev i meddelandet ... Try this... Columns("X:IV").EntireColumn.Hidden = True Rick "PO" <h wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
Solved it. It turnes out that one of the comments is to broad. It's reaching
into col X when visible. Regards Pete "PO" <h skrev i meddelandet ... 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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cannot hide columns/rows
Well, I would not have ever thought of **that** as the problem. Thanks for
posting that you found the problem and what the solution was. I did some testing on different cells and found some differences in how Excel reacts to comments. Most of the time, simply having the comment touch a cell, even partly, was enough to block its column from being hidden; however, in some other cases, a partially touched column was able to be hidden and, when that happened, the comment was physically shown on the other side of the cell it was attached to (with the pointer arrow going straight across the cell). Now I didn't test too much, but I could not find anyway to control making this happen (I was able to make it happen only twice). Rick "PO" <h wrote in message ... Solved it. It turnes out that one of the comments is to broad. It's reaching into col X when visible. Regards Pete "PO" <h skrev i meddelandet ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |