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

I would create the toolbar when the workbook opens and delete it when the
workbook closes.

Here's how I do it:
http://groups.google.co.uk/groups?th...5B41%40msn.com

If you want to add items to the worksheet menu bar, you can use John
Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm

mike_mike wrote:

Hi

I have a shared spreadsheet that is used by a number of users. I want to
update the spreadsheet and add a new button to the toolbar SO THAT THEY ALL
SEE IT.

My question is ..How do you get the other users to get the new modified
toolbar without going around to each users desktop and changing it.

I can update the spreadsheet - ie set it to unshared, temporarily to make
changes

mike (oz)


--

Dave Peterson