asked on
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.
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.
Microsoft ExcelMicrosoft Office
Last Comment
Roy Cox
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
As stated the personal workbook is not a visible workbook, so the sheets in it are also not visible.