I found this neat code that will let you use VBA to switch the Tab on the ribbon. The code works great, well almost.
If I call it from the Auto_Open() procedure in an Excel file it does not work. However, if I then press F8 and rerun the Auto_Open() procedure it does exactly what it is supposed to do, .i.e. select the Add-Ins tab. I've tried everything I can think of to insert delays into the process hoping that would do the trick but no luck. Any Ideas.
Update: I just had a thought, amazing I know, but I was running this in compatibility mode, e.g. file type .xls. So I saved a copy as a .xlsm file and viola it works as it should. Now the only question is why when in compatibility mode does it work on the second run?