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.
| |
| |
|
|
|

Just curious: Wouldn't this be overruled by the other workbook?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jim Rech" wrote in message
...
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.
| |
| |
|
|
|

Thanks Jim

My typo in the first place.


Gord

On Thu, 12 Jul 2007 09:38:31 -0400, "Jim Rech" wrote:

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

Wouldn't this be overruled by the other workbook?

It would. I assume he wants to run this batch file/script after Excel is
closed.

--
Jim
"Jon Peltier" wrote in message
...
| Just curious: Wouldn't this be overruled by the other workbook?
|
| - Jon
| -------
| Jon Peltier, Microsoft Excel MVP
| Tutorials and Custom Solutions
| Peltier Technical Services, Inc. - http://PeltierTech.com
| _______
|
|
| "Jim Rech" wrote in message
| ...
| 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.
| | |
| | |
| |
| |
| |
|
|
|
|