Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding columns | Excel Discussion (Misc queries) | |||
Hiding columns | Excel Discussion (Misc queries) | |||
Hiding columns | Excel Programming | |||
Not Hiding Columns | Excel Programming | |||
Hiding columns in VB | Excel Programming |