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
 
Back
Top