Call Excel subroutine from within a spreadsheet
Posted on 2011-09-04
I've written a subroutine that performs some data manipulation on two spreadsheets within a workbook. I can run this subroutine from the VBA window or from the developers tab in the ribbon, but the individual who is going to be using this spreadsheet does not have the developers tab displayed.
I'm not an Excel guy, so I need a recommendation on possible techniques for providing the user with a fool proof method of kicking off the subroutine, either from the ribbon or a control on one of the spreadsheets, or ???.