| Homepage |
| IT Services |
| Consulting |
| Training |
| Get help now |
| Application Development |
| Support and Downloads |
| About us |
| Contact information |
| 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
