Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PrintPreview problem in 2007
I have some rather lengthy code that populates data into a worksheet from
the users inputed data in a form. Once a button is pressed, the data is taken from the form an placed into the worksheet. Then (in Excel 2003) the sheet is viewed in PrintPreview mode for viewing. The user can then click the Print Button on the menu and then click Close from the menu. The rest of the code then clears the data from the worksheet and saves the data into another worksheet for storing. The problem is, one user is using Excel 2007, and the when the code executes the user gets the worksheet in the preview, but the Ribbon does NOT change to PrintPreview Mode, and thus allowing/enabling the Print and Close Buttons fromt eh ribbon. The standard Ribbon remains, with no way to Close the Preview except to Close the file from the Taskbar, which simply closes the Preview view, but also cancels the rest of the code. Funny thing is IF i create a dumby workbook (Book1) and run ONLY the section of code that Previews the Sheet, the Ribbon changes to the Printpreview Mode. Thus enabling the Print and Close buttons. The section of code that works OK by itself is: ' Other code above here generally ========================== With ActiveSheet.PageSetup ..Orientation = xlPortrait ..BlackAndWhite = True ..PrintGridlines = False ..Draft = False ..PrintQuality = -1 ActiveWindow.SelectedSheets.PrintPreview End With ========================== ' Other code below here too Is there a way to make 2007 change to the PrintPreview mode ? Corey.... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PrintPreview | Excel Discussion (Misc queries) | |||
PrintPreview in 2007 (for what it's worth...) | Excel Programming | |||
PrintPreview problem | Excel Programming | |||
Print dialog : problem when user click printpreview | Excel Programming | |||
Printpreview problem - disable various buttons | Excel Programming |