I made a bit of a bugger up in a file I created. In essence what it was supposed to do was just collect some user information using a form. Enter it onto selected cells in specified sheets and then protect those cells from been altered.

That works perfectly except for the fact that when I protected the sheets I forgot to allow users to be able to change the rest of the cells regarding things like format etc.

Now I've already sent this out and I am not keen on telling every single person how to correct it or what the password is.

Can any possibly suggest the code I would use for a button that would simply do the following:

Activate a specified workbook
Unprotect each sheet in that workbook
Protect each sheet again but allow all cells to be altered in any way except for cells specified as locked previously