Macro to Lock and Unlock a Worksheet ONLY

You would use something like what is found on this page. It could look something like this:

 .Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, AllowFormattingCells, AllowFormattingColumns, AllowFormattingRows, AllowInsertingColumns, AllowInsertingRows, AllowInsertingHyperlinks, AllowDeletingColumns, AllowDeletingRows, AllowSorting, AllowFiltering, AllowUsingPivotTables)

Select allOpen in new window

Obviously, you don't necessarily need all of those options. You can read about them on the link above.

Mike in IT,  Thanks for the thought, however, unfortunately, I don't know how to write the several lines of code that use the commands you referred to.

B.

Worksheets("MySheet").Protect UserInterfaceOnly:=True, DrawingObjects:=True, Contents:=True...

or

ActiveSheet.Protect UserInterfaceOnly:=True, DrawingObjects:=True, Contents:=True...

and then

ActiveSheet.Unprotect

or

Worksheets("MySheet").UnProtect

Martin,

Greetings.  Thanks for jumping in.  With the code you provided, I sketched up a mock WS.  I can't get it to work but thought this might show exactly what I'm looking for.

Again, thanks to both of you,

B.
Lock-Unlock-Macro.xlsm

I have updated the code that you had on your sheet and assigned the pictures to run one of the subs. Now when you click on the locked picture it locks the sheet and when you click on the unlock icon it unlocks the sheet.
Lock-Unlock-Macro.xlsm

Mike and Martin,

GREAT........ALMOST THERE!!!!   Re-read the original "ask".  

Overlay the two icons.  When you click on one of the icons, the other appears.... and vice versa.  Only the next option (Lock or Unlock) is shown. This gives the impression of a single button that locks and unlocks the worksheet.  

Thank you,

B.

I'll let Mike answer, but you probably don't need two icons. Just use one and programmatically change what it says and does after it's clicked.

How hard is it to use the icons?

B.

Great work guys in helping me through this apparently simple macro.  I'm going to author one more on this.  Hope one of you will pick it up.

All the best,

B.