Microsoft Office Forums - View Single Post - Excel Script to print on sharepoint

Thread: Excel Script to print on sharepoint

View Single Post

Old

09-20-2024, 05:38 AM

stu_c

stu_c is offline

stu_c uses Windows 10

Windows 10 stu_c uses Office 2016

stu_c uses Office 2016

Office 2016

Novice

The original poster

Join Date: Dec 2013

Posts: 20

stu_c is on a distinguished road

Default

Excel Script to print on sharepoint

Hi all
we have an excel spreadsheet that is on SharePoint
I want to make a button the user clicks on that will automatically print selected cells and make 2 copies how do I do this in script?

I have tried the below but shows errors?

Code:

Sub PrintPaper()

ActiveSheet.Range("Your:RangeHere").Select

Selection.PrintOut Copies:=1

End Sub

Reply With Quote