Print current screen button - Excel

[slipd]

Hey guys,

I need to make a button/macro that will allow me to print what's currently in view in excel...

Any thoughts? I tried Googling a few things but none of them have worked out

Cheers!

 

[izzop]

Hi,

Only currently in view in Excel e.g. A Print Screen of Excel?

I haven't tried this, but SnagIT I think would allow it...

SnagIT Dev Tools

If I get a chance I'll give it ago.

Regards

 

[Sin_Chase]

Currenty Active or currently in "view"?

This will do current active:

Sub PrintCurrent()
'
' PrintCurrent Macro
'

'
ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,2,,,TRUE,,FALSE)"
End Sub

Or you can record it yourself. Record MAcro File > Print > Select options you want > Print > Stop Recording

Customize ribbon/Toolbar. Select macro from pulldown menu . Add to workspace.

 

[slipd]

Thanks guys! It's for printing out page 1 only, the worksheet in view...

The spreadsheet fits on screen but prints out on about 6 side of a4 with bits and pieces all over the place! Macro it is then

Presumably when I do it will just look for the default printer? I ask because I may eventually pass this file on to colleagues and I don't want their file looking for my printer, if that makes sense

Cheers!

 

[izzop]

Hi,

To answer your question regarding the default printer. Yes, it will print to the default one.

Regards