Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-27-2021, 06:59 PM
Marcia's Avatar
Marcia Marcia is offline Message to Protect Sheet after a command Windows 10 Message to Protect Sheet after a command Office 2019
Expert
Message to Protect Sheet after a command
 
Join Date: May 2018
Location: Philippines
Posts: 551
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, 10 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Command button. To multi command Taylormations Word VBA 11 09-14-2020 02:39 AM
How do I un-protect docs I didn't protect? doctorduncan Word 4 05-30-2019 11:09 AM
Message to Protect Sheet after a command Outlook 2013 > Command to view the header without opening a suspicious message? Macintosh Outlook 2 02-04-2019 05:38 PM
Show table list by using chek box command and save document on sharepoint by using command button Zhibek Word VBA 3 08-16-2018 06:19 PM
Repair command results in error message srdiamond Office 0 03-01-2011 12:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft