Thread: VBA References
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tommy T Tommy T is offline
external usenet poster
 
Posts: 9
Default VBA References

I have a workbook that references an add-in. I am trying
to close the add-in when I close the workbook, but I
can't get it to work. I just get the message that "This
workbook is currently referenced by another workbook and
cannot be closed." I've tried putting the code in the
BeforeClose event, but since the workbook is technically
not closed yet, it still doesn't work.

Any Suggestions?
TT