Disable hide for a column

  • Thread starter Thread starter Michael Singmin
  • Start date Start date
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
 
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
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide / Unhide each row from StartRow to LastRow for multiple conditions 6
How to Disable/Enable hide entire row ability 17
Hide a form button 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Identify selected chart 3
What is the purpose of a Macro Sheet ? 1
Hide / Unhide Columns in Password Protected w/s 2
Macro for Hiding one column at a time in a range 2

Back
Top