Visual Basics code

  • Thread starter Thread starter Simran
  • Start date Start date
S

Simran

Hello,

I created a macro and button to print out every
worksheet on an excel workbook. However every time I add
a new worksheet I have to re-create the macro. How can I
set it to automatically print out every worksheet on the
workbook no matter how many I add in the future?

Thanks for any help.
 
Post your macro code. Probably will have to be
for each ws in worksheets
printmacro here
next
 
You should just be able to change your code to:
Activeworkbook.PrintOut Copies:=1, Collate:=True or False your preference.

HTH
 

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 Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 0
Excel VBA - Problem with Closing Print Preview 0
Macro code behind button 1
Auto insert of a pivot table? 1
Collapsing all groups 0
how to make a macro to clear multiple cells from multiple worksheets? 2
why do print range erase in Excel when import data from access 1

Back
Top