locked worksheet

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

I have locked my worksheet and saved it . When I go to open it, I cannot get
a whole window displayed. I have tried the icons for whole, half, etc. in
the lower right hand corner.
 
Thanks for replying. Just tried that and it made no difference. Anhy other
suggestions? I know it can work because somehow my first locked spreadsheet
does not have this problem, but I cannot figure out what is different,
besides the size of the file.
 
Spreadsheet is 120 columns x 5000 rows. Headings and first two columns are
set to always show. Client needs access only to the body of the spreadsheet.

In full window I protect Sheet then Structure and Windows. Save and close.
When I open the file to verify that it is locked, the spreadsheet only takes
up the right half of the screen. The left side of the screen is empty.
Because it is locked, I cannot expand the window. I cannot drag the window
nor move it view it or reduce or enlarge it. I need to protect the window so
that the client must always have the headings and first two colums. If I only
protect the structure and not the window, then I do not have this issue.
 
Thank you for replying back. I already went with solution no. 1. I had to
upload the file for users. This is what I would call a work-around. What is
VBA code and how can I learn it?
 
Back
Top