| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hiding columns in VB
Trying to hide columns within my code and I am getting the
error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
You probably have something using all the columns.
use ctrl/end to find your last. Delete unneeded rows/columns and SAVE. -- Don Guillett SalesAid Software "Rick B" wrote in message ... Trying to hide columns within my code and I am getting the error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
No such luck. The last column used is HA, and Ctrl+End
returns the same column. -----Original Message----- You probably have something using all the columns. use ctrl/end to find your last. Delete unneeded rows/columns and SAVE. -- Don Guillett SalesAid Software "Rick B" wrote in message ... Trying to hide columns within my code and I am getting the error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
Is the sheet protected? If so, try unprotecting first.
-- Don Guillett SalesAid Software "Rick B" wrote in message ... No such luck. The last column used is HA, and Ctrl+End returns the same column. -----Original Message----- You probably have something using all the columns. use ctrl/end to find your last. Delete unneeded rows/columns and SAVE. -- Don Guillett SalesAid Software "Rick B" wrote in message ... Trying to hide columns within my code and I am getting the error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
Nope, I unprotect before hiding/unhiding columns in the
code. It was also unprotected when I tried to manually do it in Excel. -----Original Message----- Is the sheet protected? If so, try unprotecting first. -- Don Guillett SalesAid Software "Rick B" wrote in message ... No such luck. The last column used is HA, and Ctrl+End returns the same column. -----Original Message----- You probably have something using all the columns. use ctrl/end to find your last. Delete unneeded rows/columns and SAVE. -- Don Guillett SalesAid Software "Rick B" wrote in message ... Trying to hide columns within my code and I am getting the error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. . . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
|
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hiding columns in VB
Found it. There were cells that had comments, and the
properties were set to "Don't move or size with cells". First time I have ever run into that problem. Thanks for the help. Rick -----Original Message----- Is the sheet protected? If so, try unprotecting first. -- Don Guillett SalesAid Software "Rick B" wrote in message ... No such luck. The last column used is HA, and Ctrl+End returns the same column. -----Original Message----- You probably have something using all the columns. use ctrl/end to find your last. Delete unneeded rows/columns and SAVE. -- Don Guillett SalesAid Software "Rick B" wrote in message ... Trying to hide columns within my code and I am getting the error "Unable to set the hidden property", when trying to manually hide them within Excel I get the error "Cannot shift objects off sheet". There are merged cells within the range, however I get the same error, even if I unmerge them. This is a very large workbook, and this particular sheet is no exception. . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| hiding columns | Excel Discussion (Misc queries) | |||
| Hiding Columns | Excel Discussion (Misc queries) | |||
| Hiding columns | Excel Discussion (Misc queries) | |||
![Rick B[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
