Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2014, 01:29 AM
Villalobos Villalobos is offline Disable "Save" & "Save As" & "Print" ribbon Windows 8 Disable "Save" & "Save As" & "Print" ribbon Office 2013
Novice
Disable "Save" & "Save As" & "Print" ribbon
 
Join Date: Jul 2014
Posts: 7
Villalobos is on a distinguished road
Default Disable "Save" & "Save As" & "Print" ribbon

Hello,



I would have one more question. How is it possible to disable "Save", "Save As" and "Print" ribbon through vba?
Reply With Quote
  #2  
Old 07-13-2014, 04:36 PM
macropod's Avatar
macropod macropod is offline Disable "Save" & "Save As" & "Print" ribbon Windows 7 32bit Disable "Save" & "Save As" & "Print" ribbon Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You can intercept the Save, Save As & Print functions via macros named FileSave, FileSaveAs and FilePrint, respectively. If you create these as empty macros, then noting can be saved or printed via the corresponding dialogs.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-14-2014, 06:20 AM
Villalobos Villalobos is offline Disable "Save" & "Save As" & "Print" ribbon Windows 8 Disable "Save" & "Save As" & "Print" ribbon Office 2013
Novice
Disable "Save" & "Save As" & "Print" ribbon
 
Join Date: Jul 2014
Posts: 7
Villalobos is on a distinguished road
Default

The FileSave and FileSaveAs working fine as you wrote it but the FilePrint disabling is not working for me. If I press the print button I can print it.

This is the code what I have use:

Sub FilePrint()
MsgBox "Function denied!", vbExclamation
End Sub

Do you have any idea what is the problem?
Reply With Quote
  #4  
Old 07-14-2014, 11:37 PM
Villalobos Villalobos is offline Disable "Save" & "Save As" & "Print" ribbon Windows 8 Disable "Save" & "Save As" & "Print" ribbon Office 2013
Novice
Disable "Save" & "Save As" & "Print" ribbon
 
Join Date: Jul 2014
Posts: 7
Villalobos is on a distinguished road
Default

with this I can disable the print function:

Private WithEvents App As Word.Application
Private Sub Document_Open()
Set App = Application
End Sub
Private Sub Document_Close()
Set App = Nothing
End Sub
Private Sub App_DocumentBeforePrint(ByVal Doc As Document, Cancel As Boolean)
Cancel = True
End Sub
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable "do you also want to save changes to the document template?" harassalog. wornways Word 30 06-04-2016 02:32 PM
Error: "Changes made were lost...reconnect with server", when switching "from" field randhurrle Outlook 2 02-25-2015 06:51 PM
When composing an e-mail how do I add "Page Layout" and "View" tabs to the ribbon CensorTilSin Outlook 1 12-11-2013 12:05 PM
Disable "Save" & "Save As" & "Print" ribbon How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM
Disable "Save" & "Save As" & "Print" ribbon Word 2010: "Screen shot" and "Print Screen" and fitting the page boundaries! Jamal NUMAN Word 4 06-30-2011 05:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:35 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