| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock Commandbars
Hello,
Is it possible to lock a selfmade commandbar? So that the users of my workbook cannot delete them! Greetz. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lock Commandbars
Jean-pierre,
This may do the trick... Set SelfMade = Application.CommandBars.Add(... SelfMade.Protection = msoBarNoCustomize This doesn't hurt either... Application.CommandBars("Toolbar List").Enabled = False Regards, Jim Cone San Francisco, CA "Jean-pierre Hermans" wrote in message ... Hello, Is it possible to lock a selfmade commandbar? So that the users of my workbook cannot delete them! Greetz. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lock Commandbars
Jim Cone wrote:
Lock Commandbars Jim, Thank you for the good tips. Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel CommandBars | Excel Discussion (Misc queries) | |||
| Saving CommandBars | Excel Discussion (Misc queries) | |||
| Commandbars | Excel Programming | |||
| CommandBars | Excel Programming | |||
| CommandBars | Excel Programming | |||
Linear Mode
