Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 4 Macro in 97 Worksheet (97)

    Hi,

    Not sure of the release of Excel - its on my machine at work. I rejigged a spreadsheet and now each time I open it up I get a macro error. It is pointing to a worksheet that does not exist now or before I played with it. When I look at personal.xls there is no auto_open macro nor any macro that I do not recognise.

    The help indicates it could be an excel 4 macro that may not be able to be deleted. Is there anything I can do? Wher else should I look.

    You may not see any reply from me as I am away for a while, but I shall check on my return

    Thanks

    Simon

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    Can you tell us EXACTLY what the error says?
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    Cant remember exactly - will post when I get back to work and have access to machine - will start new post if it is a while

    Thanks,

    Simon

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    When I open my workbook I get a Macro Error box with the following:

    Macro error at cell:
    [EN960126 JTIDS Nov 02 Draft.xls]ScDataworksheet!A1

    There is no - nor has there been a worksheet called ScDataWorksheet. - However some of the data in one of my worksheets was imported (copied - maybe even whole sheet copied) from a workbook generated from an application called showcase in Excel 4 format.

    When I click step I get:

    Cell: [EN960126 JTIDS Nov 02 Draft.xls]ScDataworksheet!A2
    Formula:
    =return()

    When I hit evaluate the =return line turns to italics

    next time I hit evalute the box goes away.

    When I close the workbook & reopen the same macro error appears, If I hit disable macro it tells me the workbook contains a Excel version 4 macro that cannot be disabled.

    The macro is not showing in the workbook.

    Anybody any suggestions how to get rid of this problem.

    Thanks

    Simon

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    I have done a bit of tinkering to try to narrow down the worksheet that may contain the problem. After inserting a new worksheet and deleting all the others the problem still remains.

    I have renamed and attached it in th hope somebody can track down an answer

    Thanks

    Simon
    Attached Files Attached Files

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    You can make the xl4 macro sheet visible by going
    into VB (alt-f11)
    immediate window (ctrl-g)
    and entering:
    activeworkbook.Sheets(1).visible = true

    This will display the hidden "ScDataWorksheet" and you can work with it. (erase it, delete it etc)

    Steve

  7. #7
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    The workbook does contain an Excel4 macro sheet which Steve has told you how to make visible. That macro sheet contains an AutoClose macro that is causing the problem. The macros on the macro sheet do not appear to do anything, so I would suggest deleting the macro sheet.
    Legare Coleman

  8. #8
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    113
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    Gents,

    Thank you for the replies - problem is solved.

    There is one other thing...........

    My workbook always asks if I want to save on close even when there has not been any changes. Why would that be? The workbook does contain a pivot table if this helps.

    Thanks again

    Simon

  9. #9
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 4 Macro in 97 Worksheet (97)

    There are may things that can cause that to happen. For example, if there is a formula anywhere in the workbook that includes the NOW() function.
    Legare Coleman

Posting Permissions

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