Why does workbook think deleted macro still exits?

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
'/================================================/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top