View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

#1. I think your life will be much smoother if you actually create the toolbar
when you open the workbook. (Then delete it when you close that workbook.)

I use a variation of John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm
to add items to the worksheet menubar.

If I want to add a toolbar of my own, here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

#2. Try this:

hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter:
application.commandbars("Cell").enabled = true
then back to excel to test.

If that didn't work, try this in the VBE immediate window:
application.commandbars("Cell").reset

Anthony wrote:

Hi,
two questions to ask??
1) I forgot to attach a personal toolbar back to my worksheet before closing
it , and now its has 'gone' - no sign of it in the cusomise toolbars section
- any ideas how to get this back??

2) My mouse seems to have lost the right click function within my excel
worksheet - any ideas how to get this back??

Thanks all

Anthony


--

Dave Peterson