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.