Removing 4.0 macros?

[mrl]

I have an excel file created under 5.0 that when I open it up, with
macros disabled, it claims there are 4.0 macros. I can't figure out
where they are, and how o delete them. I don't have 5.0 any more. Any
help? Thanks.

 

[Walt]

Hi mrl,

If you haven't gone to the menu picks Format/Sheet/Unhide, try that
first and make sure there are no hidden sheets.

If the 'Unhide' pick is grayed out, the macro sheet(s) may have
its(their) Visible property set to xlVeryHidden. The only way to
change that is via VBA code. The following code entered to a VBA
module inserted in the file via the VBA editor and run will make any
sheets (Including 4.0 Macro and Dialog sheets) in the workbook visible
as long as the workbook structure is not protected:

Sub unhideallsheets()
For Each sh In ThisWorkbook.Sheets
sh.Visible = True
Next
End Sub

This does presume any VBA in this file is not password protected so you
can get to it.

Best Regards,
Walt Weber

 

[mrl]

Thanks, though no luck. Looks like they must be well imbedded, maybe
used for buttons on the pages or something like that. Strangely, these
files work fine on the latest version of excel on the PC, but cause
problems on excel 2004 (crashes, looping).

 

[Walt]

Hi mrl,

Macro sheets can look like regular worksheets. Is each of the sheets
you see in the Excel window also represented in the Microsoft Excel
Objects listing for this file in the Visual Basic Editor? If not, and
it looks like a worksheet, it's a macro sheet.

Though not required, most 4.0 Macros when written have their first cell
or possibly all cells included in a named range. If you can identify
the macro sheet(s) check the named ranges in it/them for macro coding.

NOTE: It is easily possible I'm missing something re. the Mac -- I've
been away from it for a number of years.

Best Regards,
Walt Weber