Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-20-2024, 05:38 AM
stu_c stu_c is offline Excel Script to print on sharepoint Windows 10 Excel Script to print on sharepoint Office 2016
Novice
Excel Script to print on sharepoint
 
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
 



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
Excel Script to print on sharepoint Print error OE6- script line 1344 HJJC Outlook 11 12-10-2005 09:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft