Lock a cell based on value in another cell. Excel for MAC 2011 NOT PC

Hello,
I found this code in another forum. I have no experience in VBA but I can follow the logic and it should do what I want. My difficulty is that I cannot enter the code successfully in my Excel for MAC. I see the Editor, Macros and Record buttons and can type in the code, and edit it, but it does not seem to "take". I need the code to run continuously any time the spreadsheet is open, ie, not only on demand.

Please Login or Register  to view this content.

Best for my application would be if the "B1" range were to also change fill color when locked versus unlocked. So I can see at a glance if the cells are locked or not.

Step by step instructions for a dummy needed, for a MAC installation, (not for a PC).

Help would be greatly appreciated!!

Peter

Hi Peter.

We are waiting for a long time member(like you)-even with few posts- to know the forum rules. Pls take a look to these, because:

Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future

Peter,

In the VB Editor, you need to double-click the worksheet (not workbook) object for which you want that code to run and then paste the code in there. Then ensure the file is saved as a macro enabled file.