MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Disable Cell Selection

Posted by Roy on September 16, 2001 8:53 AM

I have a sheet with buttons on and gridlines hidden. Is there a way to stop user clicking all cells, therefore they don't become selected.


Posted by Juan Pablo on September 17, 2001 8:48 AM

Yes, in the VB editor (Alt + F11 from Excel), select the sheet you're working on (Sheet1 for example) and in the properties window, in "Enable Selection" choose from "xlUnlocked Cells" or "xlNoSelection".

You'll have to protect the sheet in order to make this work.

Hope that works

Juan Pablo