jakeman
Active Member
- Joined
- Apr 29, 2008
- Messages
- 325
- Office Version
- 365
- Platform
- Windows
Hello fellow Excel users -
here is my problem. I am trying to store my macros to the Personal.xlsx file so that I can use them whenever I want, regardless of the workbook I'm using. I had to create the Personal.xlsx workbook since there wasn't one stored to my computer already, and I stored it to the following path:
C:\Program Files\Microsoft Office\Office12\XLSTART\Personal.xlsx
Now, I hid the Personal.xlsx worksheet so that it would operate in the background and wouldn't appear whenever I opened Excel. However, when I open Excel now, the grid area is blank and no worksheet opens automatically. I have to manually create a new worksheet each time I open Excel which is annoying.
I've never had any problems with hiding the Personal.xls worksheet in Excel 2003 and opening Excel afterward.
Also, one forum I visited suggested running the excel.exe /unregserver in the Start menu and then running excel.exe /regserver and I tried that but it didn't solve the problem.
Any suggestions?
here is my problem. I am trying to store my macros to the Personal.xlsx file so that I can use them whenever I want, regardless of the workbook I'm using. I had to create the Personal.xlsx workbook since there wasn't one stored to my computer already, and I stored it to the following path:
C:\Program Files\Microsoft Office\Office12\XLSTART\Personal.xlsx
Now, I hid the Personal.xlsx worksheet so that it would operate in the background and wouldn't appear whenever I opened Excel. However, when I open Excel now, the grid area is blank and no worksheet opens automatically. I have to manually create a new worksheet each time I open Excel which is annoying.
I've never had any problems with hiding the Personal.xls worksheet in Excel 2003 and opening Excel afterward.
Also, one forum I visited suggested running the excel.exe /unregserver in the Start menu and then running excel.exe /regserver and I tried that but it didn't solve the problem.
Any suggestions?