"excel "macros may be disabled" message using an xlam file

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
Macro Settings
o Enable all macros
x Trust access to the VBA project object model
nothing is checked, neither Require... nor Disable...

In the addin Excel Object
IsAddin = True

Why doesn't it work? I guess I should reboot and see if that fixes it...
 
G

Gord Dibben

What you state does not make sense.
I open the addin file and my spreadsheet.xlam

An *.xlam file is an add-in.

Are you opening the add-in directly instead of loading through Add-ins?

Are you opening the same add-in twice?


Gord Dibben MS Excel MVP
 
F

frustrated

I open the addin file and my spreadsheet.xlam
An *.xlam file is an add-in.
Are you opening the add-in directly instead of loading through Add-ins?
Are you opening the same add-in twice?

Thank you VERY much for answering. Sorry I didn't reply sooner- I signed up
to be notified of replies, but I received no notice...

I double-clicked on my addin file to open it.

A few weeks ago, when I started working with the addin file, I added it
using Options>Addins (a very confusing interface.) Soon after, I tried to
check it in, but my source control system said it wasn't changed!!! After a
LOT of work, I discovered Excel had copied my local addin file (on my C:
drive) to a ~user/.../Roaming directory without warning me!!! When I
discovered this, I stopped using this unreliable interface and now I simply
double-click the file to use it.

One simple function of my addin macros is to add a new page with a certain
format. So I double-click my addin.xlam file, then hit a button in my ribbon
and a new page appears (in a new workbook, if none is open.) This worked for
weeks before 7/7. Now I just get the frigging alert... (I even reverted my
addin file to an old version everyone else uses- it works fine for them, but
I get the alert.)

So no, I don't open it twice. (Occasionally when I accidentally do, it puts
up an alert so I can cancel.)

Note that I was getting this alert in Outlook, too (we use one macro to open
a bug when a bug number is referenced by an email.) Last Friday I ran Office
Diagnostics. It found and corrected two problems. (Of course, it didn't
give me any information about them...) The next time I opened Outlook, it
warned me that macros were disabled at startup and gave me the option to
enable them. I did, and then the Outlook macro worked. The next two times I
started Outlook, it again warned me that macros were disabled. Both times I
enabled them in the same manner as the first time. Today they were enabled
when I started Outlook.

But the problem in Excel remains. At this point my only idea is to
reinstall office. Your help would be much appreciated.
-r
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top