Web Development

Ask something
Discussion Locked

Excel Macro

0 helpful
4 replies

by megan26

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I know how to create macros in Access. How do you create a print macro on a worksheet in Excel referencing another worksheet within the book? I can not get it to work.

4 replies

by dklippert

One of the easiest ways is to go to Tools>Macros
Record New Macro.
Walk through the steps and then turn the recorder off.
You'll find that what Access calls macros is not the same as macros in Word/Excel etc.
Access strings prewritten procedures to gether and call them Macros.
Other applications use VBA--what Access calls Modules.

by megan26

what are the steps to do a print macro then? I have a button that I want it to select a certain worksheet and print that. I have gotten to the record a new macro but then I am lost from there.

by dklippert

Sub PrintSheet2()
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.PrintOut
Sheets("Sheet1").Select
End Sub

This discussion is closed to new replies.