Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cannot change macro on button (XL 2000 SR3)

    I had a macro, 'FlipSelection', that I assigned to a custom button on a custom menu, later I modified the macro and renamed it 'InvertRows'. Now the custom button has the (now non-existent) 'FlipSelection' attached to it, I can assign 'InvertRows' to the button and it sticks until I close XL, but when I reopen XL the button has reverted to 'FlipSelection'. The macros are/were in Personal.xls. I thought that custom buttons and menus and their assigned macros were stored in excel.xlb and that this was saved at each shutdown, but this appears not to be so as the only .xlb file on my machine was last modified on 18/12/2003. Help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    Do you show hidden files and folders in Windows Explorer? In recent versions, the .xlb file is stored in a subfolder of a hidden folder in your profile.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    Yes Hans I do have W.E. set to show hidden files.

    It rather looks as if when XL is closed it is not saving my .xlb file.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    Try renaming or moving the existing .xlb file to see if it is recreated when you next run (and quit) Excel.

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    Hans

    I have tried both renaming and moving the excel.xlb file, and no new xlb file is created on shutting down XL.

    Despite this XL then reopens with all my custom menus and buttons present. Weird

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    There MUST be an .xlb file somewhere where you haven't found it.

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cannot change macro on button (XL 2000 SR3)

    Equally weird

    Since renaming and moving excel.xlb, then closing and reopening XL, then assigning 'InvertRows' to the menu item/button, then closing and reopening XL again, 'InvertRows' now is still attached to the menu item/button. But again no new xlb file!

Posting Permissions

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