I have a small excel add-in that I wrote with a Dynamic Menu. The idea is to create a 'permanent' set of favorites that people can set on their individual machines.
The available selections on the menu are ...
- Add spreadsheet to Favorites
- Manage Favorites
- or select one of many spreadsheets that have already been added as favorites, which will then open that spreadsheet.
When you Add a spreadsheet to favorites, it populates a worksheet in the addin with the Short Description of the spreadsheet and the full path and filename of the spreadsheet. The last thing it does is invalidates the dynamic menu control so that when the control is selected, it will be re-loaded, the new spreadsheet will appear in the list.
The good news is that this add-in works on my machine. The bad news is that it does not work on my co-worker's machine. I am getting a run-time error '91' .. 'Object variable or With block variable not set'. I have attached screenshots below.
Please let me know if you need more info.