Create shorcut key when protecting/unprotecting worksheet

[kenjiventurina]

Hi everyone,

How can i create a shortcut key in protecting/unprotecting my worksheets? For example, ctrl + P for protecting then ctrl + U for unprotecting..

Much better if there is a code.

Appreciate anyone's reply. Thanks!

[dilipandey]

Hi Kenjiventurina,

You can record a quick macro for protecting and unprotecting with a shortcut key of your choice... thanks.

one example:-

Sub Macro2()

' Keyboard Shortcut: Ctrl+p

    Range("A1").Select
    ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

Regards,
DILIPandey

<click on below 'star' if this helps>

[kenjiventurina]

wth! you saved my ***.. thanks DILI!!

[dilipandey]

You are welcome kenjiventurina..

Cheers

Request you to mark this thread as [SOLVED]..

Regards,
DILIPandey

<click on below 'star' if this helps>