View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steph[_3_] Steph[_3_] is offline
external usenet poster
 
Posts: 312
Default Code to hide columns problem

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.