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/mi...23c93b94f35dc0

Any suggestion to delete or recover this?

Thanks all

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

"RCL" wrote:
| 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/mi...23c93b94f35dc0
|
| Any suggestion to delete or recover this?
|
| Thanks all
|

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.



RCL wrote:

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/mi...23c93b94f35dc0

Any suggestion to delete or recover this?

Thanks all

--

Dave Peterson