Thread: Hidden Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Barnes Bob Barnes is offline
external usenet poster
 
Posts: 134
Default Hidden Columns

Running on AUTO_OPEN..

Columns("C:C").Select
Selection.EntireColumn.Hidden = True
Columns("J:J").Select
Selection.EntireColumn.Hidden = True
Columns("A:B").Select
Selection.EntireColumn.Hidden = False
Columns("D:I").Select
Selection.EntireColumn.Hidden = False
Columns("K:N").Select
Selection.EntireColumn.Hidden = False

...but only Column J stays hidden.

I ran a test..running automation to Excel w/ hidden columns..NO problem.
Will that always be true? If so, best to Hide Columns C and J with no code?

TIA - Bob