![]() |
|
#1
|
|||
|
|||
|
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
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Open excel files from sharepoint by using word wba | gomezaka | Word VBA | 7 | 11-04-2021 08:23 AM |
| Running calendar script in Excel | map112418 | Excel | 0 | 03-29-2021 01:13 PM |
| Excel Template to Sharepoint List | sforney123 | Excel | 0 | 11-07-2011 08:10 AM |
| Creating Sharepoint Folders from Excel VBA | rst | Excel | 0 | 11-16-2009 11:39 AM |
| Print error OE6- script line 1344 | HJJC | Outlook | 11 | 12-10-2005 09:43 AM |