Maybe you could just stop fighting that user and each time your workbook opens,
it can reset the zoom factor to 100% for each worksheet.

Option Explicit
Sub auto_open()
Dim wks As Worksheet
For Each wks In ThisWorkbook.Worksheets
wks.Activate
ActiveWindow.Zoom = 100
Next wks

'and to always open to the same cell
Application.Goto Worksheets("sheet1").Range("a1"), scroll:=True
End Sub

Change the sheet name (I used sheet1) to what you want--and change the zoom
level, too.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

scott wrote:

In my spreedsheet I have multiple users. One problem that I am now
encountering is one user insist on changing the view of the ss from normal
and shrinking it to a different %. I do not know why he does it (to be
diffucult), there is no way that he will stop. With him changing the views
the other members that use the ss do not know how to chnage it back. In other
words they like it like it is and leave it alone. I have protected the cells
and formulas is there a way to remove the View option from the menu bar so
this person leaves it alone. I do not want to remove the entire menu bar.
Thanks I know what eveyone is thinking and believe me I have thought it but
there really is no other way around this so I need to remove or lock
it.Thanks Scott

--

Dave Peterson