Forum Discussion

Mark_Tyler's avatar
Mark_Tyler
Copper Contributor
Nov 03, 2019
Solved

Duplicate Personal.xlsb workbooks

Hello there I have just bought a new computer on which Office 2019 is installed. To get the same macro functions I previously had, I copied my Personal.xlsb file to the correct XLSTART folder. Whe...
excel
Macros and VBA
  • Mark_Tyler's avatar
    Mark_Tyler
    Nov 04, 2019

    A mate has just helped me to fix the above issue.
    The icons to my macros on my Quick Access Toolbar were somehow no longer linked to the Personal.xlsb workbook copied to my new computer.

    However, the macros in the copied Personal file were accessible from my new Excel programme (Office 2019).
    Therefore, we simply deleted the old macro icons and linked each of my macros to new icons on my Quick Access Toolbar.

    Done.  Fixed!

     

     

Mark_Tyler's avatar
Mark_Tyler
Copper Contributor
Nov 04, 2019

A mate has just helped me to fix the above issue.
The icons to my macros on my Quick Access Toolbar were somehow no longer linked to the Personal.xlsb workbook copied to my new computer.

However, the macros in the copied Personal file were accessible from my new Excel programme (Office 2019).
Therefore, we simply deleted the old macro icons and linked each of my macros to new icons on my Quick Access Toolbar.

Done.  Fixed!

 

 

Abiola1's avatar
Abiola1
MVP
Nov 04, 2019
Good to hear

Regards

Resources