Hiding cells when printing worksheet 1

[Mikey2000]

How can I hide a cell or range of cells when printing a worksheet? I bring this up because I know in Visual Basic you can hide objects by setting the visual property to false, but I am not too familiar with VBA.

 

[SkipVought]

Hi,
You can hide formulae but not cells. If you look at Menu Item - Format/...
you see that Sheets, Rows and Columns can be Hidden...
But, alas, cells, NOT Skip,
metzgsk@voughtaircraft.com

 

[dsi]

You could, however, write a macro to cut/paste the data in the cells to another worksheet before printing and move them back after the fact. Not the prettiest method, but it could accomplish what you are after.

 

[dsi]

Hit Submit and thought of something else. You could change the font of the cells to match the background color, print, then change the font color back.

 

[Mikey2000]

Thanks for your help. I took your advise and ended up creating a new print button that changed the font color, hid the button, printed the sheet, changed the font color back, and then made the button visible again.

It works great!

 

[SkipVought]

dsi,

Good CAN DO - OUT-OF-THE-BOX thinking ==> STAR!!! Skip,
metzgsk@voughtaircraft.com

 

[dsi]

Glad to help!

Mikey: You may not need to hide the button. If you open the properties window you will see that there is PrintObject property that you can just set to False. This will keep it displayed but will not print.