Cyberdude
08-21-2006, 11:51 AM
Something strange has happened and I'm not sure what. I first noticed that in my macro code whereever I have ".Name" the "N" is now in lowercase instead of uppercase. It doesn't seem to keep the code from working, but it seemed odd that all of a sudden the VBE isn't capitalizing the "N".
Now when I try to close Excel, I always get the message "This workbook is referenced by another workbook and cannot be closed." Then when I click the "X" in the upper right corner to close Excel, it closes! At that time there are no other workbooks open except Personal.xls. I did a search of Personal.xls and couldn't find any links in the macros or the worksheets, and there are no links listed in the Edit Links list.
Then I checked the References list and didn't see anything out of the ordinary checked.
And every so often when I invoke the compiler in the VBE (I use it to find unexpected errors) I'll get an error in a macro in Personal.xls at a point where I'm using the "Left" function. It says it can't find the function. I checked the references list, and found "funcres" was not checked. I have no idea what's in funcres, but I checked it and the error message stopped occurring.
Does anyone have any idea what this is all about? :banghead:
Now when I try to close Excel, I always get the message "This workbook is referenced by another workbook and cannot be closed." Then when I click the "X" in the upper right corner to close Excel, it closes! At that time there are no other workbooks open except Personal.xls. I did a search of Personal.xls and couldn't find any links in the macros or the worksheets, and there are no links listed in the Edit Links list.
Then I checked the References list and didn't see anything out of the ordinary checked.
And every so often when I invoke the compiler in the VBE (I use it to find unexpected errors) I'll get an error in a macro in Personal.xls at a point where I'm using the "Left" function. It says it can't find the function. I checked the references list, and found "funcres" was not checked. I have no idea what's in funcres, but I checked it and the error message stopped occurring.
Does anyone have any idea what this is all about? :banghead: