View Single Post
  #4   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Unable to use right-click on cells; standard and formatting toolbars disabled

Hi Trizi


I take it I can delete the old renamed xlb files now ...


Yes




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Trizi" wrote in message oups.com...
On Jun 21, 9:37 am, "Ron de Bruin" wrote:
Hi Trizi

I suggest you do this first and post back

Maybe you have a corrupt or bloated xlb file *normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

1. Close Excel
2. Do a search for .xlb in Windows (Use: search hidden files and folders)
3. Rename or delete the .xlb file or files (In 2002 the name = Excel10.xlb)
4. Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you.
(You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



Awesome! Awesome! Awesome!

It worked and it just took minutes ! I take it
I can delete the old renamed xlb files now ...