Excel security/password Question

[Siyanna]

Hi,

For some reason nothing got posted on the other thread title (Excel security/password Question).

Basically, i have some spreadsheets where before i open the workbook i enter a password to open (excel 2007). This was done through the Tools- options way.

Now i want to be able to change my passwords however for me to do this i need to save as and create the workbook again and that's when i have the option to change from the tools - option etc...

This way i have 2 workbooks with 2 passwords to open which is what i dont want.

Is there a quicker way from my spreadsheet i can have the option to change password for when opening or modify workbook?

Thank You

 

[Firefly2012]

I don't see the problem - just go and delete the other workbook?

 

[Siyanna]

I don't see the problem - just go and delete the other workbook?

Oh yeah

I suppose i can do that but is that the only way to get around this or is there actually an option to change the password to open workbook?

 

[Firefly2012]

As far as I know that's a feature of SaveAs, but you could always choose to save the file in the same location with the same name but with the modified password?

 

[Michael M]

I don't understand why you need to save and create the workbook again !!
Why not open the workbook with the existing password and then go back to Tools / options and change the information...or am I missing something ....

 

[Siyanna]

I don't understand why you need to save and create the workbook again !!
Why not open the workbook with the existing password and then go back to Tools / options and change the information...or am I missing something ....

Hi Michael, thats my point. I want to change the password however when i open the workbook with the existing password. I dont have the option to go to tools to change the password in excel 2007 unless i save as. I just wanted to see if there was a quicker to change the password rather than save as. My aim is to change the password, not create another workbook.

Hope this makes sense.

Thank You

 

[Firefly2012]

You can do this via SaveAs - you don't need to rename the workbook in the process

 

[Siyanna]

You can do this via SaveAs - you don't need to rename the workbook in the process

That's cool.

Thank you for your help

 

[RoryA]

Click the Office button, 'Prepare', then 'Encrypt document' and change the password to whatever you like.

 

[Siyanna]

Click the Office button, 'Prepare', then 'Encrypt document' and change the password to whatever you like.

Thank you