Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro printview
Glenn
In your macro, I don't understand what the lines with the word szSheet are doing. If you want to view the sheet before printing, you will have to stop the code or bring up a message box that will cover a part of the sheet you want to see. If you want to view the sheet with the possibility of changing something in the sheet, then stopping the code is the only way. Of course, if the TIRE sheet is not the active sheet, you will have to add code to select that sheet so that you can view it. That means that the PrintOut line has to go and you will have to initiate the printing process some way. Of course, that means that this macro will do nothing more than hide/unhide some sheet(s). HTH Otto "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 Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
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 |