| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Password protection custom tool bar
Hi All
Is there a way to password protect my custom tool bars. I have a custom tool bar that I use with Excel. Other people-some are mean- that are using the same computer,are deleting my custom tool bar. can I prevent this in any way. Thanks Ian M -- Norton Professional 2004 says this email is clean...believe it |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password protection custom tool bar
find the xlb file on your computer. This is where customizations are
stored. copy this to a floppy or in another location on your computer. Then when you find you customizations disturbed, close excel, then copy this file back over the existing one. -- Regards, Tom Ogilvy "PCOR" wrote in message ... Hi All Is there a way to password protect my custom tool bars. I have a custom tool bar that I use with Excel. Other people-some are mean- that are using the same computer,are deleting my custom tool bar. can I prevent this in any way. Thanks Ian M -- Norton Professional 2004 says this email is clean...believe it |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password protection custom tool bar
"PCOR" wrote in message ... Hi All Is there a way to password protect my custom tool bars. I have a custom tool bar that I use with Excel. Other people-some are mean- that are using the same computer,are deleting my custom tool bar. can I prevent this in any way. Thanks Ian M -- Norton Professional 2004 says this email is clean...believe it Why dont you programtically create the custom tool bars each time the file is opened then if the "mean" choose to delete items ..well its their hard luck. Additionally why not require log in and run a tool bar check at closure of the file. If any are missing create code to keep a log ( with who logged in) and or get the code to send you an email idnetify the culprit...then sack them :) Best N10 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password protection custom tool bar
Good stuff..thankss
"Tom Ogilvy" wrote in message ... find the xlb file on your computer. This is where customizations are stored. copy this to a floppy or in another location on your computer. Then when you find you customizations disturbed, close excel, then copy this file back over the existing one. -- Regards, Tom Ogilvy "PCOR" wrote in message ... Hi All Is there a way to password protect my custom tool bars. I have a custom tool bar that I use with Excel. Other people-some are mean- that are using the same computer,are deleting my custom tool bar. can I prevent this in any way. Thanks Ian M -- Norton Professional 2004 says this email is clean...believe it |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Password protection custom tool bar
Thanks...I likethe second part much better...Thanks a gain
"N10" wrote in message ... "PCOR" wrote in message ... Hi All Is there a way to password protect my custom tool bars. I have a custom tool bar that I use with Excel. Other people-some are mean- that are using the same computer,are deleting my custom tool bar. can I prevent this in any way. Thanks Ian M -- Norton Professional 2004 says this email is clean...believe it Why dont you programtically create the custom tool bars each time the file is opened then if the "mean" choose to delete items ..well its their hard luck. Additionally why not require log in and run a tool bar check at closure of the file. If any are missing create code to keep a log ( with who logged in) and or get the code to send you an email idnetify the culprit...then sack them :) Best N10 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| Custom tool bar | Excel Discussion (Misc queries) | |||
| Adding custom list and text boxes to the custom tool bar from Excel C API | Excel Discussion (Misc queries) | |||
| question about excel protection tool | Excel Discussion (Misc queries) | |||
Linear Mode
