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
| 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
| _______
|
|
| | >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
| > | > |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
| > | > | > | > |
| > | > | 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\Excel\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
| > | > | >
| > | > | > >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.
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
|
|