Option Explicit when install Essbase

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LuisE - 13 Sep 2007 01:50 GMT

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!!!!!!!!!!!!!!!

Reply to this Message

Dave Peterson - 13 Sep 2007 02:35 GMT

Any chance that your macro's name and Essbase were unlucky enough to be the
same?

If you change your macro's name to something more unique: LuisEHideUnhideMac

Does it help?

> 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!!!!!!!!!!!!!!!

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 13 Sep 2007 02:35 GMT

Ps. I don't use Essbase, so that's a guess.

Signature

Dave Peterson

Reply to this Message

Jim Cone - 13 Sep 2007 02:51 GMT

Dave,
I don't use Essbase either (whatever that is). However, a similar situation
to the one described happened to a user of one of my add-ins.
The ASAP program and my add-in were sharing a sub name.

I now take care to give unique names to subs and functions.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Dave Peterson" <petersod@verizonXSPAM.net>
wrote in message
Ps. I don't use Essbase, so that's a guess.

LuisE wrote:

Signature

Dave Peterson

Reply to this Message

LuisE - 13 Sep 2007 02:56 GMT

Essbase carries a lot of routines it is a possibility that my macro's name is
repeated. I'll check, I have it at work.
Thanks for the prompt response

> Ps. I don't use Essbase, so that's a guess.
>
[quoted text clipped - 3 lines]
> > error.
> > Help please!!!!!!!!!!!!!!!

Reply to this Message

- - 13 Sep 2007 02:54 GMT

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?

>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!!!!!!!!!!!!!!!

Reply to this Message

LuisE - 13 Sep 2007 03:06 GMT

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.

> 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
[quoted text clipped - 13 lines]
> > error.
> > Help please!!!!!!!!!!!!!!!

Reply to this Message