Locking files/windows

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Galen Castlebury (vzex601_at_verizn.net)
Date: 03/08/04 

Date: Mon, 08 Mar 2004 15:52:54 -0500

Hello,

     I'm trying to make a series of Excel spreadsheets hyperlinked
together. These files would be readable by others but I maintain
editorial control. I've learned how to lock the pages but a problem
occurs when I try locking the structure & window.
      For Ex.; I have just the portion of the spread*** I want others
to have access to displayed on my monitor such that it fills the screen;
I lock structures & windows; set password & save. When I close the file
then reopen it, only about 20% of my desired portion is visible. Fonts,
zoom size, etc haven't changed. If I unlock the workbook, the remaining
80% of the desired display reappears.
     All potential users have Excel 2002 & flat screen monitors. Any
thoughts on how to rectify this would be appreciated.

Thanks, Galen

Quantcast