Macro To Print Screen

May 27, 2009

Is there a feature or VB code that will take a screen shot in excel for the sheet that I have active?

What I would like to do is run a macro that does a few things, then takes a screen shot and bundles it up in an email to send (Outlook on Exchange). Since the report is 30 MB it cannot be emailed and taking the time to compose a report w/screen shot takes too much time.

View 9 Replies


ADVERTISEMENT

Application Onkey: Prevent Users From Using The Print Screen Or The Alt Print Screen Buttons On The Keyboard

Dec 29, 2009

I'm just looking to prevent users from using the print screen or the alt print screen buttons on the keyboard. I have this script that works if I use "39" (Right Arrow)but wont work if I use "42" (Print Screen Button).

View 5 Replies View Related

Print Screen

Jul 6, 2007

macro minimizes excel takes a print screen of the application behind excel then pastes it in a word document then maximizes excel screen again

View 9 Replies View Related

VBA That Will Print Out Screen In Landscape?

Apr 8, 2014

Code:

Private Sub CommandButton2_Click()
Me.PrintOut
End Sub

Is there a VBA that will print out the screen in landscape? The above code seems to only print in portrait.

View 3 Replies View Related

VBA: Using SendKeys To Print The Screen

Mar 13, 2008

I would like to emulate hitting the Alt+Ctrl+"Print Screen" button on the keyboard with the following code. I know there are some restrictions around using the PrintScreen with the SendKeys, but I'm hoping I can still figure out how to make this work.

Following is the first part of a larger macro I've set up. If I can just get this to work, that would be perfect.

Sub PrintTheScreen()
Application.SendKeys "^%" & "PRTSC"
End Sub

View 9 Replies View Related

What I Print Looks Different From What My Screen Shows

May 6, 2008

I have a WYSIWYG problem: what I see on the screen is NOT what I get out of the print job.

I commonly have the problem when working with Excel objects (any kind of shape, text box, line, graph) in that the layout looks great on the tab that I created, but when I go into PrintPreview or actually print it out, the shapes don't quite align with what I had built in the tab. Where I thought I had lines joining, the print out shows them crossing at other points. If I then go back to the tab and look at the layout on the regular screen, it looks fine.

This problem can be easily understood if you try to create a triangle by drawing three lines (non-overlapping lines that cross only at the vertices). Note that the lines either prematurely cross, or don't intersect at all when you print it out.

THis problem is even magnified when using the camera function to take a "snapshot" of a graph or other objects. In fact, it has the tendency to even "mess up" the graph's formatting, regarding the arrangement of titles and axes (often making them overlap).

View 9 Replies View Related

Show Rows On Screen But Not Print Them?

Aug 17, 2006

On a spreadsheet in excel from office xp, is it possible to display a row on the screen, but when you print the sheet it doesn't get printed? How do I do that?

I tried hiding the row, but the admin wants to be able to see it on screen and complained too tedious to unhide it on screen then hide it for printing.

I have never written macros for excel so not sure if there is a solution there, or if it can be done another way.

I also thought we could have the data from the row in another sheet that doesn't get printed, but she (the admin) preferred the hide/unhide solution.

View 3 Replies View Related

Excel 2013 :: VBA - Trigger Event On Print Screen

Jun 27, 2014

I have a project report, which is user-configurable, allowing the user to customise the data that is displayed based on a number of parameters.

To ensure the report always prints neatly (the number of visible columns and rows varies, depending on the above parameters), so I have a macro that dynamically sets the print area of the worksheet.

At present, I call the macro from the workbook.beforeprint event, which works fine in terms of printing. Ideally however, I would like the macro to be called when CTRL+P is first pressed - i.e. the resulting 'print screen', containing a preview of the print out should reflect what will subsequently be printed, when the 'Print' button is then pressed.

I am not sure if this makes sense (Excel 2010 and 2013 are different from previous versions).

View 5 Replies View Related

Excel Camera Tool - Print Preview Different From Display On Screen

Nov 27, 2012

I have place a camera-picture of a table on the right side of a chart. On the screen it looks great! (See below - with some redaction)

Problem Example.png

.... but when I print it the table expands off of the side of the chart. Scale is 100%, zoom is 100%, Excel 2010 (See below - with some redaction). Whether or not I have a print area does not seem to make a different in the problem. Also, it appears that this happens with any shape I put in that place, it's not specific to the camera tool.

Problem Example_Print Preview.png

View 8 Replies View Related

How To Clear Contents Of Clipboard Before Tool Takes Screen Print In Excel VBA

Apr 20, 2014

I've have a tool/code that takes the screen prints of the active window (when I press F9) and pastes it in a word document.

But whenever I do copy some text or any other image and when I press F9 to take the screen print of the active window. I get the text pasted into the word, this is because the clipboard content has text first and then the screen print of the active window.

Instead When I press F9, I wanted the below to happen

1. Content from the Clipboard should be cleared

2. Take the screen print

3. Paste it in the word document.

