Another Excel Question

[nikaiyo2]

I have googled but get nothing.

I have a spreadsheet with protected cells, mainly to stop users from messing the formulas up, nothing more. Is it possible to allow "save as" without copying the password protection over these cells?

[Bungleaio]

If it's protected unless you unprotect it then you can't remove that protection by just using a save as.

[maffski]

If you're comfortable with VBA you could probably do something that ran on the save event and removed the protection.

Workbook.BeforeSave
Workbook.Unprotect

Or alternatively, that ran on open and removed the protection if it wasn't the correct filename.

Workbook.Open
Workbook.FullName

In both cases all users would need to configure the Excel security settings to run marcos in the file.