That's what I figured but shouldn't it only call auto_open if the user
answers no on the button? Otherwise it should read through the code for vbYes,
as it does and then End Sub. Why doesn't End Sub do just that when it is
reading the line End Sub? I have stepped through it several times......???

FYI - I recall auto_open in case the user made a mistake and needs to start
again.

P.S. I have even removed the auto_open from the code and re-tested. It still
won't end.

Thx for any assistance with this

FSt1 wrote:
hi
looks like you are caught in a endless loop.
sub auto_open calls sub daily which calls sub auto_open which calls sub
daily......
and on and on and on.......
why are we calling sub auto_open at the end of daily????????

regards
FSt1

This is perplexing.........I have three macro's (I removed all the 'work'
portion of the code to shorten it) but basically, If I follow the path of
[quoted text clipped - 54 lines]
€˜Begin Input
End Sub

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200805/1