Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default 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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
print button text Mike Excel Discussion (Misc queries) 0 January 31st 06 08:21 PM
print button Caveman Excel Discussion (Misc queries) 2 November 18th 05 12:44 PM
how to add a print tab or button in a cell SimonJ Excel Discussion (Misc queries) 1 October 17th 05 01:59 PM
In excel: when in print preview, 1 button to 'maximise margins' Sa Gested Excel Worksheet Functions 0 August 3rd 05 01:46 PM
How do I create a print button? Dan Excel Worksheet Functions 3 April 28th 05 03:56 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"