+ Reply to Thread
Results 1 to 4 of 4

Can't Unlink Old Macro Workbook

  1. #1
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Can't Unlink Old Macro Workbook

    One of the departments in my company has a series of workbooks they use that were linked to some macro workbooks a very long time ago. The links are all broken, but I can't figure out how to remove the links.

    There's no VBA in the workbooks, so it's not a WorkbookOpen event. And when I open the linked macro workbooks, there isn't any VBA in there either.

    There's a popup that says "Cannot find BudgetMacroWkbk.xls!AddMENUMenu, which has been assigned to run each time Example File.xlsm is opened. Continuing could cause errors. Cancel opening Example File.xlsm?"

    I'm at a loss. Any ideas?

    I've attached a copy of the workbook. Password to open is "Prod18" which is another issue where I can't figure out how to eliminate the password.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,229

    Re: Can't Unlink Old Macro Workbook

    Hey phelbin,

    Look at File -> Options -> Customize Ribbon: You have a Tab that I don't recognize. It is the first one listed called "Background Removal". Uncheck it and save and try again.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Forum Contributor
    Join Date
    02-18-2014
    Location
    Seattle, WA
    MS-Off Ver
    Excel 2013
    Posts
    197

    Re: Can't Unlink Old Macro Workbook

    Thanks for your quick response, Marvin. It didn't work though.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,692

    Re: Can't Unlink Old Macro Workbook

    The password delete should be
    File - Save As - Tools (at the bottom left beside the "save" button) - General Options - delete the passwords in the little windows, OK , Save
    Can't find anything that works yet for breaking the links.

+ 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. Error Message - Macro to Unlink MS Queries from Workbook
    By awalker2009 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-18-2014, 07:13 AM
  2. [SOLVED] Unlink Pivot Tables
    By AndreaJean18 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-28-2014, 09:28 AM
  3. How to UNLINK cells
    By djerey in forum Excel General
    Replies: 2
    Last Post: 02-01-2012, 05:42 PM
  4. Unlink columns in two worksheets
    By grperry_excel in forum Excel General
    Replies: 5
    Last Post: 12-27-2011, 03:20 PM
  5. unlink object
    By Chuck in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2006, 08:59 AM
  6. Unlink a file ??
    By Kane in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 02-05-2006, 04:10 PM
  7. Unlink Sheets
    By Audubon in forum Excel General
    Replies: 0
    Last Post: 02-04-2005, 03:18 PM

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