DeanP
01-11-2019, 05:09 AM
I am a bit confused about the personal workbook and what it's supposed to do? So I saved a few macros in the personal workbook, but if I want them to work in other workbooks I have to copy those macros into that workbook? What was the point of saving them in the personal workbook?
I have a workbook into which I have copied macros from my personal workbook. However, this other workbook will be used
every month, and saved with a new name (eg. Jan Sales - Feb Sales). My problem is that when the file is 'rolled forward'
any macro that is executed also open the Jan file. I was under the impression that having those macros in the personal
would prevent this?
Most of the resources that I have seen online describes how to create the personal workbook as opposed to how to use it.
Any clarification would be appreciated.
I have a workbook into which I have copied macros from my personal workbook. However, this other workbook will be used
every month, and saved with a new name (eg. Jan Sales - Feb Sales). My problem is that when the file is 'rolled forward'
any macro that is executed also open the Jan file. I was under the impression that having those macros in the personal
would prevent this?
Most of the resources that I have seen online describes how to create the personal workbook as opposed to how to use it.
Any clarification would be appreciated.