I am trying to find out if there is a way to use a registry setting to
enable/disable the Allow Drag and Drop feature in Excel 2003. So far the
only way I have found to do it is actually by going into Excel - Tools -
Options. Any help would be appreciated.

If you're creating an Excel application or add-in the way to do it is
through the object model:

Application.CellDragAndDrop = False

This is a user level setting however so if you change it for the duration of
your app you should change it back when it's done.

--
Jim
"BSchmeltz" wrote in message
...
|I am trying to find out if there is a way to use a registry setting to
| enable/disable the Allow Drag and Drop feature in Excel 2003. So far the
| only way I have found to do it is actually by going into Excel - Tools -
| Options. Any help would be appreciated.

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

Rightside window Option3

Enabled value is 64 (decimal base)

Disabled value is 80 (decimal base)


Gord Dibben MS Excel MVP


On Wed, 11 Jul 2007 11:52:01 -0700, BSchmeltz
wrote:

I am trying to find out if there is a way to use a registry setting to
enable/disable the Allow Drag and Drop feature in Excel 2003. So far the
only way I have found to do it is actually by going into Excel - Tools -
Options. Any help would be appreciated.

I do not have an "Option 3" entry in the location you provided. I attempted
to add it in as a DWORD value but that didn't appear to change anything. Not
sure what I am doing wrong. Any ideas?

"Gord Dibben" wrote:

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options

Rightside window Option3

Enabled value is 64 (decimal base)

Disabled value is 80 (decimal base)


Gord Dibben MS Excel MVP


On Wed, 11 Jul 2007 11:52:01 -0700, BSchmeltz
wrote:

I am trying to find out if there is a way to use a registry setting to
enable/disable the Allow Drag and Drop feature in Excel 2003. So far the
only way I have found to do it is actually by going into Excel - Tools -
Options. Any help would be appreciated.

There is no space before the "3".

Humor me. Why are you doing this through the registry?

--
Jim
"BSchmeltz" wrote in message
...
|
| I do not have an "Option 3" entry in the location you provided. I
attempted
| to add it in as a DWORD value but that didn't appear to change anything.
Not
| sure what I am doing wrong. Any ideas?
|
| "Gord Dibben" wrote:
|
| HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
|
| Rightside window Option3
|
| Enabled value is 64 (decimal base)
|
| Disabled value is 80 (decimal base)
|
|
| Gord Dibben MS Excel MVP
|
|
| On Wed, 11 Jul 2007 11:52:01 -0700, BSchmeltz
| wrote:
|
| I am trying to find out if there is a way to use a registry setting to
| enable/disable the Allow Drag and Drop feature in Excel 2003. So far
the
| only way I have found to do it is actually by going into Excel -
Tools -
| Options. Any help would be appreciated.
|
|

I was typing it "Option3" in the registry I must not have been paying
attention when I replied.

The reason I am trying to do this is we currently have an entire department
of about 50 users that use a spreadsheet created by another group that
contains different macros. One of them is disabling both the cut function
and the Drag and Drop function. I have figured out a way to enable to cut
again and have created a batch file so that users can run that, I am hoping
to add to that batch file the registry changes to enable the drag and drop.
This is all being done as a temporary work around until the group gets there
spreadsheet configured correctly but I am not anticipating a quick response
from them.

If there are other ways to do this in a batch file that doesn't involve the
registry I would be more than willing to try them.

Thanks

Brian Schmeltz

"Jim Rech" wrote:

There is no space before the "3".

Humor me. Why are you doing this through the registry?

--
Jim
"BSchmeltz" wrote in message
...
|
| I do not have an "Option 3" entry in the location you provided. I
attempted
| to add it in as a DWORD value but that didn't appear to change anything.
Not
| sure what I am doing wrong. Any ideas?
|
| "Gord Dibben" wrote:
|
| HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
|
| Rightside window Option3
|
| Enabled value is 64 (decimal base)
|
| Disabled value is 80 (decimal base)
|
|
| Gord Dibben MS Excel MVP
|
|
| On Wed, 11 Jul 2007 11:52:01 -0700, BSchmeltz
| wrote:
|
| I am trying to find out if there is a way to use a registry setting to
| enable/disable the Allow Drag and Drop feature in Excel 2003. So far
the
| only way I have found to do it is actually by going into Excel -
Tools -
| Options. Any help would be appreciated.
|
|

I don't know about a batch file but when I put this in a VBS file and run it
it resets D&D:

Dim wsh
Set wsh = CreateObject("WScript.Shell")
wsh.RegWrite "HKCU\Software\Microsoft\Office\11.0\Excel\Options \Options3",
64, "REG_DWORD"

Btw, it's Options3 (with an "s") which probably explains why it didn't work
for you.

--
Jim
"BSchmeltz" wrote in message
...
|I was typing it "Option3" in the registry I must not have been paying
| attention when I replied.
|
| The reason I am trying to do this is we currently have an entire
department
| of about 50 users that use a spreadsheet created by another group that
| contains different macros. One of them is disabling both the cut function
| and the Drag and Drop function. I have figured out a way to enable to cut
| again and have created a batch file so that users can run that, I am
hoping
| to add to that batch file the registry changes to enable the drag and
drop.
| This is all being done as a temporary work around until the group gets
there
| spreadsheet configured correctly but I am not anticipating a quick
response
| from them.
|
| If there are other ways to do this in a batch file that doesn't involve
the
| registry I would be more than willing to try them.
|
| Thanks
|
| Brian Schmeltz
|
| "Jim Rech" wrote:
|
| There is no space before the "3".
|
| Humor me. Why are you doing this through the registry?
|
| --
| Jim
| "BSchmeltz" wrote in message
| ...
| |
| | I do not have an "Option 3" entry in the location you provided. I
| attempted
| | to add it in as a DWORD value but that didn't appear to change
anything.
| Not
| | sure what I am doing wrong. Any ideas?
| |
| | "Gord Dibben" wrote:
| |
| | HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options
| |
| | Rightside window Option3
| |
| | Enabled value is 64 (decimal base)
| |
| | Disabled value is 80 (decimal base)
| |
| |
| | Gord Dibben MS Excel MVP
| |
| |
| | On Wed, 11 Jul 2007 11:52:01 -0700, BSchmeltz
| | wrote:
| |
| | I am trying to find out if there is a way to use a registry setting
to
| | enable/disable the Allow Drag and Drop feature in Excel 2003. So
far
| the
| | only way I have found to do it is actually by going into Excel -
| Tools -
| | Options. Any help would be appreciated.
| |
| |
|
|
|