View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default closing subroutine

That code is event driven, and is invoked when the workbook is closed, there is no call that you will see in code.

If you don't want it, just remove the code.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Dean" wrote in message ...
I file I inherited has a private sub workbook before close that I can't seem to disable. I think it comes when I try to close out the file (duh!) and I suppose it is being called from somewhere else since, I stuck an apostrophe in front of the "Private" subroutine but it still keeps getting invoked, and crashing my exit attempt. How do I find from where it is being called and disable it there? I tried to search for the name but found it nowhere. Can it be within funcres or namemanager modules that seems to have passwords I don't know?