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
Bookmarks