View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RCL RCL is offline
external usenet poster
 
Posts: 10
Default Recover Office Registry

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