Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How do I permanently delete a custom toolbar in Excel?

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I permanently delete a custom toolbar in Excel?

What version of Excel are you running?

Personal.xls has not been used to create custom toolbars/menus since the
introduction of Excel 97.

Although you may have code in Personal.xls that builds the Toolbar when you open
Excel.

If that's not the case then read on.

Toolbar Customizations are now stored in your Excelxx.xlb file.

Try ToolsCustomizeToolbars.

Select the one you don't want and delete it.

From another post on this subject....................

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them. This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


On Thu, 26 Jul 2007 12:50:03 -0700, Argee
wrote:

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How do I permanently delete a custom toolbar in Excel?

Thanks for your response Gord.

I am running Excel 2003.

My problem started when I upgraded to Vista and had to copy my macros and
custom toolbars over to work in the new OS. The macros couldn't find the
files I was referring to as they were now in a different path. I ended up
having to rewrite the macros to get them working again.

From your repsonse, I tried deleting the Excel11.xlb file and opened the
Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid
Personal.xls and saved it. Reopened Excel and the toolbar is still there.

Glenn

"Gord Dibben" wrote:

What version of Excel are you running?

Personal.xls has not been used to create custom toolbars/menus since the
introduction of Excel 97.

Although you may have code in Personal.xls that builds the Toolbar when you open
Excel.

If that's not the case then read on.

Toolbar Customizations are now stored in your Excelxx.xlb file.

Try ToolsCustomizeToolbars.

Select the one you don't want and delete it.

From another post on this subject....................

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them. This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


On Thu, 26 Jul 2007 12:50:03 -0700, Argee
wrote:

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I permanently delete a custom toolbar in Excel?

With Excel closed.

Move Personal.xls out of your XLSTART folder temporarily.

Delete the *.xlb file.

Re-start Excel.

If no Toolbar, work back from there to see how the Toolbar is being created.

Is it possible that Personal.xls contains code that builds the Toolbar or
perhaps the Toolbar is attached to Personal.xls?

Unhide Personal.xls and ToolsCustomizeToolbarsAttach.

Unattach if one is in the attached section.

Save Personal.xls


Gord

On Fri, 27 Jul 2007 09:00:01 -0700, Argee
wrote:

Thanks for your response Gord.

I am running Excel 2003.

My problem started when I upgraded to Vista and had to copy my macros and
custom toolbars over to work in the new OS. The macros couldn't find the
files I was referring to as they were now in a different path. I ended up
having to rewrite the macros to get them working again.

From your repsonse, I tried deleting the Excel11.xlb file and opened the
Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid
Personal.xls and saved it. Reopened Excel and the toolbar is still there.

Glenn

"Gord Dibben" wrote:

What version of Excel are you running?

Personal.xls has not been used to create custom toolbars/menus since the
introduction of Excel 97.

Although you may have code in Personal.xls that builds the Toolbar when you open
Excel.

If that's not the case then read on.

Toolbar Customizations are now stored in your Excelxx.xlb file.

Try ToolsCustomizeToolbars.

Select the one you don't want and delete it.

From another post on this subject....................

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them. This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


On Thu, 26 Jul 2007 12:50:03 -0700, Argee
wrote:

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.




  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default How do I permanently delete a custom toolbar in Excel?

Thanks Gord.

I moved Personal.xls to the desktop and deleted the .xlb file. Excel starts
with no custom toolbars or macros (i.e. virgin state). A new .xlb file is
created upon exiting Excel. Re-opening Excel give the same virgin state.

Opening Personal.xls from desktop opens Excel with no worksheet showing
(personal is a hidden file) but the Custom toolbar is there. My second
(desired) toolbar is not there but the macros related to it are.

I found the toolbar attached to the worksheet and deleted the attachment as
you suggested. I then deleted the toolbar again from the Customize dialog
(list of toolbars) and it appears to be working properly now.

Thanks very much for your help!

"Gord Dibben" wrote:

With Excel closed.

Move Personal.xls out of your XLSTART folder temporarily.

Delete the *.xlb file.

Re-start Excel.

If no Toolbar, work back from there to see how the Toolbar is being created.

Is it possible that Personal.xls contains code that builds the Toolbar or
perhaps the Toolbar is attached to Personal.xls?

Unhide Personal.xls and ToolsCustomizeToolbarsAttach.

Unattach if one is in the attached section.

Save Personal.xls


Gord

On Fri, 27 Jul 2007 09:00:01 -0700, Argee
wrote:

Thanks for your response Gord.

I am running Excel 2003.

