General

  • Thread starter Thread starter Carl Johnson
  • Start date Start date
C

Carl Johnson

I created a workbook with several worksheets that are protected and when it
is opened it is to go to sheet1 and select cell A10. My problem is that when
I open it not only is sheet1/A10 selected but a cell in sheet2 which causes
half of each sheet to be visible. Now if I unprotect sheet2 the problem goes
away but cells in the two sheets are linked and both need to be protected.
Any help with this would be greatly appreciated. Thank you.
 
Carl, care to post the code you are using? maybe somebody can see why it is
doing that

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
Back
Top