Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Deleted Custom Toolbar keeps returning.

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Deleted Custom Toolbar keeps returning.

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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Deleted Custom Toolbar keeps returning.

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" wrote in message
...
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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Deleted Custom Toolbar keeps returning.

Thanks, Peter. It was attached. It's working fine now.

Regards

Paul
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleted text character returning numbers when deleted. Trreborr09 New Users to Excel 3 April 11th 10 03:17 AM
Resorting Deleted Menu/Toolbar Fester Bestertester Excel Discussion (Misc queries) 1 August 2nd 07 07:38 PM
Formulas returning errors when reference columns are deleted Ian M[_2_] Excel Programming 1 May 3rd 04 07:51 AM
custom toolbar buttons are saved where? Excel loads twice bymistake and all my custom toolbar buttons get gone!!! Kevin Waite Excel Programming 2 March 3rd 04 03:31 PM
saving toolbar buttons on custom toolbar Paul James Excel Programming 12 August 6th 03 08:28 AM


All times are GMT +1. The time now is 01:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"