My problem started when I upgraded to Vista and had to copy my macros and
custom toolbars over to work in the new OS. The macros couldn't find the
files I was referring to as they were now in a different path. I ended up
having to rewrite the macros to get them working again.

From your repsonse, I tried deleting the Excel11.xlb file and opened the
Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid
Personal.xls and saved it. Reopened Excel and the toolbar is still there.

Glenn

"Gord Dibben" wrote:

What version of Excel are you running?

Personal.xls has not been used to create custom toolbars/menus since the
introduction of Excel 97.

Although you may have code in Personal.xls that builds the Toolbar when you open
Excel.

If that's not the case then read on.

Toolbar Customizations are now stored in your Excelxx.xlb file.

Try ToolsCustomizeToolbars.

Select the one you don't want and delete it.

From another post on this subject....................

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them. This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


On Thu, 26 Jul 2007 12:50:03 -0700, Argee
wrote:

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I permanently delete a custom toolbar in Excel?

Long way around but glad you're sorted


Gord

On Fri, 27 Jul 2007 13:02:01 -0700, Argee
wrote:

Thanks Gord.

I moved Personal.xls to the desktop and deleted the .xlb file. Excel starts
with no custom toolbars or macros (i.e. virgin state). A new .xlb file is
created upon exiting Excel. Re-opening Excel give the same virgin state.

Opening Personal.xls from desktop opens Excel with no worksheet showing
(personal is a hidden file) but the Custom toolbar is there. My second
(desired) toolbar is not there but the macros related to it are.

I found the toolbar attached to the worksheet and deleted the attachment as
you suggested. I then deleted the toolbar again from the Customize dialog
(list of toolbars) and it appears to be working properly now.

Thanks very much for your help!

"Gord Dibben" wrote:

With Excel closed.

Move Personal.xls out of your XLSTART folder temporarily.

Delete the *.xlb file.

Re-start Excel.

If no Toolbar, work back from there to see how the Toolbar is being created.

Is it possible that Personal.xls contains code that builds the Toolbar or
perhaps the Toolbar is attached to Personal.xls?

Unhide Personal.xls and ToolsCustomizeToolbarsAttach.

Unattach if one is in the attached section.

Save Personal.xls


Gord

On Fri, 27 Jul 2007 09:00:01 -0700, Argee
wrote:

Thanks for your response Gord.

I am running Excel 2003.

My problem started when I upgraded to Vista and had to copy my macros and
custom toolbars over to work in the new OS. The macros couldn't find the
files I was referring to as they were now in a different path. I ended up
having to rewrite the macros to get them working again.

From your repsonse, I tried deleting the Excel11.xlb file and opened the
Personal.xls file, deleted the toolbar (ToolsCustomizeToolbars), hid
Personal.xls and saved it. Reopened Excel and the toolbar is still there.

Glenn

"Gord Dibben" wrote:

What version of Excel are you running?

Personal.xls has not been used to create custom toolbars/menus since the
introduction of Excel 97.

Although you may have code in Personal.xls that builds the Toolbar when you open
Excel.

If that's not the case then read on.

Toolbar Customizations are now stored in your Excelxx.xlb file.

Try ToolsCustomizeToolbars.

Select the one you don't want and delete it.

From another post on this subject....................

If the workbook in question was constructed using XL95 which had the "Menu
Editor" feature the Menu Items will continue to reappear even though there are
no Macros associated with them. This feature(Menu Editor)was dumped with XL97
and up.
Jim Rech has written RemoveMenu.XLA which gets rid of these. Can be found on
Stephen Bullen's site.

http://www.oaltd.co.uk/MVP/Default.htm


Gord Dibben MS Excel MVP


On Thu, 26 Jul 2007 12:50:03 -0700, Argee
wrote:

I keep deleting the custom toolbar, even after unhiding the personal.xls
worksheet and saving changes, but it keeps coming back when I re-open Excel.





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
how do you permanently change toolbar from default setting in exce bv Excel Discussion (Misc queries) 0 August 23rd 06 01:37 PM
How can we delete rows permanently from excel sheet Nehal Shah Excel Discussion (Misc queries) 1 August 1st 05 01:58 PM
How to permanently customize a toolbar?? Sam Excel Discussion (Misc queries) 1 June 6th 05 12:34 PM
how do I add sum function to the toolbar permanently speedy2 Excel Discussion (Misc queries) 1 May 21st 05 03:53 AM
I would like to delete a custom toolbar from the workspace. How? twiga Setting up and Configuration of Excel 1 December 23rd 04 06:55 PM


All times are GMT +1. The time now is 07:39 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"