View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Making a matching worksheet allowing drag and drop of protected cells...

Arnold,
I don't believe that is possible.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Arnold"

wrote in message
Hi Excel-lent Gurus,
I would like to make a worksheet for students that contains various
words to define (in one column) with their definitions (in some other
column). The definitions would be mixed up, and students would have to
either type the correct word into a cell next to the corresponding
definition, or drag & drop the word into the same cell for typing.

Instead of having to select a cell containing a definition word and
then dragging on the cell's border, a cell could be dragged just by
clicking on it once, holding the mouse (left button) down, and
dragging. Is coding for drag and drop like this possible?
Thanks much,
Arnold