Homepage |
IT Services |
Consulting |
Training |
Get help now |
Application Development |
Support and Downloads |
Contact Us |
Send us a comment or question |
Applications |
MS Access |
MS Excel |
Coding and Macros |
Excel VBA |
Restricting movement only to unlocked cells (Excel)
Sometimes you might want to prevent the movement to locked cells. Choose command Review-Protect Sheet
Now in the following dialog uncheck the option Select locked cells and click OK.
You can do this with VBA also
Worksheets(1).EnableSelection = xlUnlockedCells
Last modified on August 19 2015