Thank you Logit. My knowledge of vba is a big appreciation of what it does, copying the code supplied by generous experts in the internet that exactly fit my requirements. I ask help in this forum when I could not find the correct code that I need.
The BeforeClose code is for saving. I do not honestly know how to edit the code to protect the sheet after the user has executed the insert rows or hide commands.