PDA

View Full Version : VBA function for representing click on ribbon icon (command bar) icon



petroj02
08-11-2016, 05:42 AM
Hello guys,
after opening workbook, I have code, and this code does some Kind of Actions, like hidding command bars, scrollbars ect... Also I have command button on worksheet, after click on this button for "admin" I have to type username and Password, for showing command bars, scrollbars ect again... So far so good, and it works fine.
But there is my Problem, unfortunatelly there is one command bar at ribbon, needed for ordinary user. I want to let this command bar also hiden, and represent this icon function by click on second comand button located on worksheet.
Is here any function, which can represent click on my own ribbon icon?

My ribbon Icon is in Folder CGC, Group CGC and Name of this Icon is Start.

I know this text could be Little confused so I attached Screen of this description, Unfortunatelly I cant sent, you workbook for better reproducing of Problem.

Any help would be welcome... Thank you for response

Paul_Hossler
08-11-2016, 06:33 AM
The workbook with the custom UI XML would be helpful if you post it

But off the top on my head, the getVisible callback would be the way to go