"GS" wrote:

I hook the Print icon to display the Prit dialog in all cases,
specifically so I can choose/set what gets prited.


How do you "hook" the Print icon?

You assign your own 'OnAction' to it, OR replace the Standard toolbar
icon with the 'Print...' icon via customize. In v2007+ you need to
assign your own 'OnCtion' via xml in a later file format of
Personal.xls!

I was also looking for an automated solution that just
prints pages that actually contain data, just to make it
easier for users.

This is possible when you assign your own 'OnAction' so Excel uses your
macro to print conditional according to your criteria.

Otherwise, if this is project-based then add the necessary code to make
changes at project startup and restore them at project shutdown!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion