How to Edit a Protected Worksheet with VBA, UserInterfaceOnly Lesson

In this lesson, we learn a couple of different ways how you can protect a worksheet and still be able to edit facets of the worksheet, for example:

Inserting Rows and columns
Deleting Rows and columns
Even how to edit a cell when it is locked and protected! Check it out!

Fantastic Developer Tools:

[casper]

You are my saviour...ive been looking for a solution for a month.

[krn]

Thanks Daniel. I just learned about this protection method a while back and now use it all the time.

[valigeorge]

Ok.. what do you do when the other user has the macro disabled?

[davidmoffatt]

Great: Can you show me how to you use macro Buttons on a protected sheet.?

[casper]

Sir, ive created a userform button and have macro on it. But i used the user interface only code. Its working! But when i closed and re opened the file, its not working. Please help.

[subashdhungana]

sir please make a video on VBA excell sheet protection in userinterfaceonly each time when open a workbook.. i have protected my sheet in userinterface only but when i close and re open my workbook it says "error 1004". i have tried protect.activesheet and unprotect.activesheet but it is also not why i need to share my workbook but in protected form but they can input data in VBA..