#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