+ Reply to Thread
Results 1 to 2 of 2

Unwanted workbooks on startup

  1. #1
    Registered User
    Join Date
    05-30-2009
    Location
    Newport, UK
    MS-Off Ver
    Excel 2003
    Posts
    1

    Unwanted workbooks on startup

    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

  2. #2
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Unwanted workbooks on startup

    I have a similar problem using Excel 2003 (which actually happened again ten minutes ago). I have Macros assigned to Shapes on my worksheet. Occasionally when I create a copy of the Workbook file, the Macros reference the 'Old File Name'. When this happens, the 'Old Workbook' gets opened (to run the Macro in the old file) when I 'click' on one of the buttons in the copy of the original file.

    I fix this by reassigning the Macros for each button to reference the New file.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. open multiple workbooks at startup
    By Ron Z in forum Excel General
    Replies: 3
    Last Post: 04-26-2013, 01:26 PM
  2. Unwanted "Personal" workbook at startup
    By Joe Miller in forum Excel General
    Replies: 5
    Last Post: 06-13-2010, 07:27 AM
  3. Unwanted Multiple workbooks opening
    By JA12 in forum Excel General
    Replies: 2
    Last Post: 08-17-2007, 09:06 AM
  4. opening workbooks on startup
    By Julian Campbell in forum Excel General
    Replies: 2
    Last Post: 08-04-2005, 08:05 PM
  5. To stop Excel from opening many workbooks at startup
    By BHARATH RAJAMANI in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 12:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1