Printing workbook

[mjbanderson]

I may regret trying to do this myself, but I dont know til I try...

First off, I dont know VBA code, but there are some people here who do, so this may turn into a reference thread for them to accomplish this, unless I can somehow manage to get it done with help from forum members who are waaay smarter than me.

I asked our I.T department for a macro button in Excel to print the workbook(just a worksheet would be ok too) while always skipping over the first sheet. It can't leave any residual formatting behind after closing the file because some people here still need to print it out.

It's kind of a PITA to set the print preference to Pages 2-3 for every workbook I print out of, but that's what I currently have to do(or print out the unwanted sheet and then throw it away).

Any help would be appreciated, but understand if you want to pass on this one!

 

[mjbanderson]

Hey thanks! I will see if I can get the ball rolling, thanks to your help.
Now I see why you were asking the questions you were asking. Looks like you can set just about anything, as long as you know where/what to call it.

Thanks again!

 

[mole999]

i basically recorded what you wanted

 

[mjbanderson]

It's the terminology and format of Excel that I am not familiar with.
I, like most people who use Excel, only use 2% of the capacity of the software. It can do some crazy stuff...if you know how.

 

[mole999]

read my tag line