protect custom toolbar from being changed ?
 

as the subject suggests... :) is it possible and if so, how ?

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 ?

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 ?

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 ?

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 ?