Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Links

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    New Zealand
    Posts
    24
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Links, (Edit toolbar) is there any way to turn this feature off. I have a spreadsheet that when I save it it prompts me to save with links to unsaved workbook. When I reopen the saved file all macros are linked to the unsaved book. I don’t want these macros to operate or display a error message. Is there any code I can use to save without links to another workbook.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    try
    changing the source spreadsheet to the open spreadsheet (ie link it to itself) or try microsoft's solution: http://support.microsoft.com/default...;EN-US;q188449
    to answer your question, i don't think you can 'turn off' this feature - you'll just have to be careful what you paste from where to stop the links occurring in the first place.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well, you could disable it, but, I don't think that's the main issue here... try anno's suggestion. Or, Import the macros to the workbook that has links, that way, it won't need any links.
    Regards,

    Juan Pablo González
    http://www.juanpg.com

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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