exec_gerbil
04-18-2013, 10:19 AM
Dearies,
I have followed the instructions in an ebook (Excel VBA: 24hour Trainer by Tom Urtis) and it runs fine, so I saved it to my AddIns. Unfortunately I get this Error Message when I press the Sheet Manager button on the Add-Ins tab (Excel 2010):
Cannot run the macro 'SheetMgr AddIn.xlam'!Sheet Manager'. The macro may not be available in this workbook or all macros may be disabled.
Bit confused, cos I thought the point of AddIns was that they would run regardless of security settings. Is this something to do with Trust Center/Digital Certificates?
All ideas gratefully received.
Thanks,
Gerb
I have followed the instructions in an ebook (Excel VBA: 24hour Trainer by Tom Urtis) and it runs fine, so I saved it to my AddIns. Unfortunately I get this Error Message when I press the Sheet Manager button on the Add-Ins tab (Excel 2010):
Cannot run the macro 'SheetMgr AddIn.xlam'!Sheet Manager'. The macro may not be available in this workbook or all macros may be disabled.
Bit confused, cos I thought the point of AddIns was that they would run regardless of security settings. Is this something to do with Trust Center/Digital Certificates?
All ideas gratefully received.
Thanks,
Gerb