Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-25-2023, 01:42 AM
Cesarone82 Cesarone82 is offline Avoid printing command button Windows 11 Avoid printing command button Office 2010
Novice
Avoid printing command button
 
Join Date: Aug 2023
Posts: 8
Cesarone82 is on a distinguished road
Default Avoid printing command button

Hi,


I think this is something already discussed in various forums but the solution I tried didn't seem to work, basically I have a button searching data on a dabase on click. I don't want it to be printed.
I tried some code found in different forums and I also tried if I could add it to the QAT, but i m not very good understanding macro stuff, and I cannot see the command in the macro list on the QAT menu.
Any help would be appreciated, I include the DB / word file in the link below.

WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free
Reply With Quote
  #2  
Old 08-25-2023, 03:06 AM
gmayor's Avatar
gmayor gmayor is offline Avoid printing command button Windows 10 Avoid printing command button Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The simplest approach is to avoid the button and use the ribbon - see attached
Attached Files
File Type: zip Template modulo01.zip (497.7 KB, 3 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 08-28-2023, 01:01 AM
Cesarone82 Cesarone82 is offline Avoid printing command button Windows 11 Avoid printing command button Office 2010
Novice
Avoid printing command button
 
Join Date: Aug 2023
Posts: 8
Cesarone82 is on a distinguished road
Default

Thanks gmayor, you really made my day! As I understood you did not modify the quickaccess toolbar but instead you customized the ribbon, can you give me a site where it is explained how you do that?
Thanks again.
Reply With Quote
  #4  
Old 08-30-2023, 03:00 AM
gmayor's Avatar
gmayor gmayor is offline Avoid printing command button Windows 10 Avoid printing command button Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

See Customize the Office Ribbon (It doesn't take rocket science)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button. To multi command Taylormations Word VBA 11 09-14-2020 02:39 AM
Command Button herman777 Excel Programming 2 06-02-2019 06:45 AM
Show table list by using chek box command and save document on sharepoint by using command button Zhibek Word VBA 3 08-16-2018 06:19 PM
Help with a Command Button dkohnken Word VBA 5 03-18-2015 10:13 PM
Avoid printing command button Command Button cksm4 Word VBA 7 02-27-2011 08:47 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:27 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft