View Single Post
 
Old 09-27-2021, 06:59 PM
Marcia's Avatar
Marcia Marcia is offline Windows 10 Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default Message to Protect Sheet after a command

Hi. The attached sheet is protected but the users may insert rows as needed within the form, and hide columns C D and E. But in order to do these tasks, the users must unprotect the sheet first. I would like help in a code that when the user unprotects the sheet, a message pops out like "protect the sheet after the insert rows or hide columns".
My search did not yield any satisfactory result.
Thank you.
Attached Files
File Type: xlsx ProtectMessage.xlsx (45.6 KB, 8 views)
Reply With Quote