I have a custom popup menu on the Worksheet Menu Bar on which I would
like to make particular buttons unavailable in certain circumstances.

Rather than setting their enabled property to false (and having them
disappear, which I think would confuse users), I would prefer to have
them there all the time but greyed out in those certain circumstances.

Can this be done? Or is greying out available only to Excels' built in
menus?

Suggestions appreciated

matthew

Matthew,

Being not enabled is greyed out. The control is still there but not
clickable. Visible will change it's visibility not the Enabled property.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Matthew Dodds" wrote in message
ps.com...
I have a custom popup menu on the Worksheet Menu Bar on which I would
like to make particular buttons unavailable in certain circumstances.

Rather than setting their enabled property to false (and having them
disappear, which I think would confuse users), I would prefer to have
them there all the time but greyed out in those certain circumstances.

Can this be done? Or is greying out available only to Excels' built in
menus?

Suggestions appreciated

matthew

Bob,

Er, thanks for that. Guess I should have tried it, eh? (not for the
first time I feel a bit silly...)

Thanks, incidentally, for all your earlier contributions to the forum
on the subject of toolbars and the like - they've been a huge help
recently)


Cheers

Matthew