Home

Control Buttons

pkbarnett
Occasional Visitor

I am setting up control buttons for printing on a workbook that has multiple tabs. (worksheets on each tab). Is there a way to put all of the control buttons (used for printing different sheets) on one tab at the beginning of the workbook? Currently when I attempt to do this, it only prints the range on the tab that has the control buttons even though the Macro's that were created are on each of the separate tabs. The macro's work correctly but when they are linked to the control buttons they only print the range on the tab with the buttons.

1 Reply

If you use buttons from the Forms set you can do it like this:
- Add a list of worksheet names to the first worksheet
- Next to each one, insert a button from the Forms buttons and attach it to the following macro:

Sub PrintIt()
Worksheets(Activesheet.Buttons(Application.Caller).TopLeftCell.Offset(0, -1).Value).Activate
'Now here goes your printing code, I assume it is the same for each sheet
End Sub

The code above assumes the button is in a column immediately to the right of the column with sheet names. Make sure the top-left corner is within that cell.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies