Macro's from version 5

  • Thread starter Thread starter Joseph A. Zupko
  • Start date Start date
J

Joseph A. Zupko

Where does Excel hide the macros from version 5? I can't find the sheet.
 
Are you saying that you know where macros are in Version 4 but not in
Version 5 and on?
Answer: in the VBEditor. Use Tools|Macros|VPeditor to get to the VBA
application
Sorry if this is a mis-reading of your question
Bernard
 
Joseph

Just to clarify.

Excel 5 and earlier used Macro Module Sheets to store macros.

Excel 97 and newer uses a Visual Basic Editor and Modules to store macros.

ALT + F11 will take you to the VBE. View>Project Explorer to find your
workbook/project and Modules.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

How to record a macro within a macro 9
Running a macro from another workbook 2
Upadte PivotTable Data range 2
Macro Help 3
Need help with an excel macro to group & outine rows 0
Macro Runtime errors 8
VBA Question: Called macro stops unexpectedly 3
Macro Stoped Working 2

Back
Top