Forum Discussion
Go_Joe
Aug 05, 2022Copper Contributor
Adding a Forms button based on the Forms Command result from ribbon
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?
- JKPieterseSilver ContributorYou 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
- Go_JoeCopper Contributor
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.