closing subroutine

[Dean]

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?

 

[Bob Phillips]

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)

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?

 

[Dean]

You can't just put an apostrophe in front of the private sub, right?
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)

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?

 

[Dean]

I assume there is something magic about the exact name "sub workbookbefore close" that causes the program to recognize it? Is that right?
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)

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?

 

[Bob Phillips]

Partly the name of the procedure, partly the fact that it is in the ThisWorkbook code module. You could put ' in front of it but the code will throw a compilation error.

--

HTH

Bob Phillips

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

I assume there is something magic about the exact name "sub workbookbefore close" that causes the program to recognize it? Is that right?
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)

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?

 

[Dean]

Thanks much, Bob
Partly the name of the procedure, partly the fact that it is in the ThisWorkbook code module. You could put ' in front of it but the code will throw a compilation error.

--

HTH

Bob Phillips

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

I assume there is something magic about the exact name "sub workbookbefore close" that causes the program to recognize it? Is that right?
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)

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?