Worksheet protected

[R Ormerod]

If a worksheet is protected by a password is there any way of being able to
edit the data if the password is irretrievable?

 

[Mike H]

Hi,

probably not but password can be removed. Have a look here


http://www.mcgimpsey.com/excel/removepwords.html

Mike

 

[Gord Dibben]

If you have allowed users to select locked cells then they can copy the data to
another sheet but they won't be able to edit the original sheet data.

Are you asking how to retrieve a forgotten password?

See John McGimsey's site.

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben MS Excel MVP