Smurfit-Stone
Active Member
- Joined
- Dec 1, 2004
- Messages
- 485
Hello Board,
I have a spreadsheet that is shared between my company and different vendors. I want to attach a macro to it that does come calulations and clears some cells. My problem is that I want the macro assigned to an icon on the users (my companies users only) toolbar. What I have now is on the toolbar, but its on a separate spreadsheet that opens with Excel XLSTART, the problem is that this spreadsheet opens every time Excel is opened. Is there a way to put the icon the macro is assigned to on the toolbar with this separate workbook, or is there a way to get the macro to run as a Private Sub for the active workbook. The macro is listed below.
Private Sub SheetsVisible()
Dim wks As Worksheet
Sheets("Order").Activate
For Each wks In ActiveWorkbook.Worksheets
wks.Visible = True
Next wks
End Sub
I have a spreadsheet that is shared between my company and different vendors. I want to attach a macro to it that does come calulations and clears some cells. My problem is that I want the macro assigned to an icon on the users (my companies users only) toolbar. What I have now is on the toolbar, but its on a separate spreadsheet that opens with Excel XLSTART, the problem is that this spreadsheet opens every time Excel is opened. Is there a way to put the icon the macro is assigned to on the toolbar with this separate workbook, or is there a way to get the macro to run as a Private Sub for the active workbook. The macro is listed below.
Private Sub SheetsVisible()
Dim wks As Worksheet
Sheets("Order").Activate
For Each wks In ActiveWorkbook.Worksheets
wks.Visible = True
Next wks
End Sub