Another Excel Question
Discussion
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.
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.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff