Macro to print from a VERY hidden worksheet

[dawondr]

Happy Saturday All,

I have a workbook I built with only 2 sheets visible and several VERY hidden. On one of the very hidden sheets named “training” I have not only formulas and numbers but I also have a summary area that my print area is set to only print out. What I was hoping I could have done was placed a “print” button on one of the non-hidden sheets and when it is pressed it would also print the area on just the very hidden training tab. Is that possible? I saw a few macro’s to print a hidden sheet but it didn’t work for me and I am assuming that is because mine is set for very hidden?
Can this be done? If it can I saw on the other type a way to not show the screen updating so that no one would see it is unhidding, printing and then re-very hiding the sheet

Is this something anyone can please help me with?

Thx in Advance,

Dave

[shg]

Please Login or Register  to view this content.

[dawondr]

Thx, I'll give it a try...

[shg]

You're welcome.

[dawondr]

SHG, I hope you are still monitoring this thread, I do have a follow up question. Your code worked perfectly but while reading some other threads it mentioned how to not have the screen flash to my hidden page while it was running. It said to do so to add at the beginning this line of code Application.ScreenUpdating = False
I've tried adding it at every point can't seem to get it to work, do you know where it should go? What the description on the page I read said was:

Of course, unhiding and later hiding worksheets can cause a lot of flashing on the screen as Excel tries to update its screen display based on the commands executed in your macro. If you want to avoid this, then use the following line of code at the beginning of your macro:

Application.ScreenUpdating = False
With screen updating turned off in this way, nobody will ever know that you unhid a worksheet and later rehid it. Make sure that before ending the macro, however, you set the ScreenUpdating property back to True.

This add in would be great but if not yours works perfect. I was just hoping u could help me figure out where to insert it.

Thx,

Dave

[martindwilson]

normally

Please Login or Register  to view this content.

[dawondr]

Hi Guru, it gives me an error that says:

Run-Time '9':

Subscript out of range

any tjoughts?

[dawondr]

sorry, i got it. I forgot to change the name back to the hidden sheet name. Thank you for the help

[dawondr]

Is it possible to password protect this macro from running? and if I wasnt to print more than 1 sheet would it just be ,sheet2name,sheet3name?