Protecting an entire Excel Workbook - multiple sheets

[slipd]

Hi guys,

As above, there's a leave sheet at work which needs to be viewible by staff but not editable - the workbook needs to be password protected so that only the managers can edit it.

I only seem to be able to protect individual sheets - is there a way of protecting the whole thing from being edited unless you have the password? I'm sure I've opened spreadsheets before that prompt me for a password but also give me the option to open as 'read only.'

Any ideas? We're using 2003.

 

[gillywibble]

Click File - Save As.

In the Save As windows - click Tools - General Options.

In the Save Options window, enter a password under Password to Modify.

 

[Bry]

^ easiest way or you could use ntfs permissions to set it to be read only to normal staff and modifiable to managers

 

[slipd]

Sorted now guys, thanks