hi,

i am getting an "invalid procedure call or argument". on the following:

Application.CommandBars("Worksheet
MenuBar").Controls("Format").Controls("&Column").C ontrols("&Unhide").Enabled
= True


thanks in advance,
geebee


"atpgroups" wrote:

On 27 May, 16:33, geebee (noSPAMs) wrote:
i want to
prevent this from happening.
what is the best way to handle this?

This may not be the _best_ way, but will work. Just turn off the menu
items.

Application.CommandBars("Worksheet Menu
Bar").Controls("Format").Controls("&Column").Contr ols("&Unhide").Enabled
= False
Application.CommandBars("Column").Controls("&Unhid e").Enabled = False

You might need to re-do the Column menu on the workbook_RightClick
event.