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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.