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