Auto New Worksheet when closing Excel??

Posted by FJ on January 02, 2002 11:59 PM

Can anyone please let me know of a way to prevent this from happening again: Each time I close an excel workbook a new one automatically opens. How do I prevent this from happening?

Posted by Jacob on January 03, 2002 12:03 AM

There must be a macro doing this. If it happens all the time then it is in your personnal.xls workbook. In VB check the personnal.xls for any code.

Jacob

Posted by FJ on January 03, 2002 12:27 AM

Hi Jacob, thx for the advise, could you pls tell me where this file can be located. Will it only be generated when a user starts using macro's?

Posted by Jacob on January 03, 2002 12:31 AM

Ther personnel.xls file is a hidden file that is always open with excel. Open Excel press ALT + F11 and look on the left hand side where is says personnel.xls check for some code that looks like this.

sub workbook_beforeclose()
workbooks.add
end sub

HTH
Jacob