custom ribbon for worksheet in a workbook

[still learning]

Hi
I made custom ribbon for a workbook.
The workbook has 6 worksheets in it.
Is there a way to have each worksheet with it's own custom ribbon?
I sometimes forget which icon is for which sheet !!!!!


mike

 

[Yongle]

what is so special that each sheet requires its own ribbon?
I would think that Worksheet_Deactivate event can be used to set ribbon back to normal and Worksheet_Activate event used to set the ribbon as you require for that worksheet .
Both need to be placed in the worksheet's module

 

[still learning]

Hi Yongle,
As an example:

Sheet one has a custom button on the ribbon that sorts the data based on column A and changes the fill fonts in every other row.

Sheet two has a different button that sorts the data based on column B and does not change the fill font.

both buttons look different. Sometimes i click the wrong button. If the button only worked on that sheet, it would be easier.

The work book has 12 sheets that I use.
I will look at using Worksheet_Deactivate and Worksheet_Activate to see if i can put it in a macro for each sheet.

Thank you for your response

mike

 

[Yongle]

If the button only worked on that sheet, it would be easier.

You could consider disabling the button for some sheets

example - run code only if the active sheet is named Sheet1, Sheet2 or Sheet4

Select Case ActiveSheet.Name
    Case "Sheet1", "Sheet2", "Sheet4"
         [I]your code goes here[/I]
    Case Else
        MsgBox "not on this sheet!"
End Select

It is not necessary to use Case Else (every sheet except the 3 listed is ignored)