Does a workflow exist that permanently adds a macro to a user’s Personal Macro Workbook (PERSONAL.XLSB)?
I am not talking about having a bot run a macro located somewhere else. I would like the workflow to alter the user’s current PERSONAL.XLSB file, adding the macro and assigning a shortcut, so that the user only has to run the bot one time to “install” a VBA macro.
This would be extremely helpful in a corporate setting where some people may not be great with VBA navigation. Simply run the bot, and the new Macro is added to the personal repository, with new hotkeys assigned with
This would be great to add a suite of common functions to a user’s personal Excel instances (disable F1 key, Center Across Selection hotkey, Scroll-to-A1 hotkey, etc.).