excel error

  • Thread starter Thread starter kevin carter
  • Start date Start date
K

kevin carter

Hi

We have wrote a workbook that contains a lot of formulas and Vb code,
we have password protected the Vb code.
All the worksheets are also password protected
the cells that contain forulas are locked to stop them being damaged.

This works fine, problem is when the workbook is opened in read only mode
one worksheet becomes unlocked.
all the reast of the worksheets remain locked

Can anyone tell us how to remedy this problem?



thanks in advance
Kevin
 
one worksheet becomes unlocked.

Never heard of this problem. And I wasn't able to reproduce it either.
Starting with a new workbook can you reproduce the problem? What are the
exact steps? What Excel version?
 
Back
Top