Hide columns before printing and show after

Hi everybody

I have this sheet and there's a column where I place all the buttons and stuff which I don't wan't to show when printing.

I need a routine that hide the specific column in the beforeprint event and show it after.

Also, I don't want the whole printing configuration to be automated, I want the user to select the settings that suits him best, such as scale, margin size and stuff.

Thanks in advance!

It's not just buttons, it is a lot of stuff. Some of it is text/formatation embed in cells

Originally Posted by vlady

hello
can you try this one.

End Sub

Please Login or Register  to view this content.

HTH

Hm... What about the moment when the columns are shown back?