Quote Originally Posted by gmr4evr1 View Post
A lot of us are unable to see images posted here, can you type the message you are getting?

Cannot find the C:\Program Files\MS Office\Office14\....\blah.xla'!SheetClose, which has been assigned to run each time Canada Overheads.xlsx is closed. Continuing could cause errors. Cancel closing Canada Overheads.xlsx? Yes, No


Quote Originally Posted by Richard Buttrey View Post
Stating the obvious, and assuming you mean that the screen shot you show is the 'Error' message to which you refer, do you actually have that .xla Add in file in the C:\.....folder indicated?
Yes that's the error message. I dont seem to have that xla file. Nor am I looking to put that in, I just want to remove any kind of dependency to that file. There shouldnt be any either, the tab I brought in I consider hardcoded (whether it is or not) so I want to remove any dependencies.

Quote Originally Posted by FDibbins View Post
As it says, it is looking for a file that it needs to run when that specific file is closed. It cannot find that file tio run, so the VBA code is throwing up that error. Try and find the file and put it back in that location
I dont want to go that route. I'd rather remove any dependencies on that file.