PDA

View Full Version : Solved: Trouble Hidding Columns



makako
08-15-2006, 02:06 PM
Hi, Im having some problems with hidding specific columns. In the second row there are marks that identify the column according to its content. In a workbook_open sentence i created a commandbar that only shows the data i want (Control) in each of its buttons. The problem is I have deleted images, unmerged cells, etc. but I still have an error message concerning objects. Any help deeply apreciated

Bob Phillips
08-15-2006, 02:32 PM
It's the comments that is the problem, see

http://support.microsoft.com/default.aspx?kbid=211769
"Cannot shift objects off sheet" error message when you hide columns in Excel

But you will also have trouble with



For lvContador = 0 To Range("McInicioTipo").CurrentRegion.Cells.Count - 1
If Not IsError(Range("McInicioTipo").Offset(, lvContador).Value) Then


as the n umber of cells in currentregion could exceed 256, the number of columns. You probably want



For lvContador = 0 To Range("McInicioTipo").CurrentRegion.Columns.Count - 1
If Not IsError(Range("McInicioTipo").Offset(, lvContador).Value) Then

makako
08-15-2006, 03:50 PM
thanks a lot, so basically one must set each object to lvShape.Placement = xlMoveAndSize and turn all comments visible.