+ Reply to Thread
Results 1 to 2 of 2

Excel11.xlb v Personal.xls v PERSONAL.XLS v PERSONAL.XLSB problems

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel11.xlb v Personal.xls v PERSONAL.XLS v PERSONAL.XLSB problems

    Hello!
    I had customised menus and buttons in Excel 2003, with referred macros stored in Personal.xls in the XLStart directory.
    I recently (Nov2019) installed Excel 2013 and PERSONAL.XLSB appeared in the XLSTART directory and Personal.xls became PERSONAL.XLS.
    I am able to run both XL2003 and XL2013, but when I run XL2003 my customised buttons have disappeared and the customised menus are empty.
    If I remove the PERSONAL.XLSB file, the Personal.xls file does not get "opened", also "new macros" cannot be added and stored in the Personal Macro Workbook because "the Personal Macro Workbook in the startup folder must stay open for recording".
    If PERSONAL.XLSB and PERSONAL.XLS are present
    1) Alt-f11 gest me to the "usual" list of the macros
    2) if I record a new macro in XL2003, the file that gets updated is PERSONAL.XLS.

    How can I restore the XL2003 menu and toolbar "situation"?
    Thanks in advance!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Excel11.xlb v Personal.xls v PERSONAL.XLS v PERSONAL.XLSB problems

    Hi, welcome to the forum.
    I ran into similar issues when I moved up to the newer versions of Excel. The 'old' custom menu buttons that I had working in all my files were no longer supported.
    Even if you say you're sunning both 2003 and 2013 on the same machine I think the different DLL files clash somewhere along the line.
    In the end I just converted it all to custom ribbon menus.
    I did however find a link once to open the old style command bars under the newer versions of Excel but do not remember which site it was, I think Ron de Bruin's site (which is an excellent site explaining the Custom UI (Ribbon)
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Problems with my Personal.xlsb
    By Bsethna in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-18-2019, 08:50 AM
  2. [SOLVED] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  3. Running a Personal.XLSB Macro From Within Another Personal.XLSB Macro
    By js0873 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-23-2015, 09:58 AM
  4. Replies: 0
    Last Post: 01-15-2015, 05:53 AM
  5. Replies: 0
    Last Post: 05-10-2012, 09:22 AM
  6. Excel 2007 : personal.xls and personal.xlsb in 2007
    By ali84pk in forum Excel General
    Replies: 0
    Last Post: 02-04-2011, 01:02 PM
  7. Calling Personal.xls functions without needing a 'personal.xls!' prefix
    By Skywalker in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-08-2010, 02:43 AM

Tags for this Thread

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