F
frustrated
I have an xlam addin file. A few minutes ago it was working fine.
I open the addin file and my spreadsheet.xlam
The xlam file adds a ribbon. I click on a button and get:
Cannot run the macro 'Validate' ...may not be available...or all macros
may be disabled.
If I open up Visual Basic, I can run the macro and it works.
Excel Options>Add-Ins, I don't even see my add-in...
(but the ribbon is there...)
Excel Options>Trust Center
x Trust access to the VBA project object model
In the addin Excel Object
IsAddin = True
Why doesn't it work? I guess I should reboot and see if that fixes it...
I open the addin file and my spreadsheet.xlam
The xlam file adds a ribbon. I click on a button and get:
Cannot run the macro 'Validate' ...may not be available...or all macros
may be disabled.
If I open up Visual Basic, I can run the macro and it works.
Excel Options>Add-Ins, I don't even see my add-in...
(but the ribbon is there...)
Excel Options>Trust Center
o Enable all macrosMacro Settings
x Trust access to the VBA project object model
nothing is checked, neither Require... nor Disable...Add-Ins
In the addin Excel Object
IsAddin = True
Why doesn't it work? I guess I should reboot and see if that fixes it...