All - I have a couple of goober users that want to try to meddle with a spreadsheet and code that I have created. I would like to create code to run upon open of the spreadsheet that will hide or disable the ribbon and menu bars and only allow them to enter data into the spreadsheet. I do not want them to copy or paste or anything else. Then I would like separate code to unhide or enable the ribbon and menus if I need to use it.
What I had planned was to have two pieces of code, one to hide and the other two enable. I would have the hide code run upon startup and then the enable code I would assign a CTRL letter to activate when I want to use the menus. I could then assign the code to hide the menus again to another CTRL letter so I could hide the ribbon/menus again.
Inside the code I may also want to disable the CTRL-C to prevent copying in the entire spreadsheet to also help prevent them from meddling with formulas.
Any suggestions or code that may help ? I am not sure of the code that would accomplish this.