is there a way to do 4 instructions with one macro
 

hi
i would like to do 4 things with 1 macro (assigned to a button on my sheet),
would it be possible - how?
1. save the workbook
2.print the required range
3.close the workbook
4.open new template i created
thanks

is there a way to do 4 instructions with one macro
 

The macro recorder is your friend. Try it and post back with questions or
requests for simplification.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"des-sa" wrote in message
...
hi
i would like to do 4 things with 1 macro (assigned to a button on my
sheet),
would it be possible - how?
1. save the workbook
2.print the required range
3.close the workbook
4.open new template i created
thanks