How to add a tool bar to a spreadsheet

H

hlopes

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;) ;)
 
M

Michael Loganov

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
 
T

Tom Ogilvy

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.
 
Top