Thread: Hiding Columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Squid[_4_] Squid[_4_] is offline
external usenet poster
 
Posts: 2
Default Hiding Columns

I have a spreadsheet where I recreated a standard form my company uses.
Therefore I needed to merged some rows. There is one column that I would
like to hide from being printed.

If I manually highlight column K, (right click) click Hide. It hides just
column K. no problem.

But if I when use the following code in the BeforePrint event it will hide
more than just column K, I assume because there rows within column K that
are merged.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Columns("K:K").Select
Selection.EntireColumn.Hidden = True
End Sub

Any suggestions?

TIA
Mike