Macros in Excel 97 and 2000

Cornelia · Apr 5th, 2002, 07:52 AM

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 · Apr 5th, 2002, 07:59 AM

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

Tom Schreiner · Apr 5th, 2002, 08:00 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 07:52 AM	#1
Cornelia New Member Join Date: Apr 2002 Posts: 1	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.

Apr 5th, 2002, 07:59 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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

Apr 5th, 2002, 08:00 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Two Ceents here. As far as macros or anything else for that matter, I have had 0 problems from 97 to 2000.