Hello Group,

When selecting a column and Right clicking, how does one disable (grey
out) the the Hide/Unhide commands ?

Thanks,

Michael Singmin

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
|

Michael,

This was discussed a while back and you might mind this thread useful

http://www.excelforum.com/showthread...hreadid=195240

Regards

Seamu

--
Message posted from http://www.ExcelForum.com