Ribbons: Make Unique to Data Sheet

[SteveOranjin]

Hello,

I've been working with a series of Macros for a little while now. I've been setting up little buttons on a page so they are accessible to a user. It occurred to me how much easier it would be to just create a macro and add it to a ribbon.

And it's pretty amazing to have. There is one thing I don't like though, the ribbon carries with you between sheets. Is there a way for me to set up a ribbon so it is JUST on the one worksheet, so it doesn't carry over?

Hope you are well,

Steve

 

[mole999]

If you add a worksheet_activate and deactivate routine I would expect that to work, not sure of the code to place there though

 

[SteveOranjin]

I seem to have not been paying as close attention as I could when I asked this question yesterday.

My question (that I meant to ask) was is how can I ensure that the ribbon I have set up is so that it remains with the sheet when I send it to someone else?

I've looked but I can't find anything.