Keyboard shortcuts-Because of the way keyboard shortcuts are associated with macros, any keyboard shortcuts associated with copied and pasted macros may no longer work.

A simple change like adding a prefix or suffix to the new macro names (i.e. If an old macro and a new macro share a name, both macros become non-functional since Excel can't tell which macro to run. Macros with the same names-If you are copying and pasting the code from one PERSONAL.XLSB to another, the macros being moved need to have names that are unique.This way the old macros are preserved while adding the functionality of the new macros. Overwriting an already existing PERSONAL.XLSB-Does the machine you are moving PERSONAL.XLSB to already have and use PERSONAL.XLSB? If so, it would be best to open the machine's current PERSONAL.XLSB and the one you are moving and copy the macro code from the new workbook to the old workbook.If they are intended to be permanent additions, PERSONAL.XLSB should be moved into the XLSTART directory on the new machine. Temporary Use-Are the macros in PERSONAL.XLSB intended to be permanent additions to the new environment? If the macros are intended to only be used for a short period of time, it is easier to just open the workbook you're moving and run macros from there. The following list explains some things to consider when moving PERSONAL.XLSB and how to work around them: The main reasons we would want to transport our PERSONAL.XLSB to another machine are if we were to purchase a new machine and wish to use our Personal Macro Workbook on the new machine and if we use one machine at work and another machine at home and would like all of our macros to be in both places. There are a few things that should be considered when transporting your copy of PERSONAL.XLSB from one machine to another. We will be taking a look at where PERSONAL.XLSB is stored, and we will save it to the Desktop so we can move it elsewhere from there. The reasons behind moving PERSONAL.XLSB are simple: we've made macros that make our work easier and it would be nice to be able to transport those macros either to a new machine or to a machine at home or at the office so we can always use our macros. This is a relatively simple task since PERSONAL.XLSB is just a workbook stored in binary format. Now that we've added some useful functionality to PERSONAL.XLSB, it would be nice to be able to back it up and move it from machine to machine.

Personal macro workbook excel 2016