There are two possibilities - the relevant bit of the code is...
EDIT: Out of curiosity - this uses the same code, do you have the same problem when installing it?If Listed Then 'check this addins checkbox in the addin dialog box AddIns(AddinTitle).Installed = True Else 'it's not listed (not previously installed) 'add it to the addins collection 'and check this addins checkbox AddIns.Add(ThisWorkbook.FullName, True) _ .Installed = True End If
Last edited by Bob Phillips; 01-14-2022 at 07:31 AM. Reason: Updated code tags
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
