How to password protect a read only Excel file

[jdmc45]

How do I password protect a read only Excel file? Is it possible? The only way I've been able to do it is to make the excel file read only then create a ZIP file then password protect that, there must be a better way to do it?

 

[grizz]

In 2000 - 2003 you can save as / tools / general options / then check password to open and check read only

 

[jdmc45]

In 2000 - 2003 you can save as / tools / general options / then check password to open and check read only

how to do this for 2007?

 

[grizz]

I was hoping you were not going to ask me that as I don't have 2007 on this computer but I think it's simular. click the icon top left and save as / pick the format and go options

 

[jdmc45]

I was hoping you were not going to ask me that as I don't have 2007 on this computer but I think it's simular. click the icon top left and save as / pick the format and go options

haha sorry, had a look not sure how to do it in 2007, thanks anyway

 

[taurean]

When you choose "Save As" option then on the bottom left of the dialog box you will see a small button "Tools" with drop down arrow.

Click on it and choose "General Options" and there you go

I do not know why it is shifted to such non-descript location.

 

[jdmc45]

When you choose "Save As" option then on the bottom left of the dialog box you will see a small button "Tools" with drop down arrow.

Click on it and choose "General Options" and there you go

I do not know why it is shifted to such non-descript location.

Cool, thanks heaps! yeh its very hidden. thanks again