EXCEL WILL CLOSE IF I CLICK PAGE

B

Bamabo12

I have a file created in Excel. And when I open it it's fine, but when I
click ANYWHERE on the page it will automatically close (with no
prompt/nothing) it just closes. Why is this happening?
 
M

Mike H

Hi,

Do you enable macros when you open this file? If you do open with macros
disabled and see if the problem goes away. If it does then it seems you may
have some worksheet code tht's causing the problem. Open VB editor and have a
look at what's in there. Your looking for something like

Application.displayalerts=false
activeworkbook.close savechanges....


Mike

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top