Note: My tool/code already does 2 and 3. Looking for 1 alone, ,

View 4 Replies View Related

Macro To Print Sheets With Value In Cell A1 But Print Dynamic Ranges On Certain Sheet

Sep 24, 2013

I've found some code which works to print certain pages with value in cell A1 but I need to print dynamic ranges on some of the sheets as they will have filters on so the rows ranges will be different each time.

So far this is what I have but the dynamic range part is not working:

VB:
Sub Print_All_Worksheets_With_Value_In_A1()
Dim Sh As Worksheet
Dim Arr() As String
Dim N As Integer

[Code] ....

View 3 Replies View Related

Stop Print Macro Firing Before Print Event

Oct 18, 2006

I have a "submit" button macro which user would click after he has finished his input. This macro would update a reference number on the worksheet named "orange" and then print out this worksheet.

My purpose is "orange" is printed out with a reference number.

Below is the 1st code.....

View 9 Replies View Related

Macro Adds A Bar On The Screen

Oct 10, 2008

I have a macro launched from a command button that sometimes puts a bar at the left side of the window. When it executes the line Sheets("graph").Select the first line in the macro it puts the bar at the right side of the window. The characteristics of the bar are:

1) It is associated with the main excel window - if you minimize the window containing the worsheet the bar is still visible

2) It is one of two widths, about 1/4" or about 2.5"

3) If you move an Excel toolbar to the left side of the screen the bar disappears. If you move the toolbar back to the top of the page it doesn't return but it can appear the next time you run the macro.

4) It only appears some times you run the macro - I can go days without seeing this problem and then it happens every time I run the macro.

View 9 Replies View Related

Macro Causes Screen To Flash

Jun 9, 2006

I created a macro, assigned to a menu button, that selects and prints a range on the active sheet. I created the macro with the recorder, then edited it to eliminate the excess. When I run the macro, though, it takes up to ten seconds to print the page and the screen flashes repeatedly while it's running. I also noticed that the length of the delay and the number of flashes seems to be related to the number of lines of code, because the delay was much longer and the flashing more excessive before editing.

Sub PrintContrReview_Click()
ActiveSheet.PageSetup.PrintArea = "$Y$5:$Z$20"
With ActiveSheet.PageSetup
.LeftHeader = "&F"
.RightHeader = "&A &D"
.LeftMargin = Application.InchesToPoints(1.25)
.Zoom = 95

End With
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

So what is the cause of the flash and the delay, and how do I eliminate them?

View 7 Replies View Related

Option To Print - Use Print Macro

Dec 30, 2008

I have a few macros that run in a sheet. After the macros are finnished I would like to present to the user a msgbox that asks if they would like to print. if "Yes" is selected, the print macro runs. If "No" is pressed then nothing happens.

View 3 Replies View Related

Disable Print But Allow Print From Macro

Jun 11, 2007

I have found a macro which disables all print features in excel. I have rwo other codes to print. When I put this macro, It also disables the print from the other macro. How can I use this code so that normal print features will be disabled but if someone takes the print from the macros, Print will be allowed. The code which disables the print is given below:

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If PrtOK Then
Cancel = False
Else
MsgBox "Can't print from here!"
Cancel = True
End If
End Sub

View 9 Replies View Related

Splash Screen While Macro Runs?

Sep 24, 2009

I searched for this and found a few examples on splash screens, but if someone could help I would appreciate it.

Basically I have this massive macro that runs, I recorded some of it, and VBA the rest. It does a bunch of things like bringing in different spreadsheets, formatting vlookups blah blah blah... Anyway for a nice touch I was hoping that I could get a splash screen or something that will run while this macro is running in the background. How hard would this be? The macro is button driven...

View 9 Replies View Related

Screen Flashing When Running VBA Macro

Jan 4, 2010

I have a VBA macro that sort several worksheets during th e processing but the screen flashes it move between worksheets. I would like to be able to just show a messae or have the display stay on the strting worksheet

View 9 Replies View Related

Stop Macro Flashing Screen

May 21, 2008

I have attached macro code, which populates a three page template and clears the contents, so that the process can be repeated. I would like to stream line the macro which populates the template - currently there is alot of screen flickering back and forth between worksheets.

View 2 Replies View Related

Programmable Print Area: Macro To Set The Print Area According To The Amount Of Data In A Particular Range Of Cells

Feb 25, 2009

Using Excel 2003 I am trying to write a macro to set the print area according to the amount of data in a particular range of cells. I find I can include this instruction

View 2 Replies View Related

Splash Screen - How To Display While Macro Runs

Sep 27, 2011

I have a splash screen I want to display while a macro runs. I've created all the necessary code based on information from this site but have a question about where to actually put the code as all the example I've seen are based on workbook open events.

I tried placing my code

UserForm1.Show

with in the macro I waned the splash screen to be displayed during but that doesn't work. Well, it does, but not as I intended. The splash screen pops up for the specified duration as part of the macro stopping the macro, then closes and the rest of the macro finishes running.

