I have a monthly report file which I lock down and leave only a range of cells open. Staff make their updates and then click a "submit" button when they're done to indicate everything is complete. At this point, I want to put the file in a read-only status.
I used the built-in save as function to record the steps but want to know if there are any alternatives. I don't like having the read only box at start up, then another prompt when someone tries to save the file.
Is it possible to have my macro write another piece of code when the original "submit" button is clicked? I came across the following thread I would like to try but only want to use this piece of code after the file has originally been submitted. Can I have my macro write this code to the file once it has been submitted?
http://www.mrexcel.com/forum/showthread.php?t=372690&highlight=read+only
I'm also wondering if there are any other alternatives that I could use.
Thanks - Kevin
I used the built-in save as function to record the steps but want to know if there are any alternatives. I don't like having the read only box at start up, then another prompt when someone tries to save the file.
Is it possible to have my macro write another piece of code when the original "submit" button is clicked? I came across the following thread I would like to try but only want to use this piece of code after the file has originally been submitted. Can I have my macro write this code to the file once it has been submitted?
http://www.mrexcel.com/forum/showthread.php?t=372690&highlight=read+only
I'm also wondering if there are any other alternatives that I could use.
Thanks - Kevin