I have a splash page containing a number of control buttons which launch user forms in excel 2000. So as not to complicate the page I wish to stop the cursor from selcting a cell on the sheet if clicked, but retain the control button functionality. Does anyone know code to action this??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
locking out cell focus in Excel
- Thread starter davefish
- Start date
Set the sheet's ScrollArea Property to an absolute reference of a cell behind one of your control buttons (i.e. $A$1).
This way, the only cell on the sheet that can be selected is, in the example, A1. And since it is behind a control button, it can't be selected.
I hope this helps!
Peace!![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
Mike
Never say Never!!!
Nothing is impossible!!!
This way, the only cell on the sheet that can be selected is, in the example, A1. And since it is behind a control button, it can't be selected.
I hope this helps!
Peace!
Mike
Never say Never!!!
Nothing is impossible!!!
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Solved