Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
Reply

Thread Tools
Display Modes


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 11:33 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