On Thursday, December 21, 2017 at 3:43:23 PM UTC+11, GS wrote:
In a large organisation an excel spreadsheet is used by a variety of staff
to enter end of day sales figures.

The spreadsheet will be viewed on different computers, which may be
connected to any number of different printers.

In some circumstances the column widths and row heights will change
according to the printer selected.

Some staff when seeing these changes on their screen may panic.

Is there a way to ensure that the image on the screen is consistently
readable in many diverse situations?

(VBA solutions welcome.)

Are all screens the same resolution? (The higher the res the smaller things
*appear*)

--
Garry

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

Yes, all screens have the same resolution.

Is PageSetup set to "Fit to..."?

--
Garry

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