PC Review


Reply
Thread Tools Rate Thread

Deleted Custom Toolbar keeps returning.

 
 
Paul Martin
Guest
Posts: n/a
 
      15th Jul 2008
Hi guys

I am having a problem with a deleted custom toolbar that keeps
returning when I start up Excel (2003).

* I have a custom toolbar with various developer productivity tools
that I have developed.
* The code that is executed by the buttons is in PERSONAL.XLS.
* I am working for a company and would like to deploy a custom toolbar
similar to my own one.
* I have copied PERSONAL.XLS as BSJIU.XLS and removed PERSONAL.XLS
from the XLSTART folder (with BSJIU.XLS remaining in its place).
* I have assigned the macros behind each button to the new file.
* In Tools, Customise, Toolbars, I have deleted the original custom
toolbar (I have given the two versions different names).

Yet at start up of Excel, the old custom toolbar keeps returning. Any
suggestions of how to remedy this are appreciated.

Thanks in advance

Paul Martin
Melbourne, Australia
 
Reply With Quote
 
 
 
 
Paul Martin
Guest
Posts: n/a
 
      15th Jul 2008
I should also add that I'm looking for an Excel interface solution,
not a VBA solution (though I suppose a VBA solution is OK if it fixes
the problem permanently).

Paul
 
Reply With Quote
 
Peter T
Guest
Posts: n/a
 
      15th Jul 2008
Here are three possible reasons why your bar keeps returning

- The bar is re-created programmatically in the load event of some workbook
or addin.

- You had another Excel instance open when you deleted the bar in the first.
If the second instance is closed after the first, the toolbar folder will be
resaved and include your toolbar (which was not deleted in that instance)

- The toolbar is "Attached" to some workbook or addin. It will re-appear
when the file it is attached to re-opens

The solution to permanently remove the toolbar will of course depend on why
it returns.

Regards,
Peter T

"Paul Martin" <(E-Mail Removed)> wrote in message
news:fada85c9-e695-4684-aded-(E-Mail Removed)...
> I should also add that I'm looking for an Excel interface solution,
> not a VBA solution (though I suppose a VBA solution is OK if it fixes
> the problem permanently).
>
> Paul



 
Reply With Quote
 
Paul Martin
Guest
Posts: n/a
 
      15th Jul 2008
Thanks, Peter. It was attached. It's working fine now.

Regards

Paul
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleted text character returning numbers when deleted. Trreborr09 Microsoft Excel New Users 3 11th Apr 2010 03:17 AM
Adding custom buttons to the Standard toolbar versus a custom toolbar cainrandom@gmail.com Microsoft Outlook Program Addins 2 9th Oct 2008 05:13 PM
Custom toolbar - buttons being deleted =?Utf-8?B?TUtH?= Microsoft Word Document Management 2 20th Mar 2006 03:38 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Microsoft Excel Programming 2 3rd Mar 2004 03:31 PM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Microsoft Excel Discussion 2 3rd Mar 2004 12:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:19 PM.