Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

onprint -> commandbutton visible false

Status
Not open for further replies.
kingz2000

kingz2000

Programmer
May 28, 2002
304
DE
Hi,

I have a VBA Excel program, whereby I have a button on the excelsheet to update data from my Database. However when I print the results, I don't want the button to be seen, how do I get rid of it , just for the printed output...????

Thanks in advance.
 
Sort by date Sort by votes
Right click your CommandButton, choose the Properties sheet and set the PrintObject to False.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EliseFreedman
  • Locked
  • Question
Controlling which columns are visible when drilling down in a pivot table
Replies
2
Views
388
combo
combo
jpgactmod
  • Locked
  • Question
CommandButton not working on vbModeless Form
Replies
2
Views
195
jpgactmod
jpgactmod
Calhoun99
  • Locked
  • Question
Using “Application.DisplayAlerts = False gives ”Method or Data Member not found" compile error 1
Replies
4
Views
461
Calhoun99
Calhoun99
VicM
  • Locked
  • Question
Workbook not always visible when opened in VBA 1
Replies
15
Views
244
VicM
VicM
NewUserMo
  • Locked
  • Question
Loop only Visible Cells
Replies
2
Views
105
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top