I have made several posts over the last year concerning an automated price sheet that I have created. The help here is really AWESOME and I really appreciate all of the help so far...

When I first started this project the macro enabled workbook was used exclusively by company employees who all utilized identical notebook computers with the same version of Windows and Excel (XP and 2003). Over the last year, however, the workbook is starting to be utilized by independant representatives(in the US) and Internationally. This has created quite a few hurdles with region/language specific formatting / sheet orientation (Hebrew). Not to mention screen resolution etc. In addtion, now the tool is being used on different versions of WIndows and Excel (from Win 98 to Vista --- from Excel 97 to 07)

This has been a huge challenge - I have the upmost respect for software engineers who have to take into account all of these variables and still have applications run as intended.

Here is the latest...... One of the reps has rather poor eyesite and he has his system setting to 120 DPI to make everything appear a little larger. THe workbook is designed really for 1024X768 (not too many 800X600 screens anymore)

On the main sheet I have set the scroll area to keep users from scrolling to the right to hidden areas of the sheet. The problem is that with the 120DPI setting it cuts off the right-most column that they are intended to see which also contains command buttons for macro execution.

This setting is independant of screen resolution -- the computer still pulls 1024X768.... How can I detect this setting and

A: adjust the zoom level to compensate (I know how to zoom, just not detect the DPI Settings)

or

B: adjust the system settings (I would really rather not do this)

or

c: Any other suggestions?



Also if there is an article / tutorial on how to "globalize" a work book I would be very grateful


As always, I appreciate any insite or help



Lee