I have a custom add-in that I'm currently working on and recently I noticed that whenever I close down excel the add in will throw a compilation error out of the ThisWorkbook module from some code that I never put in and can't seem to delete. This is the code:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
With Application.CommandBars("Panels Manager")
On Error Resume Next
.Controls("
End Sub
Every time I delete this out and close excel then re-open this code gets regenerated. I hope to deploy this add-in to other users once it's complete and I can't have it throwing an error at everyone whenever they try to use excel with the add-in loaded.
Any help is greatly appreciated,
Thanks
Bookmarks