Solved

Print sheet but no command button

Posted on 2014-04-19
2
287 Views
Last Modified: 2014-04-19
Folks,
I have a module that prints my worksheets.
Sub PrintSheet()
    Dim UserResponse
    UserResponse = MsgBox(Prompt:="Print Worksheet (Yes) for Print Preview", Buttons:=vbYesNoCancel, Title:="Print Worksheet")
    Select Case UserResponse
        Case vbCancel
            Exit Sub
        Case vbYes
           ' ActiveSheet.PrintOut Preview:=True
           PrintToFit
        Case Else
        PrintToFit
             ActiveSheet.PrintOut Copies:=1
    End Select

End Sub

Open in new window


The "PrintToFit" is just another called module that scales the print to fit one page.

I would like to have the function that when a worksheet is print it does not print any of the command buttons as see below:
No print command button
0
Comment
Question by:Frank Freese
2 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 40010614
Go to the properties of each of the buttons and on the last tab there is an option to disable printing of the shape.
0
 

Author Closing Comment

by:Frank Freese
ID: 40010629
great but that was too easy - I'd never noticed that before
thanks - great job
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question