Create it when the workbook is opened. Delete it when the workbook is
closed.

--
Regards,
Tom Ogilvy


"NathanG" wrote in message
...
Hi,

As part of a system a new tool bar was created in excel to allow the user
to
use the system. The process which takes place is that a user creates a new
spreadsheet from access based on the criteria selected. The tool bar
appears
automatically. The problem is that when a new workbook is opened totally
unrelated to the system the tool bar still appears. I have played around
with
VBA code a little to see if I could add a line that only adds the tool bar
for the active spreadsheet for not excel as a whole.

I have used onopen and onclose (or macros to that effect) before that
remove
toolbars and when the user closes the spreadsheet all the tool bars etc
are
added back in as normal. I don't recall the macros being shared with all
excel spreadsheets subsequently opened.

How can I ensure the custom tool bar only appears on the spreadsheets I
want
it to?

Many thanks

Nathan