Go To Window pops up by itself in Excel 2000...help :-)
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Go To Window pops up by itself in Excel 2000...help :-)

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

    Default

     
    In Excel 2000 the Go To window pops up by itself. It can called upon normally by Ctrl-G but this is disrupting the process. The spreadsheet never used to have this problem but has just appeared and seems to when it pops up disrupt other programs. Any help would be appreciated.
    Thank you.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Make sure your "F5" key isn't stuck down.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you but that doesn't seem to be the problem. When the window pops up by itself clicking cancel only causes it to pop up again and again.

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you got any macros running on this spreadsheet?

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

    Default

    Yes, they are enabled but I do not know what they are (I never made the spreadsheet).

  6. #6
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do me a favour then. Open the spreadsheet up and when it asks to Enable/Disable macros then choose to disable them. If the Go To box doesn't come up, then I think we've found the culprit.

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Mark. The operators use the macros for there is about 11 different sub-sheets in each spreadsheet that places data in different areas. These spreadsheets have been used for the last 2 years and only in the last couple of days has this problem arised.

  8. #8
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Did you try disabling the macros though? It could be that someone has recently taken a notion to try to "improve" your existing macros.

  9. #9
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi again Mark. I checked on the macros and the newest one is dated in 1999 and the computer's clock is correct.

  10. #10
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Where is the macro dated? As a comment in the code or as when the last time worksheet was saved?

    Barring sticky keys or a macro running the GoTo box, I haven't been able to work out what the problem is.

    Have you tried disabling the macros in the workbook?

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