How To Run code Before Print Preview

**mstasko1990** · 10-29-2010, 12:13 PM

Hi All,

Does anyone know how to execute code before print preview?

Is it possible?

Kind Thanks in advance,
Michael

**royUK** · 10-29-2010, 12:15 PM

More details please

**mstasko1990** · 10-29-2010, 12:22 PM

Hi,

The desire is to run a few lines of code (to manipulate cells, change values,etc...)
when a user selects 'print preview' from the file menu.

That is, the code should run before the print preview is displayed to the user

* Something like a _BeforePrintPreview() event would be great, but I don think that exists...

Thanks,
M

***This same inquiry has been posted here: http://www.ozgrid.com/forum/showthread.php?t=147540 ***

**mstasko1990** · 10-29-2010, 02:00 PM

Solved--Not too hard just needed to Use Worksheet_BeforePrint()

See: http://www.ozgrid.com/forum/showthread.php?t=147540

**mikepfly2** · 05-13-2015, 12:34 PM

This doesn't work for Excel 2010 or newer.

The user can click the print preview button or the print command which shows the preview. The

Please Login or Register  to view this content.

event doesn't fire until the user clicks Print from that screen.

Does anyone have a workaround for this? I've scoured the web and coming up blank.

I change the users printer to the XPS Printer before doing formatting as networked and redirected printers cause the macros to take 3-4 times as long. I change to the XPS printer and want to change it back to the users default right before clicking print or print preview.

**Fotis1991** · 05-13-2015, 12:49 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.