In english   |   suomeksi

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.

linest

You can do this with VBA also

Worksheets(1).EnableSelection = xlUnlockedCells
			

Last modified on August 19 2015

Back to Support and Downloads

News
 
Retrieve Your favorite (NYSE) Stocks with our Excel tool
Microsoft Excel, Access VBA Developing Services
IT Training
WEB Design and applications
Published advice on related questions
Populate a Multi-column Combobox with a 2D array on Access
Multiple Search Text at the same time using Forms in Microsoft Access Database
VBA comboBox multicolumn remove blank row and specific value listed
Articles
Time parameters for Google search
 

Search from our site:



Registered Microsoft Partner

Phone: +358 50 566 6858
Helsinki, Finland
mika.oukka@netti.fi