ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel spreadsheet -- column widths and row heights change accordingto the printer selected (https://www.excelbanter.com/excel-discussion-misc-queries/453942-excel-spreadsheet-column-widths-row-heights-change-accordingto-printer-selected.html)

[email protected]

Excel spreadsheet -- column widths and row heights change accordingto the printer selected
 
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.)



GS[_6_]

Excel spreadsheet -- column widths and row heights change according to the printer selected
 
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

[email protected]

Excel spreadsheet -- column widths and row heights changeaccording to the printer selected
 
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.

GS[_6_]

Excel spreadsheet -- column widths and row heights change according to the printer selected
 
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


All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com