(Msg. 1) Posted: Sun May 18, 2008 3:05 am
Post subject: Excel 2007 PrintPreview No CLOSE option Archived from groups: microsoft>public>excel>printing (more info?)
I have a macro that import data into a sheet, then shows the sheet in
printpreview.
Generally in Office 2003, after clicking Close in print preview the sheet is
sent to the printer and i get the programmed msgbox notifying of this.
However in 2007, there is NO PrintPreview CLOSE button, thus the 'X' must be
used, and this subsequently does not send the shee to the printer, but i
still get the programmed msgbox saying the sheet was psent to the printer.
How can i get the CLOSE button to be visible in the PrintPreview in 2007?
This would hopefully fix the print error.
(Msg. 2) Posted: Sun May 18, 2008 3:05 am
Post subject: Re: Excel 2007 PrintPreview No CLOSE option [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
In 2003, when I hit Close the print preview screen closes and Excel does not
print. Are you doing this with code? If so what is your code.
Cheers,
Shane Devenshire
"ctm" <coza DeleteThis @exemail.com.au> wrote in message
news:en0jKaHuIHA.5096@TK2MSFTNGP02.phx.gbl...
> I have a macro that import data into a sheet, then shows the sheet in
> printpreview.
>
> Generally in Office 2003, after clicking Close in print preview the sheet
> is sent to the printer and i get the programmed msgbox notifying of this.
>
> However in 2007, there is NO PrintPreview CLOSE button, thus the 'X' must
> be used, and this subsequently does not send the shee to the printer, but
> i still get the programmed msgbox saying the sheet was psent to the
> printer.
>
> How can i get the CLOSE button to be visible in the PrintPreview in 2007?
> This would hopefully fix the print error.
>
>
> --
>
> Regards
> Corey
>
(Msg. 3) Posted: Mon May 19, 2008 3:04 am
Post subject: Re: Excel 2007 PrintPreview No CLOSE option [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
The Print Preview is selected via VBA code:
ActiveWindow.SelectedSheets.PrintPreview
But in 2007 the Print and PrintPreview Close buttons are not visible?
"Shane Devenshire" <shanedevenshire.DeleteThis@sbcglobal.net> wrote in message
news:%23IEN4RKuIHA.4260@TK2MSFTNGP05.phx.gbl...
> Hi,
>
> In 2003, when I hit Close the print preview screen closes and Excel does
> not print. Are you doing this with code? If so what is your code.
>
> Cheers,
> Shane Devenshire
>
> "ctm" <coza.DeleteThis@exemail.com.au> wrote in message
> news:en0jKaHuIHA.5096@TK2MSFTNGP02.phx.gbl...
>> I have a macro that import data into a sheet, then shows the sheet in
>> printpreview.
>>
>> Generally in Office 2003, after clicking Close in print preview the sheet
>> is sent to the printer and i get the programmed msgbox notifying of this.
>>
>> However in 2007, there is NO PrintPreview CLOSE button, thus the 'X' must
>> be used, and this subsequently does not send the shee to the printer, but
>> i still get the programmed msgbox saying the sheet was psent to the
>> printer.
>>
>> How can i get the CLOSE button to be visible in the PrintPreview in 2007?
>> This would hopefully fix the print error.
>>
>>
>> --
>>
>> Regards
>> Corey
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office