Posted to microsoft.public.excel.programming

William[_2_] William[_2_] is offline

external usenet poster

Posts: 227

Prevent multiple cell select

Hi Spaan

Try placing the code below in a worksheet module...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveCell.Select
End Sub

--
XL2002
Regards

William

"Spaan" wrote in message
...
| Is it possible to prevent a user from selecting more than one cell at a
time?

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
multiple-select list in a cell	stevemann	Excel Discussion (Misc queries)	0	January 16th 09 05:53 PM
Using Multiple Choices to Select a Value in a Cell	JHKirk3rd	Excel Discussion (Misc queries)	0	March 13th 07 06:45 PM
How do I Select Multiple Non Adjacent Rows based on a cell value?	avalynch	Excel Worksheet Functions	2	October 1st 06 07:45 PM
How do I Select Multiple entries from Valid list for a Cell	WIDBIS	Excel Discussion (Misc queries)	1	June 29th 05 12:53 AM
Prevent more than one check box select	Bill[_19_]	Excel Programming	2	January 1st 04 12:24 AM

All times are GMT +1. The time now is 06:20 PM.

About Us

"It's about Microsoft Excel"