Do not print a button when print
I have a button on a worksheet and sometime ago I have set/written code to
hide the button when printing. I forget I set the property or by macro. |
Do not print a button when print
In 'Design Mode', right click your button, and Select 'Properties' from the
context menu, in the properties dialog you will find a property called 'PrintObject', set this to either Yes or No depending on your preference. HTH Neil www.nwarwick.co.uk "Man Utd" wrote: I have a button on a worksheet and sometime ago I have set/written code to hide the button when printing. I forget I set the property or by macro. |
Do not print a button when print
Sorry, how do I go into Design Mode ?
"Neil" wrote in message ... In 'Design Mode', right click your button, and Select 'Properties' from the context menu, in the properties dialog you will find a property called 'PrintObject', set this to either Yes or No depending on your preference. HTH Neil www.nwarwick.co.uk "Man Utd" wrote: I have a button on a worksheet and sometime ago I have set/written code to hide the button when printing. I forget I set the property or by macro. |
Do not print a button when print
Viewtoolbarscontrol toolbox, click on the triangle/ruler/pencil
-- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "Man Utd" wrote in message ... Sorry, how do I go into Design Mode ? "Neil" wrote in message ... In 'Design Mode', right click your button, and Select 'Properties' from the context menu, in the properties dialog you will find a property called 'PrintObject', set this to either Yes or No depending on your preference. HTH Neil www.nwarwick.co.uk "Man Utd" wrote: I have a button on a worksheet and sometime ago I have set/written code to hide the button when printing. I forget I set the property or by macro. |
All times are GMT +1. The time now is 11:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com