How to add a tool bar to a spreadsheet

  • Thread starter Thread starter hlopes
  • Start date Start date
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;) ;)
 
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
 
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.
 
Back
Top