Hi Peter,

The simplest method that I've found, which works well, is to use the Zoom
function.

For example:

In your own settings, on your main worksheet, ensure that that the visible
columns fit the screen exactly.

Call the following code (or include it in) the Workbook Open Event.

Sub ZoomAdjust
Dim Zm,Sh
Sheets("Your Main Sheet").Activate
'Insert your visible column range below
Range("C1:T1").Select
ActiveWindow.Zoom = True
Zm = ActiveWindow.Zoom
For Each Sh In Worksheets
Sh.Activate
Sh.Unprotect
ActiveWindow.Zoom = Zm
ActiveSheet.Protect contents:=True, DrawingObjects:=True,
userinterfaceonly:=True
Next
Sheets("Your Main Sheet").Activate
End Sub

Yoy may. or may not, need the UnProtect & Protect features

At one time (Excel 97) zooming sometimes caused problems, but over time this
appears to have resolved itself.

Regards,
Don

"Peter Bernadyne " wrote in
message ...
Hello,

I have designed several dedicated excel workbooks for use with specific
Add-Ins I have assembled. On distributing these to users, I have come
across the somewhat vexing problem that everyone's excel layout is
different, which causes variations in what important features of a
worksheet are visible and which are obscured, etc.

Obviously, I have designed the workbooks using my own settings and in a
way that makes everything legible without requiring the user to scroll
(either horizontally or vertically) - making my workbooks appear almost
like self-contained applications. Ideally I would want these to appear
on everyone's machine just the way they do on mine.

Perhaps some of this depends on monitor size and display settings, but
does anyone know if there is some simple code I could include in my
distributed workbooks that would standardize the way users view them
(like standardizing the view size to 100%, removing extra toolbars like
drawing/reviewing, etc.) and then have all these put back into place
exactly as they were once the user closes out the workbooks?

Thanks in advance to any help anyone can give.

-Peter


---
Message posted from http://www.ExcelForum.com/