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

kaos · Mar 25th, 2002, 09:42 AM

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.

Mark O'Brien · Mar 25th, 2002, 09:57 AM

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

kaos · Mar 25th, 2002, 10:26 AM

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.

Mark O'Brien · Mar 25th, 2002, 10:30 AM

Have you got any macros running on this spreadsheet?

kaos · Mar 25th, 2002, 10:31 AM

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

Mark O'Brien · Mar 25th, 2002, 10:43 AM

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.

kaos · Mar 25th, 2002, 10:54 AM

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.

Mark O'Brien · Mar 25th, 2002, 10:58 AM

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

kaos · Mar 25th, 2002, 11:16 AM

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

Mark O'Brien · Mar 25th, 2002, 11:27 AM

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?

Mar 25th, 2002, 09:57 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Make sure your "F5" key isn't stuck down. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 25th, 2002, 10:30 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Have you got any macros running on this spreadsheet? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 25th, 2002, 10:43 AM	#6
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 25th, 2002, 10:58 AM	#8
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Did you try disabling the macros though? It could be that someone has recently taken a notion to try to "improve" your existing macros. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 25th, 2002, 11:27 AM	#10
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Mar 25th, 2002, 09:42 AM	#1
kaos New Member Join Date: Mar 2002 Posts: 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.

Mar 25th, 2002, 10:26 AM	#3
kaos New Member Join Date: Mar 2002 Posts: 5	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.

Mar 25th, 2002, 10:31 AM	#5
kaos New Member Join Date: Mar 2002 Posts: 5	Yes, they are enabled but I do not know what they are (I never made the spreadsheet).

Mar 25th, 2002, 10:54 AM	#7
kaos New Member Join Date: Mar 2002 Posts: 5	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.

Mar 25th, 2002, 11:16 AM	#9
kaos New Member Join Date: Mar 2002 Posts: 5	Hi again Mark. I checked on the macros and the newest one is dated in 1999 and the computer's clock is correct.

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