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?

LuisE wrote:

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

--

Dave Peterson