G
Gary Brown
If you have an Excel v4 macro, this hidden macro will
continue to make that message appear. Some management
reporting systesm such as versions of ORACLE Discoverer
will automatically create these macros.
Run the following program to see if any of these Macros
suddenly appear as a 'worksheet'.
HTH,
Gary Brown
'/================================================/
Public Sub Macro_v4_Unhide()
'Purpose of this VBA program is to unhide the
' Microsoft Excel version 4.0 macros in a Workbook
'
Dim wsSheet As Worksheet
On Error Resume Next
For Each wsSheet In ActiveWorkbook.Sheets
If UCase(Left(wsSheet.Name, 5)) = "MACRO" Then
wsSheet.Visible = True
wsSheet.Activate
End If
Next
End Sub
'/================================================/
continue to make that message appear. Some management
reporting systesm such as versions of ORACLE Discoverer
will automatically create these macros.
Run the following program to see if any of these Macros
suddenly appear as a 'worksheet'.
HTH,
Gary Brown
'/================================================/
Public Sub Macro_v4_Unhide()
'Purpose of this VBA program is to unhide the
' Microsoft Excel version 4.0 macros in a Workbook
'
Dim wsSheet As Worksheet
On Error Resume Next
For Each wsSheet In ActiveWorkbook.Sheets
If UCase(Left(wsSheet.Name, 5)) = "MACRO" Then
wsSheet.Visible = True
wsSheet.Activate
End If
Next
End Sub
'/================================================/