Troubleshooting Macro Enablement and Breaking Links
I have a set of questions with regard to an existing spreadsheet. I have a simple Reset Button that I created, with code that when "pushed", resets a set of fields back to null value. The problem is that I am now getting an error message with regard to "Macros" being enabled. It instructs me to save the sheet and when reopening, enable Macros. I do that, then it tells me I have lnks that cannot be updated. I know of no links I have in this spreadsheet.. When I open the Update Linkages and choose to Break Links, it doesn't do it. How do I enable Macros so I can run this simple piece of code for resetting my columns? And how to I either trace down a link that I've got to get out of my sheet (Lord knows how it got there to begin with) or can I break it....and if I can, why doesn't it go away? Questions welcomed.
Fixing-Macro-execution-and-delet.ppt
Fixing-Macro-execution-and-delet.ppt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jkpieterse,
Thanks. Sorry for the delay. I've been out with a hernia operation recently so I'm responding a little slow. Can we start at the beginning? My spreadsheet has become rather complex and I had Macros that worked. Now the Macros don't work and I have something that says that I have links. When I look at the links, I try but cannot "break them". I also now have an encription password I didn't have before. So I'm trying to figure out what I did wrong. I pasted part of my sheet into another sheet that I think had these problems and am now trying to trouble shoot it.
A couple of specific questions;
If I save a spreadsheet as a Macro enabled spreadsheet, do I have to choose the option to run Macros every time I open it?
Is there any way to find the linked fields that are in my spreadsheet so I can change them or delete them? Any reason why it won't allow me to break a link?
If I cannot find or retrieve the password on the encription tab, do I have to start over or can I copy fields over to another spreadsheet (fortunately, I've versioned it so I won't have to start from scratch.
Thanks much for the help.
Bright
Thanks. Sorry for the delay. I've been out with a hernia operation recently so I'm responding a little slow. Can we start at the beginning? My spreadsheet has become rather complex and I had Macros that worked. Now the Macros don't work and I have something that says that I have links. When I look at the links, I try but cannot "break them". I also now have an encription password I didn't have before. So I'm trying to figure out what I did wrong. I pasted part of my sheet into another sheet that I think had these problems and am now trying to trouble shoot it.
A couple of specific questions;
If I save a spreadsheet as a Macro enabled spreadsheet, do I have to choose the option to run Macros every time I open it?
Is there any way to find the linked fields that are in my spreadsheet so I can change them or delete them? Any reason why it won't allow me to break a link?
If I cannot find or retrieve the password on the encription tab, do I have to start over or can I copy fields over to another spreadsheet (fortunately, I've versioned it so I won't have to start from scratch.
Thanks much for the help.
Bright
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vyyk,
Thanks for the note. Yes, I copied a number of the tabs into another sheet. And "yes" I have a bunch of range names. I just checked the Alt.pf8 for Macros and none of my macros are in the new sheet; so must have been left behind. I think what I'm dealing with here is a corrupted spreadsheet. The Encription is "on" and I don't have the password so I cannot even add new tabs. I'm hoping I can copy and paste the sheet into a fresh one and move on with it.
jkpieterse,
I'll download the FindLink file and send you some code shortly.
Thanks guys.
Bright
ASKER
OK gentlemen,
Here's the situation, I think I have some rogue VB code in one of these sheets. I'm now checking. I have both an XLSX and XLSM saved that are versioned so the encription is something that has just showed up. Excel also advises me to save the file as a Macro enabled file XLSM or I lose something called a VB Project. I don't have to my knowledge a VB Project element to this workbook; unless you tell me a Macro is concidered a VB Project.
Going to run the links software next.
Here's the situation, I think I have some rogue VB code in one of these sheets. I'm now checking. I have both an XLSX and XLSM saved that are versioned so the encription is something that has just showed up. Excel also advises me to save the file as a Macro enabled file XLSM or I lose something called a VB Project. I don't have to my knowledge a VB Project element to this workbook; unless you tell me a Macro is concidered a VB Project.
Going to run the links software next.
ASKER
Is this natural? I can't add another sheet/tab either.
Why-can-t-I-add-another-tab-shee.pptx
Why-can-t-I-add-another-tab-shee.pptx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hard set of questions that the guys here jumped right in and gave me good advise. My sheet is back up and running.
Big "thanks"!
Big "thanks"!
ASKER
Thank you,
Bright