MrExcel Publishing
Your One Stop for Excel Tips & Solutions

is there way to lock view percent in excel97..


Posted by Wak Karto on December 17, 2000 1:08 PM

what i like to do is everytime
when people open the file it is
set to..let say 50% view.and they
cannot adjust it..thanks


Posted by Wak Karto on December 17, 2000 1:17 PM

1 more thing. I almost forgot.. -


can we set the view for particular sheet..
let say.in sheet1.the view is 50%, in sheet2
the view is 130%, in sheet3 the view is 200%
etc.can this be done.thanks again

Posted by Celia on December 17, 2000 5:33 PM

Re: 1 more thing. I almost forgot.. -


Set the % views you want and assuming that you have the zoom button on the Standard toolbar, put the following two procedures in the ThisWorkbook module :-

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
Application.CommandBars("Standard").Controls(12).Enabled = False
End Sub

Private Sub Workbook_WindowDeactivate(ByVal Wn As Window)
Application.CommandBars("Standard").Controls(12).Enabled = True
End Sub

Celia

Posted by Wak Karto on December 18, 2000 2:12 AM

Re: 1 more thing. I almost forgot.. -

thanks celia