Recover Office Registry

[RCL]

Hi, I have run this macro that I have found in this forum. It was
supposed to fix some subtotal problems of Excel. The problem is that it
has damaged some other Excel functions.

The macro is this:

Sub RegWriteXL97Subtotals()
Dim wsh As Object
Set wsh = CreateObject("WScript.Shell")
wsh.RegWrite
"HKCU\Software\Microsoft\Office\11.0\Excel\Options\Excel97Subtotals",
1,
"REG_DWORD"
End Sub

http://groups.google.com.ar/group/m...gWriteXL97Subtotals()&rnum=1#d523c93b94f35dc0

Any suggestion to delete or recover this?

Thanks all

 

[Dave Patrick]

Maybe this one helps.

http://support.microsoft.com/kb/870757/

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

:
| Hi, I have run this macro that I have found in this forum. It was
| supposed to fix some subtotal problems of Excel. The problem is that it
| has damaged some other Excel functions.
|
| The macro is this:
|
| Sub RegWriteXL97Subtotals()
| Dim wsh As Object
| Set wsh = CreateObject("WScript.Shell")
| wsh.RegWrite
| "HKCU\Software\Microsoft\Office\11.0\Excel\Options\Excel97Subtotals",
| 1,
| "REG_DWORD"
| End Sub
|
|
http://groups.google.com.ar/group/m...gWriteXL97Subtotals()&rnum=1#d523c93b94f35dc0
|
| Any suggestion to delete or recover this?
|
| Thanks all
|

 

[Dave Peterson]

I don't see how this one setting will break other functions. But you could
remove that key to get things back to the way things were.

You may want to post some examples of what broke. My first guess is that it was
just coincidence--not cause and effect.