Prevent clicking on a cell

Posted to microsoft.public.excel.programming

ordnance1[_2_] ordnance1[_2_] is offline

external usenet poster

Posts: 92

Prevent clicking on a cell

I want to run the code below to prevent a range of cells from being selected
if the Range("Q7") = 1. I have all cells on the worksheet locked but the
user must be able to click on the locked cells to trigger a userform so I
have to check Select Locked Cells. So is there any way make the
Range("B5:C5") unselectable?

If Range("Q7") = 1 Then
Range("B5:C5").Locked = True
End If

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel - prevent someone from clicking into certain cells	Silverstreak	Excel Discussion (Misc queries)	1	January 21st 10 02:01 PM
[Beginner's] Adding a letter to a cell by clicking the cell	pnumminen	Excel Programming	4	March 9th 09 07:03 AM
clicking all the way to another cell	jcheko	Excel Worksheet Functions	5	April 25th 08 09:04 PM
How to prevent focus by clicking combo box ?	dennis logan[_2_]	Excel Programming	7	October 22nd 07 03:50 PM
Prevent Excel closing all workbook instances when clicking on "X"	Deeptech-NM	Excel Discussion (Misc queries)	8	July 4th 05 01:36 PM

All times are GMT +1. The time now is 10:40 PM.

Menu

About Us