Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro printview
Glenn,
You can show a WS in print preview, but then that's essentially the end of your code until the user returns to normal view. ActiveSheet.PrintPreview NickHK "Glenn" wrote in message ... Thanks for the help... I thought I posted this the other day butI can not find it. I builf the following macro to print a worksheet in my workbook. How would I modify this to let me view the worksheet before it prints? Sub TIRE() ' ' TIRE Macro ' Macro recorded 12/2/2006 by Ridgeland Finance ' ' Keyboard Shortcut: Ctrl+Shift+T ' With ActiveWorkbook.Worksheets("TIRE") szSheet = .Visible .Visible = xlSheetVisible .PrintOut .Visible = szSheet End With ' End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro printview | Excel Programming | |||
how to count/sum by function/macro to get the number of record to do copy/paste in macro | Excel Programming | |||
macro to delete entire rows when column A is blank ...a quick macro | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |