Hide Macro Button when printing

		Microsoft Office Forums > Microsoft Word > Word VBA
Hide Macro Button when printing

FAQ

Thread Tools

Display Modes

11-04-2015, 08:01 PM

macropod

Windows 7 64bit Hide Macro Button when printing

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

You could instead apply a unique Style to each of the ranges whose visibility you want to toggle, then simply change the Style's font visibility attribute. For example:

Code:

Sub FilePrint()
With ActiveDocument
  .Styles("Instructions").Font.Hidden = True
  Application.ScreenRefresh
  Dialogs(wdDialogFilePrint).Show
 .Styles("Instructions").Font.Hidden = False
End With
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Want to show/hide mutiple grouped coloumns in Excel sheet with a button	abutahir	Excel	4	11-03-2015 01:07 PM
How to hide the Audio Icon while PRINTING	chrismhart	PowerPoint	1	10-30-2014 03:33 PM
Hide Checkbox When Printing	vinceplunkett	Word	1	12-03-2013 01:53 AM
Assign macro but hide the button/field	trlear	Word VBA	5	02-23-2012 04:35 PM
Button in hidden section won't hide	Joe Patrick	Word	6	06-07-2011 09:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:18 AM.