Coopercell
New Member
- Joined
- Apr 3, 2016
- Messages
- 7
Hi
I am after a code which can print a hidden page but I need the code to work accross multiple pages and print out the respective page for each sheet. I am trying to do it using one code otherwise I could end up 20+ different print codes.
Example.
Sheet 1 print hidden sheet 2
Sheet 3 print hidden sheet 4
etc.
I was thinking of putting in the sheet number in a cell on sheet one line (X1).
I also need the code to return back to the starting sheet when done.
I am after a code which can print a hidden page but I need the code to work accross multiple pages and print out the respective page for each sheet. I am trying to do it using one code otherwise I could end up 20+ different print codes.
Example.
Sheet 1 print hidden sheet 2
Sheet 3 print hidden sheet 4
etc.
I was thinking of putting in the sheet number in a cell on sheet one line (X1).
I also need the code to return back to the starting sheet when done.