Adding a Forms button based on the Forms Command result from ribbon

Copper Contributor

I have a large table that I would like users to use via a form. The form that I tested was created by using the FORM button in the ribbon is exactly what I want. Is there a way to create a FORM Button and reference this form without creating a new macro?

2 Replies
You could add a ribbon customization to the workbook in question which adds that button to a tab of your own? Not simple for the beginner, but not too difficult either. See: https://www.rondebruin.nl/win/s2/win001.htm

@Jan Karel Pieterse 

 

Thanks Jan .. .I will try it. I have the FORMS in my custom ribbon already but I have staff who are not that Excel savvy. I will give this a try and see how beneficial it is for them.