The easiest way is to protect the worksheet (Tools, Protection, Protect
Sheet).

Otherwise you'd have to use code like this:

CommandBars("Column").Controls("Hide").Enabled = False

But you have to reset this (when your app closes, if not sooner) or the user
will be stuck with this.

--
Jim Rech
Excel MVP
"Michael Singmin" wrote in message
...
| Hello Group,
|
| When selecting a column and Right clicking, how does one disable (grey
| out) the the Hide/Unhide commands ?
|
| Thanks,
|
| Michael Singmin
|