General

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.
 
P

Paul B

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 **
 
Top