How To Trigger "Unprotect Sheet" Message Box

gr8_big_geek

New Member
Joined
Feb 18, 2009
Messages
41
Greetings Everyone,
I'm currently trying to set up a macro, or something similar, that will trigger the "unprotect sheet" msgbox. I was trying to have it button activated from a form. Does anyone know the command to trigger that to pop up?

Thanks in advance! :)
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

dk

MrExcel MVP
Joined
Feb 15, 2002
Messages
2,942
Hi

You can use this short piece of code to mimick the user choosing Tools, Protection, Unprotect Sheet.

Code:
Application.CommandBars("Protection").FindControl(ID:=893).Execute

If the active sheet is unprotected at the time then this macro would display the "Protect Worksheet" dialog. The code can be modified to prevent this if desired.

Also, this code has only been tested on Excel 2003 - can't say for certain if it will work on other versions. Let us know what version that you're working with if this particular code doesn't work.

DK
 

Watch MrExcel Video

Forum statistics

Threads
1,122,519
Messages
5,596,635
Members
414,083
Latest member
Mrsash

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top