lohithsriram
Active Member
Hi Friends,
I have an excel addin which creates custom toolbar/menu in Excel 2003 on load. The toolbar has 6 buttons in total, but hides/disables two or three buttons based on the user logged in. I validate the user logged in through company webservice and identify the user role. Based on the role, I display the appropriate buttons on the toolbar through VBA.
The challenge now is to replicate the same toolbar for Office 2010 with ribbon & buttons on it. I can customize the ribbon, hide/disable the buttons through Custom UI Editor at the design time. But how can I achieve this through VBA at run time?
Though I am a benefeciary of Chandoo for all these years but never posted anything before. I owe a lot to this forum and will promise to keep in touch hereafter. Thank you.
I have an excel addin which creates custom toolbar/menu in Excel 2003 on load. The toolbar has 6 buttons in total, but hides/disables two or three buttons based on the user logged in. I validate the user logged in through company webservice and identify the user role. Based on the role, I display the appropriate buttons on the toolbar through VBA.
The challenge now is to replicate the same toolbar for Office 2010 with ribbon & buttons on it. I can customize the ribbon, hide/disable the buttons through Custom UI Editor at the design time. But how can I achieve this through VBA at run time?
Though I am a benefeciary of Chandoo for all these years but never posted anything before. I owe a lot to this forum and will promise to keep in touch hereafter. Thank you.