View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
chris chris is offline
external usenet poster
 
Posts: 17
Default close workbook without closing excel and stop recursive function

I fixed the problem by moving the stop and start function from Private
in this workbook to public in the module. Not sure why that fixes it,
but seems to work now.


chris wrote:
Yeah. The actual functions are in the modules associated with the
workbook and the function that starts and stops it is in the This
Workbook sheet associated with this project. Why?


Dann Pedersen wrote:
"chris" wrote in message
ps.com...
<SNIP some VBA code
However, it just reopens the workbook a second later when it apparently
calls the StartBlink function again. Anyway to modify some of this
code to allow users to close the workbook for good without closing any
other excel windows? Thanks in advance!


Do you happen to have the code in the workbook you close?

/Dann