Show All actions "greyed out"

[TracieLee]

I am trying to turn warning off and back on again before and after a macro action. The Show all Actions button is greyed out.

I have been able to see this in other databases I have been working on, and can't work out wha tis different with this one.
any help would be much appreciated!!

 

[namliam]

warning has nothing to do with "greying" buttons.

This is done using Enable(d)

 

[TracieLee]

I am in Macro Design and ordinarily I can select the "Show All Actions" button in order to have an expanded list of actions to choose from (of which SetWarnings is one). There are four buttons on the show/Hide section of the ribbon. Arguments, Conditions, Macro Names and Show All Actions. The first three are available to select, but the Show all Actions button is greyed out and I am unable to select it to get the expanded Actions List. I was wondering why this is the case. I could go through and code it, but as all of the Macros are already set up in this database, it would be easier to turn off the warnings in the Macro Window. Just wondering if there is a simple answer to why I can't select this menu option.

 

[namliam]

I dont use Macro's I use VBA as well... I am totaly not comvertable using macro's to confined...

Warnings (or setwarnings) though has nothing to do with enabeling buttons (as far as I know)

 

[boblarson]

I am trying to turn warning off and back on again before and after a macro action. The Show all Actions button is greyed out.

I have been able to see this in other databases I have been working on, and can't work out wha tis different with this one.
any help would be much appreciated!!

Make sure you've done this.

 

[TracieLee]

Thanks Bob, but yes, I have all the Trust Centre settings as you suggest. The weird thing is that all the other databases are fine, it is just this one. I am at a loss as to what setting I have on this one that is different!!

 

[boblarson]

Thanks Bob, but yes, I have all the Trust Centre settings as you suggest. The weird thing is that all the other databases are fine, it is just this one. I am at a loss as to what setting I have on this one that is different!!

I would just double check that THAT database is IN one of the trusted locations. If it isn't it would exhibit the described problem. That is the only reason I can fathom for that button to be disabled where it isn't on the other databases. UNLESS it is really an ACCDE or ACCDR file you are working with, but then you shouldn't be able to get into design view on the macros.

 

[TracieLee]

Wierd huh? I had already unset and reset the trusted locations and it didn't make any difference. Oh....well I suppose I can stop being lazy and just code it anyway!!

 

[_trogdor]

Sort of late to comment on this, but I just ran into the same thing. For me, the macro in question was embedded, and "Show all actions" was grayed out. When I hit "Save As", it allowed me to use the restricted actions. If you haven't already coded past your problem, perhaps that could work.