Do i need to call the splash screen from a certain point in the macro I wish it to be displayed during? I dont want the macro to stop running while the splash screen is showing.

View 1 Replies View Related

Stop Screen From Jumping While Running Macro

Apr 25, 2007

I've created a macro that runs for about 3 seconds. While the macro runs, the active worksheet display jumps around because of the various cell references being addressed in the macro.

Is there a way to stop the jumping around? How can a simple "Progress" screen be displayed while the macro is running?

View 4 Replies View Related

Using If Within Print Macro?

May 28, 2014

The print area for each of the rows (summary tab) on the attached has been set up, though using button 3 we need to run the same print macro but ignore any rows (summary tab) that happen to be 0.

The attached sheet only gives two rows but there is a potential for up to 40 of them!

Would an IF function within the macro/code work?

View 14 Replies View Related

Macro For Print Out

Feb 6, 2010

I need a macro using a command button in sheet 2 that opens the "Print" window to print out the text in sheet 1 (after chosing printer manually of course). I also want a radio button in sheet 2 so I can select if I want to print out page 1-3 instead of page 1-2 in sheet 1.

View 2 Replies View Related

New Print Macro

Dec 12, 2006

What I would like to do is when I click on the print botton or select Print from the File menu, I would like to have a dialog box pop up with a YES botton and NO button asking the question "Would you like to print out the Medication Summary Page?". YES indicates to print off an additional worksheet and NO indicates just print the active sheet.

In the active sheet I have dropdown list in B6 to select a drug name to calculate IV medication drip rates. I also have other worksheets Named the same as in the list. For example, if you select D5W in the list, I have a worksheet named D5W. If you select YES in the message box, I would like to have the Active Sheet and the Medication Summary page print, ELSE just print the Active Sheet.

View 9 Replies View Related

Fix My Print Macro

Jul 24, 2007

I'm close - but I want the 'user' to be able to enter the number zero to either of my prompts without causing the macro to fail. Currently, if a user does not want to print any color copies (i.e. enters 0 - or B&W for that matter) the macro fails. Any ideas?

Sub Print_Report()
Dim CCopies, bwcopies As Integer

Copies = Application.InputBox("How many color copies?", Type:=1)
Copies = Application.InputBox("How many B&W copies?", Type:=1)
Sheets("YTD").PrintOut Copies:=CCopies, ActivePrinter:= _
"network_address_goes_here:", Collate:=True
Sheets("YTD Graph").PrintOut Copies:=CCopies, ActivePrinter:= _
"network_address_goes_here", Collate:=True
Sheets("YTD").PrintOut Copies:=bwcopies, ActivePrinter:= _
"network_address_goes_here", Collate:=True
Sheets("YTD Graph").PrintOut Copies:=bwcopies, ActivePrinter:= _
"network_address_goes_here", Collate:=True
End Sub

View 9 Replies View Related

Macro Print

Sep 7, 2007

I am wanting to add to my macro a print function.

I have a list of names in Col F

And the Cell A1 powers the data on the sheet.

I want the macro to say if C1 is then make C1=A1, if C1="",stop
and I want that to go on for C2, C3, C4, etc.

View 9 Replies View Related

Print To PDF Macro

Aug 20, 2009

I'm trying to write a macro which prints to PDF and I've been looking through all the posts currently on this forum to get something working. I'm using the following code -

Sub PrintPDF()
Filename = "C:Documents and SettingssambMy Documents" & ActiveSheet.Range("Z1").Value
SendKeys Filename & "{ENTER}", False
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF:", Collate:=True
End Sub

The macro prints to PDF, but then it stops at the Save As stage, where I have to manually enter the name of the file and click Save. I obviously want the macro to automatically name the file with the contents of cell Z1. I then want it to then automatically press enter.

View 9 Replies View Related

VBA Or MACRO PRINT THE JOB

Sep 30, 2009

I have a worksheet with blank tables on 2 template tabs named viz: ON BOARD and NOT ON BOARD, each with 3 sheets to print when viewed on print preview.

What I want is just print ONLY those sheets which have data filled in., i.e if I have data on 1 sheet out of 3 sheets, I want only 1 page to be printed, if there is data on 2 sheets then print only 2 and so on, from both the sheet tabs.

On Page Set up window, I have following specs:

On Page Tab: As follows

Orientation: Landscape

Adjust to: 75 % of normal size

Paper size: 8.5 X 14" Legal

On Sheet Tab:

Print Area A1:O51

Under Print titles:

Rows to repeat at top: $1:$6

These settings are standard for both the sheet tabs.

View 9 Replies View Related

Using Macro To Print Sheet

Jan 13, 2010

I am using a macro with the code below to print the active sheet.

Sub MyPrintOut()
ActiveSheet.PrintOut
End Sub

I assigned the macro to a rectangle. My only problem is that when i print the sheet i can see the rectangle, is there a way around this? I know that i can set the print area but each sheet has a different setup, i tried using .Visible = False for the rectangle but it gave me a few errors.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved