I think the naming is the key here. I'll check Essbase options as well.

The title is just intended to get the attention of the experts like you.

Thanks you all.

"-" wrote:

Essbase hijacks some features in Excel that you should probably disable,
such as dbl-clicking on a cell. That's an option that you can disable. I'm
guessing some action you performed is linked to Essbase, as I recall when I
used it a while ago. Poke around the Essbase options and see if something
looks like it might get activated, say if you right click on a sheet. One
question though: does your macro work properly if you run it from the VBE,
as opposed to how you have linked it to your menu action? If so, it's
probably most definitely an Essbase option that can be disabled.

Not sure I understand what you mean when you say "Option Explicit when
install Essbase." Is Essbase enforcing good coding habits?


"LuisE" wrote in message
...
I created an add-in that was working right until I installed Essbase.
I added a line to Hide/Unhide sheets to the tab contextual menu, since I
have Essbase the macro stopped working and returns a Argument not optional
error.
Help please!!!!!!!!!!!!!!!