Save a protected Workbook

[Dyson]

Good afternoon all,


I am fairly new to Excel 07 and picking bits up as I go. This site is helping loads.


I have a workbook with over 40 worksheets on it. I have protected the workbook so when advisors open it they have read only accsess ( only I have the password) I have added more tabs to the workbook and now if I try to save it it tells me Workbook Is Protected and Cannot Be Changed. I am not in read only, why is this?


I would be grateful for any help!


Alex

 

[Hui]

Dyson

On the Save Dialog select the Tools Button, General Options

Set passwords as appropriate

 

[deepak.gupta@logica.com]

Hi Hui, I am facing the same problem. But the trick you mentioned is not working. Anything else possible?

cheers,
Deepak