Not sure this is the right ng, but it is for Excel, and there might be some
programming :)

For a while now, one of our clients has been happily using Excel with
various templates that we've provided, and upgraded from Excel 97 to Excel
2000.

However, recently they've reported the following;

Excel as f/g app, from launch. User clicks print on toolbar and w/s prints
as expected with no UI or other intervention to default printer. User
switches to different application (e.g. Word). User switches back to Excel,
makes modification to values in sheet, and clicks print on toolbar. This time
there is the 'Print...' dialog, which is somewhat unexpected.

They haven't changed anything (we checked) and nor have we, and this happens
whether they're using one of our templates or just a 'standard' workbook.

Two questions;

(a) Anyone else seen this behaviour?
(b) Presumably, if we modified the toolbar setting, we could put some code
behind a button to do a print to default print with no UI.


--
Steve S

I can't duplicate this, sorry.

--
Jim
"SteveS" wrote in message
...
| Not sure this is the right ng, but it is for Excel, and there might be
some
| programming :)
|
| For a while now, one of our clients has been happily using Excel with
| various templates that we've provided, and upgraded from Excel 97 to Excel
| 2000.
|
| However, recently they've reported the following;
|
| Excel as f/g app, from launch. User clicks print on toolbar and w/s prints
| as expected with no UI or other intervention to default printer. User
| switches to different application (e.g. Word). User switches back to
Excel,
| makes modification to values in sheet, and clicks print on toolbar. This
time
| there is the 'Print...' dialog, which is somewhat unexpected.
|
| They haven't changed anything (we checked) and nor have we, and this
happens
| whether they're using one of our templates or just a 'standard' workbook.
|
| Two questions;
|
| (a) Anyone else seen this behaviour?
| (b) Presumably, if we modified the toolbar setting, we could put some code
| behind a button to do a print to default print with no UI.
|
|
| --
| Steve S

Hi Steve,

This newsgroup is mainly for how to program in Excel. (e.g.VBA).

For your scenario, it seems to be a break fix issue about how to use Excel.

Also from your description it seems that the problem will occur even if you
are using a standard workbook without using a customzied template.
So far I think you may try to disable all the addin and template to if the
problem persists.
If yes, I think you may try to reinstall the Excel to see if that fixed the
problem.


Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.