VBA unlock 3 cells for input then lock afterwards

[RedBorg]

I have this code that works off of my active cell and then the userform outputs the 3 choices in the 3 cells directly right of the active cell. I'd like to have them locked since the userform enters the data in them, and then when the userform closes, the 3 cells are locked again.

Please Login or Register  to view this content.

[teylyn]

Hello,

consider protecting the sheet with the "Userinterfaceonly" property when the workbook is opened. Then you don't have to use VBA to unprotect, change cells, re-protect. Put this in the ThisWorkbook module, save, close and re-open the file and your VBA will run on protected sheets.

Please Login or Register  to view this content.

cheers, teylyn

[RedBorg]

Brilliant Teylyn. Worked Great. I’ve searched for hours and never once saw this code. Thanks again.
I do have one last problem to finish this 3 month project of mine if you're up for the challenge? I can’t seem to get anyone to solve it yet.


http://www.excelforum.com/showthread...t=#post4362608