Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi. I wrote what I thought was going to be simple code. I added
check boxes to my workbook using the control toolbox. The following code is called by one checkbox. All I am trying to do is hide columns A:D on 4 spreadsheets. When I run this I get the error Compile Error: Invalid Outside Procedure. Public SheetArray As Sheets set shtarray = Sheets((DomShip, ConShip, IntShip, FinShip)) 'these sheets are named in the properties window Sub HideQtly2003() Application.ScreenUpdating = False shtarray.Columns("A:D").EntireColumn.Hidden = True Application.ScreenUpdating = True End Sub Any ideas? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vb code to hide columns | Excel Discussion (Misc queries) | |||
Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
Hide columns code | Excel Discussion (Misc queries) | |||
hide code does not hide | Excel Discussion (Misc queries) | |||
Hide Columns before Print problem | Excel Programming |