Macro Button

  • Thread starter Thread starter T. R.
  • Start date Start date
T

T. R.

I have an workbook with 31 sheets (one for each day of the
month) I would like to create a print macro with a
corresponding button.

Is there a way to use only one button and depending on the
sheet that I am currently on, only print the range on that
specific sheet?

Thanks in advance.

T.R.
 
T.R.
In your macro, don't refer to any sheet name. Simply provide the range to
print and issue a print command. The code will print that range on the
active sheet. HTH Otto
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Help to create a macro 2
problems getting this macro to work 23
Excel Monthly Spread sheet. 12
copying macros to other sheets 3
Print Macro 5
Resetting up Excel 2003. Is there a fast simple way to re-associatemacros with macro buttons? 1
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0

Back
Top