Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    personal.xls error (2K)

    I using a personal.xls file which contains macros and a picture icon on a custom toolbar to run the macros. The xls file is installed on a different PC from the one used to create the macros and toolbar etc. When I try to use the macro, the following error message appears: "(Embedded image moved to file: pic09654.jpg)"

    Can someone shed some light on this please?

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    Is the custom toolbar attached to your personal.xls - or is it created by code each time you launch Excel?
    Gre

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    Sounds as if your personal.xls contains a linked picture in one of its sheets.

    Unhide it to check (Window, unhide)
    Hide again afterwards.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    There are no pictures anywhere in the workbook.

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    The custom toolbar is attached to the workbook..

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    I'm sorry to say I'm out of idea's then.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  7. #7
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: personal.xls error (2K)

    Have you tried opening the mentioned image file and seeing whether - by any chance - it resembles the custom icon you are placing on your custom toolbar?
    Gre

Posting Permissions

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