Unable to load the personal macro book with excel sheet when i restart the system

Hello,
I have created certain macros which has to be used repetitively. So, I created personal macro book and stored the macros in it. And again I created the buttons so that using one click the macros will get executed. All the setting works fine. But when I restart the system the personal macro book doesn't load with excel and the buttons which has been created the other day cant be seen. I am able to open the personal macro book manually. But, is there any way to prevent the above problem? Please help me out.
aditeeAsked:
Who is Participating?
 
Roy CoxGroup Finance ManagerCommented:
The PERSONAL macro book should be a hidden workbook. That is how it is designed so you cannot have any visible sheets in it. It will not appear in the list of open workbooks.

Check if the macros are available from the Macro button in the Developer Tab of the Ribbon.

Read this to see if it has become disabled
0
 
Roy CoxGroup Finance ManagerCommented:
As stated the personal workbook is not a visible workbook, so the sheets in it are also not visible.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.