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

aditee
aditee used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Group Finance Manager
Commented:
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
Roy CoxGroup Finance Manager

Commented:
As stated the personal workbook is not a visible workbook, so the sheets in it are also not visible.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial