Good Morning All
wondering if there is such as a button that can take a snapshot of a preselected set of cells, kind of like a macros. I know there is a "Camera" feature for excel but something to the extent of me being able to click or doubleclick on a image i pasted on my sheet that takes a snapshot and creates a PDF out of it. Maybe its too much to ask, just wondering though.
Thank You all in advance
You can use a selection of cells or a specific range of cells to pdf.
This will pdf a specific range a cells.
If you wanted to pdf a selection change "rng" to "selection"
Please Login or Register to view this content.
Thank you for your prompt reply, im new to VBA. How do i activate the vba? is there a way for it to be attatched to a button or picture? also am i able to type %USERPROFILE%\Desktop\PDF_Snapshot_Of_Excel.pdf instead of a predetermined path such as C:\users\... path?
error posting
Last edited by jlara0687; 09-24-2018 at 11:49 AM. Reason: error posting
Right click on the button /picture =>assign macro, and assign the macro to it.
Edit the code to save it the way you want.
Thank You, Works great! How, if at all possible, can i make the pdf printout come out all in one page? are there more options i can choose from?
Thanks Again
Normally the pdf will print in the same way as your printer settings
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks