I want to add a tool bar to a spreadsheet, the tool bar contains
3 buttons linked to macros. The objective is so that when I open
the spreadsheet it also show the small tool bar on the sheet.

Thanks in advance for your help.
Helder Lopes, Portugal;) ;)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

This article should be a good starting point:

XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items", at
http://support.microsoft.com/default...b;en-us;166755
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com


"hlopes" wrote in message
...
I want to add a tool bar to a spreadsheet, the tool bar contains
3 buttons linked to macros. The objective is so that when I open
the spreadsheet it also show the small tool bar on the sheet.

Thanks in advance for your help.
Helder Lopes, Portugal;) ;)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi,

I think the easiest way to achieve this is to create a userform in the
spreadsheet and put the command buttons linked to macros on it. You will
then need to put somethingt like this in the workbook code:

Public Sub Workbook_Open()
frmMyForm.Show

End Sub

Public Sub Workbook_BeforeClose(cancel As Boolean)
frmMyForm.Hide

End Sub

where frmMyForm is the name of your form

Regards,
Mike


"hlopes" wrote in message
...
I want to add a tool bar to a spreadsheet, the tool bar contains
3 buttons linked to macros. The objective is so that when I open
the spreadsheet it also show the small tool bar on the sheet.

Thanks in advance for your help.
Helder Lopes, Portugal;) ;)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

you can attach the toolbar to the workbook and include code in the Activate
event to make it Visible and Deactivate to make it not visible.

--
Regards,
Tom Ogilvy

hlopes wrote in message
...
I want to add a tool bar to a spreadsheet, the tool bar contains
3 buttons linked to macros. The objective is so that when I open
the spreadsheet it also show the small tool bar on the sheet.

Thanks in advance for your help.
Helder Lopes, Portugal;) ;)



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/