Desu Nota from Columbus
Well-known Member
- Joined
- Mar 17, 2011
- Messages
- 556
I need to "print"all sheets labeled SOP (I am actually only printing to PDF). I have 500+ files that have multiple sheets, and each file has a sheet called "sop".
The problem is that I can't just highlight all the files and convert to PDF because they only convert the sheet active upon loading (default sheet).
Is there a way to force excel to either print all sheets labeled SOP or a way to have it automatically pull up sheet "sop" when the file is opened--set "sop" to the default sheet?
Thanks.
The problem is that I can't just highlight all the files and convert to PDF because they only convert the sheet active upon loading (default sheet).
Is there a way to force excel to either print all sheets labeled SOP or a way to have it automatically pull up sheet "sop" when the file is opened--set "sop" to the default sheet?
Thanks.
Last edited: