Disable hide for a column

M

Michael Singmin

Hello Group,

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

Thanks,

Michael Singmin
 
J

Jim Rech

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
| Hello Group,
|
| When selecting a column and Right clicking, how does one disable (grey
| out) the the Hide/Unhide commands ?
|
| Thanks,
|
| Michael Singmin
|
 
Top