Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect custom toolbar from being changed ?
as the subject suggests... :) is it possible and if so, how ?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect custom toolbar from being changed ?
Hi dmills Do you create the toolbar with code ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... as the subject suggests... :) is it possible and if so, how ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect custom toolbar from being changed ?
nope. created it using the customize function in the tools menu.
i need to restrict what the users can do in the spreadsheet, so i figured make a custom toolbar with just what they will need to do their work and then hide the menu bar to keep people away from the functions they dont need. easy enough, but he toolbar can still be edited and i cant figure out how to lock it down :( any help appreciated, and thanks in advance..... "Ron de Bruin" wrote: Hi dmills Do you create the toolbar with code ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... as the subject suggests... :) is it possible and if so, how ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect custom toolbar from being changed ?
Sorry I always do it with code
You can run this Application.CommandBars.DisableCustomize = True See also http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... nope. created it using the customize function in the tools menu. i need to restrict what the users can do in the spreadsheet, so i figured make a custom toolbar with just what they will need to do their work and then hide the menu bar to keep people away from the functions they dont need. easy enough, but he toolbar can still be edited and i cant figure out how to lock it down :( any help appreciated, and thanks in advance..... "Ron de Bruin" wrote: Hi dmills Do you create the toolbar with code ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... as the subject suggests... :) is it possible and if so, how ? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
protect custom toolbar from being changed ?
Outstanding....thats exactly what I was looking for :)
thanks bunches "Ron de Bruin" wrote: Sorry I always do it with code You can run this Application.CommandBars.DisableCustomize = True See also http://www.rondebruin.nl/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... nope. created it using the customize function in the tools menu. i need to restrict what the users can do in the spreadsheet, so i figured make a custom toolbar with just what they will need to do their work and then hide the menu bar to keep people away from the functions they dont need. easy enough, but he toolbar can still be edited and i cant figure out how to lock it down :( any help appreciated, and thanks in advance..... "Ron de Bruin" wrote: Hi dmills Do you create the toolbar with code ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "dmills" wrote in message ... as the subject suggests... :) is it possible and if so, how ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom Toolbar | Excel Discussion (Misc queries) | |||
custom date format changed in mail merge | Excel Discussion (Misc queries) | |||
How do I lock/protect cells so they can't be changed | Excel Worksheet Functions | |||
custom worksheet functon is changed to lowercase | Excel Worksheet Functions | |||
How do I protect a formula from "accidently" being changed in Exc. | Excel Worksheet Functions |