displaying old Macro code

[PipeDown]

I am using a Macro program written in Excel. It was originally written in
Excel 4.0 macro code and eventually ported into VBA. The developer kept
both versions on the code and saved them in .XLW files. I need to edit the
old code to disable it but cannot do anything but run it.

The .XLW files contain an XLS sheet and a XLM macro spreadsheet and some VBA
code.

I can see the sheet and the VBA code but I cannot display the old Macro
Code. I can see the macros listed in the Macro window but pressing Edit
does nothing. Is there a module I need to install?

If I crash a portion of the program using that macro code, the old debugger
starts and references the cells in the XLM sheet but I cannot show this
sheet.

I used to just use Unhide to show the XLM as a tab in the XLW but I cannot
anymore in Excel 2003

Does anybody know how to display these macro spreadsheets in Excel 2003 if
not how many versions do I need to go back before I can do it.

 

[Dave Peterson]

Maybe you could use some VBA code to show that macro sheet.

Option Explicit
Sub testme()

Dim sh As Object

For Each sh In ActiveWorkbook.Sheets
sh.Visible = xlSheetVisible
Next sh

End Sub

This actually shows all the sheets. If you want you could limit it to just the
macrosheets.


Option Explicit
Sub testme()

Dim sh As Object

For Each sh In ActiveWorkbook.Sheets
If sh.Type = xlExcel4MacroSheet Then
sh.Visible = xlSheetVisible
End If
Next sh

End Sub