I have some custom toolbars and a Personal.xlsb file that I would like to deploy on multiple PCs. To make sure my macros assigned to the custom toolbars work, I have them saved in a module in Personal.xlsb. I know that I can manually import/export the custom toolbar via File > Options > Customize Ribbon > Import/Export and that I can change the start up location for the Personal.xlsb file via File > Options > At Startup, open all files in.
What I would like to do is use a batch file to populate the start in location and to auto import custom ribbon changes. Does anyone know the process to do either of these tasks via batch file? I assume the start in location is stored somewhere in registry. I don't want to point the start in to a network location as some machines are stand alone at times.
What I would like to do is use a batch file to populate the start in location and to auto import custom ribbon changes. Does anyone know the process to do either of these tasks via batch file? I assume the start in location is stored somewhere in registry. I don't want to point the start in to a network location as some machines are stand alone at times.