Hide Macro Button when printing

Eduardo Care · #7 11-09-2015, 04:19 PM

Hi Paul i end up using the second alternative you suggest me, for anyone interested ill leave the code:

Code:

Sub FilePrint()
    With Application.ActiveDocument
        If .ProtectionType <> wdNoProtection Then _
        .Unprotect Password:="Password"
        With ActiveDocument
            .Styles("TEST1").Font.Hidden = True
            Application.ScreenRefresh
            Dialogs(wdDialogFilePrint).Show
            .Styles("TEST1").Font.Hidden = False
         .Protect wdAllowOnlyReading, True, "Password"
        End With
    End With
End Sub

Its just a macro that unprotect the document, next i use macro Paul told me to use to hide the text, and finally reprotect the document.

This macro can hide any kind of text you might need, not only macro buttons so i hope someone else find i usefull, all you need to do its change the style of the text you want to hide, in my case i create a new one that i call "TEST1" but you can name it as you wish.

Thanks alot Paul, you saved me.

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