Disable hide for a column
Hello Group,
When selecting a column and Right clicking, how does one disable (grey out) the the Hide/Unhide commands ? Thanks, Michael Singmin |
Disable hide for a column
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 | |
Disable hide for a column
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 |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com