Unwanted workbooks on startup


K

kenrock

Hi,
When I have been using Excel for Mac 2011, I have stored my macros in the Personal Macro Workbook which appears when I open Excel. I must have done something unusual during one session for now, when I open Excel, not only Personal Macro Workbook appears but also Personal Macro Workbook1 together with two workbooks I had stored on the Desktop. I want to get rid of these unwanted workbooks but I cannot locate them. I can see the Personal Macro Workbook in the Documents/MicrosoftUserData/Excel folder but I can't find the others.
I tried changing the name of one of the two unwanted workbooks in the Desktop but a new workbook with the original name appears.
Can anyone please help me either locate these workbooks or tell me where the startup list is stored?
Regards, kenrock
 
Ad

Advertisements

W

witek

kenrock said:
Hi,
When I have been using Excel for Mac 2011, I have stored my macros in the Personal Macro Workbook which appears when I open Excel. I must have done something unusual during one session for now, when I open Excel, not only Personal Macro Workbook appears but also Personal Macro Workbook1 together with two workbooks I had stored on the Desktop. I want to get rid of these unwanted workbooks but I cannot locate them. I can see the Personal Macro Workbook in the Documents/MicrosoftUserData/Excel folder but I can't find the others.
I tried changing the name of one of the two unwanted workbooks in the Desktop but a new workbook with the original name appears.
Can anyone please help me either locate these workbooks or tell me where the startup list is stored?
Regards, kenrock

Open visual basic
highligh unwanted workbook in project explorer (Ctrl-R) and in immediate
(Ctrl-G) window type

? Thisworkbook.path

to see where it is located.
 
Ad

Advertisements

K

kenrock

Hi,

When I have been using Excel for Mac 2011, I have stored my macros in thePersonal Macro Workbook which appears when I open Excel. I must have done something unusual during one session for now, when I open Excel, not only Personal Macro Workbook appears but also Personal Macro Workbook1 together with two workbooks I had stored on the Desktop. I want to get rid of these unwanted workbooks but I cannot locate them. I can see the Personal Macro Workbook in the Documents/MicrosoftUserData/Excel folder but I can't find theothers.

I tried changing the name of one of the two unwanted workbooks in the Desktop but a new workbook with the original name appears.

Can anyone please help me either locate these workbooks or tell me where the startup list is stored?

Regards, kenrock

Excellent! Another triumph for learning and literacy! I now am aware of Library:Application Support:Microsoft:Office:Excel. Thanks very much for your input. Regards, kenrock
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top