| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to show old macros?
Hello newsgroup,
I've got an old worksheet from Excel 4.0 with macros in the old speech before VBA. Is there a possibility to show this old macros? The VB Editor only shows VBA macros... Peter |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show old macros?
You need to unhide the macro sheet that contains the macros.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message oups.com... Hello newsgroup, I've got an old worksheet from Excel 4.0 with macros in the old speech before VBA. Is there a possibility to show this old macros? The VB Editor only shows VBA macros... Peter |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show old macros?
Hello Chip,
all sheets are visible. The problem is that the macros are not written in VBA, but written in XLM. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show old macros?
XLM macros are stored in special worksheets. Use the following
code to make all sheets, including XLM macro sheets, visible. Then you can delete the sheet. Sub AAA() Dim s As Object For Each s In ThisWorkbook.Sheets s.Visible = True Next s End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com wrote in message ps.com... Hello Chip, all sheets are visible. The problem is that the macros are not written in VBA, but written in XLM. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show old macros?
I have used your code, but nothing happens. The numer of sheets remains
equal. There is no sheet with code. I'm using Excel 2002 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to show old macros?
Do you have any separate workbooks with an .xlm extension?
-- Regards, Tom Ogilvy wrote in message oups.com... I have used your code, but nothing happens. The numer of sheets remains equal. There is no sheet with code. I'm using Excel 2002 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do we get 2003 .xlb toolbars and custom macros to show in 07 | Excel Discussion (Misc queries) | |||
| How do I get my macros from an XLA file to show in Tools Macro | Excel Worksheet Functions | |||
| clearing macros in excel when none show up | Excel Discussion (Misc queries) | |||
| Why do macros show up while opening document, but were deleted? | Excel Discussion (Misc queries) | |||
| Macros in Personal.xls don't show up in other wksheets | Setting up and Configuration of Excel | |||
Hybrid Mode
