XL2003 Macro Visibility


Hi Guys

Apologies if this one is an old chestnut but I have searched all over
the net all morning and in here and can't find it.

I have an application which runs fine in XL97/2000. It customises the
whole excel environment removing toobars etc etc and leaving its own
behind (each button being attached to a macro).

Now the odd thing is whenever I click on one of my toolbar buttons I
get (in XL2003 but not in the others..) something like "macro
'filename!macroname' cannot be found".

OK web searches throw up the obvious security thing - right the
security thing is on low - so no answer there.

Investigating further the only macros that can be run from Alt+f8 are a
few indeed (all of them 'subs' not 'public subs' (?!), and uncertain
about option private module effects).

Anyway having read and read and read tearing my hair out here on
something which I hope is trivial for those in the know!

many thanks

Mike


--
Mike_B
------------------------------------------------------------------------
Mike_B's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29087
View this thread: http://www.excelforum.com/showthread.php?threadid=488128

.