Visual Basics code

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

"Simran" wrote in message
...
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.

You should just be able to change your code to:
Activeworkbook.PrintOut Copies:=1, Collate:=True or False your preference.

HTH
"Don Guillett" wrote in message
...
Post your macro code. Probably will have to be
for each ws in worksheets
printmacro here
next

"Simran" wrote in message
...
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.