【Excel VBA】Personal Macro Workbook
为什么要存入Personal Macro Workbook?
Because this workbook always open at the background whenever you open excel files.
这样不管在哪个文件里,都可以使用写好的宏啦
-
先录制一个宏,目的是调取出Personal Macro Workbook
-
找到Personal.xlsb下的Module,把VBA复制过来
-
Include the Macro in the ribbon