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

kaos

New Member
Joined
Mar 24, 2002
Messages
5
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.
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
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.
 
Upvote 0
Yes, they are enabled but I do not know what they are (I never made the spreadsheet).
 
Upvote 0
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.
 
Upvote 0
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.
 
Upvote 0
Did you try disabling the macros though? It could be that someone has recently taken a notion to try to "improve" your existing macros.
 
Upvote 0
Hi again Mark. I checked on the macros and the newest one is dated in 1999 and the computer's clock is correct.
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,526
Messages
6,114,122
Members
448,550
Latest member
CAT RG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top