Excel 2003 Print hidden sheet 2

[JudyL]

I want to keep a final calculation sheet hidden from the user but I want to be able to print it and only that sheet. Is there a way to do this without making the sheet visible?
I need to do the same thing for print preview.

 

[SkipVought]

YES!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JudyL]

So, what is the code to use this "camera" tool?
I have
RG.CopyPicture xlScreen, xlPicture
with RG being my range.

 

[SkipVought]

that should work.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JudyL]

Okay. That is what you meant. Thanks
That works perfectly.

 

[SkipVought]

Actually the Camera tool works a bit differently than a SNAPSHOT, because it reflects CHANGES to the copied area subsequent to the paste operation.

So once you have your sheet range camera-copied and pasted into another sheet, then any changes that occur in the target sheet will be reflected in the pasted picture copy.

You can see the difference, after selecting a Picture object like the one you coded, or a Camera-generated picture object, which has a REFERENCE in the Formula Bar.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JudyL]

First, how do you use the Camera tool? It sounds like it actually makes the picture a link. I don't need to do that but want to know how to actually code to use the Camera Tool.

 

[SkipVought]

Select a range

Activate the Camera (you get a small fine +)

select a cell where you want the result to start in, in order to paste it.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JudyL]

How do you activate the camera?

Also, I tried having the BeforePrint event call my code to copy and paste to let people print from there but every time I try to print from that workbook, it starts the BeforePrint again. Not sure what to do about that.

 

[SkipVought]

You have to Application.EnableEvents = False

Camera tool...

Right click in the toolbar

select Customize...

Select the Commands tab

Select the Tools category

Scroll Commands to the Camera Icon

Drag to an existing toolbar.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[JudyL]

Thanks. Good to know