If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Visual Basics code
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. |
#3
|
|||
|
|||
Visual Basics code
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. |
Thread Tools | |
Display Modes | |
|
|