Macros in Excel 97 and 2000

[Cornelia]

I am the Desktop Software Support professional in my association. We are moving to Windows 2000 and Office 2000 from Win 95 and respectively Office 97.

My two questions are:
1. What are the problems, if any, I should anticipate when upgrading from Office 97 to Office 2000 with Macros?
2. How can I see and edit the macros in a workbook? I just opened a workbook and hit Enable to the Disable/Enable dialog box. However, when I go in Tools-Macros, I don't see any.
Thank you.

 

[AJ]

Hiya,

On the first point, we recently upgraded and had more or less no problems whatsoever with macros going from Excel97 to 2000 - others may be able to shed more light...

To answer the second query, if you opened a file and you were prompted to enable/disable but cannot see any macros then these will be macros that start with
"Private Sub"
and are not in the modules of the workbook, but rather in either the Sheets or the ThisWorkbook section of VBA.
Go into the Visual Basic editor and in the VBAProject window have a look at the sheets/ThisWorkbook and see what you've got.
Generally you use this sort of code to run a macro on an event (such as when the workbook opens or closes, or when a cell value is changed, etc. etc.)

Rgds
AJ

 

[Legacy 98055]

Two Ceents here.
As far as macros or anything else for that matter, I have had 0 problems from 97 to 2000.