Macros in Excel 97 and 2000
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Macros in Excel 97 and 2000

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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



  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com