Gord

Many thanks for that. Saves me a lot of space on my monitor.

Again, cant thank you guys enough

Peter

--

http://www.contextures.on.ca/xlToolbar02.html


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 18:34:43 +0100, "Peter W Soady \(UK\)"
wrote:

Thanks

Correct, the majority of the buttons are used by the Auto Filter, however,
not all.

How would I create the toolbar. Although reasonably proficient with VBA I
am
a little lost with creating a toobar


"damorrison" wrote in message
groups.com...

Just to make sure are you talking about the auto filter arrow buttons
that are in the cells??

You may want to make a UserForm that will hold your buttons that would
be the best Idea, another way would be to creat your own toolbar that
would hold your macro buttons, oh another way would be to add the macro
event to the right click menu on the mouse