> On Sat, 29 Apr 2000 02:54:06 +1000, "Stormin' Norm"
> >Hi Thomas
> >Try Private Sub Workbook_BeforeClose(Cancel As Boolean)
> >It goes in the This Workbook Module
> You can also just go to the code of the ThisWorkbook and select the
> event you want to trap with the drop-down box in the top right corner
> of the code window.
> James Shoffit, Irving, TX
Thanks for the tip. I didn't know that before. This will definitely
make it easier to resolve some of these types of issues myself, rather
than needing to go to the newsgroup. However, there is one small detail
that you forgot to mention. Once you open the This Document module, the
right side of the screen will have 2 drop-down boxes at the top. If the
one on the left shows "General" then the drop-down box on the right will
only show you the existing subroutine names in the module. You need to
change the drop-down box on the left so that it shows "Workbook", then
the drop-down box on the right will show all the stuff you're talking
Please reply to the newsgroup so that all may learn
from your wisdom.