hi,
what are you trying to do?
I ran you code(that you posted) and it worked ok.
i cleaned it up a little.
Sub test1()
Columns("C:C").EntireColumn.Hidden = True
Columns("J:J").EntireColumn.Hidden = True
Columns("A:B").EntireColumn.Hidden = False
Columns("D:I").EntireColumn.Hidden = False
Columns("K:N").EntireColumn.Hidden = False
End Sub
what do you mean "only J stays hidden"?
you ran a test with hidden columns. what was no problem?

confused
FSt1

"Bob Barnes" wrote:

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