So, you've deleted modules and macros in sheets.
What about userforms?
any of those?
if not..
There's always the "BRUTE FORCE" method
First,
Remove all modules and Userforms and Class modules (if you have any)
Then save the file as a new file (if you have excel 2007 or 2010, use .xlsx)
Then exit the file and re-open it.
If you still get the message, begin deleting sheets.
If you have a LOT of sheets, try deleting half of them.
Exit and save. (as a third file)
open it.
If you get the message, it's in the remaining sheets.
Delete half. save and reopen.
If you didn't, it was in one of the sheets you deleted!
Open a version that still has the sheets and delete the other half.
Save it, then delete half
Or, if it is a small file, delete one sheet, save and reopen.
Continue until it opens without the warning.
once it opens, you've found the sheet with the problem!
Then you can go back into the original and focus on the sheet with the issue.
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: Susan Sawicki <sawicki_savickas@hotmail.com>
To: "ExcelVBA@yahoogroups.com" <excelvba@yahoogroups.com>
Sent: Thu, August 30, 2012 1:45:24 PM
Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
JB,
I will try to answer your question. I don't know that my macros are associated
with drop down menus. I created the macros in VB and not to be funny -- I
learned just enough VB in an 18-wk college course in Excel to be dangerous. But
I loved it and it shows.
Susan
To: ExcelVBA@yahoogroups.com
From: john.bullas@gmail.com
Date: Tue, 28 Aug 2012 12:28:58 +0100
Subject: Re: [ExcelVBA] Macro seems Unremovable - please help
are drop down menus driven by macros, the workbook is littered with them?
JB
On 28 August 2012 12:18, David Grugeon <yahoo@grugeon.com.au> wrote:
> When you deleted the modules, did you also check each of the sheet modules
> to make sure it was empty?
>
> Perhaps you should set up TeamViewer (free) on your PC and if we can find a
> suitable time I could hook into your computer and see what is happening.
>
> I am in Brisbane - Australia GMT +10 - on Skype as davidgrugeon
>
> Best Regards
> David Grugeon
> Excel VBA Group Moderator
>
>
> -----Original Message-----
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
> Of Susan Sawicki
> Sent: Sunday, 26 August 2012 2:17 PM
> To: ExcelVBA@yahoogroups.com
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
> David,
>
> Thank you for looking at the thing.
>
> I deleted the VB macro modules but the grey warning box for disabled macros
> still comes right back up when opening the sheets. I fear we've exhausted
> the thing and it's the 'ghost in the machine'. You mentioned a system
> program file named 'personal' which might hold the macros on the original
> computer (now the raid drive) and is it possible that I, when inputting the
> macros in a clumsy student way, transferred macros to a system 'personal'
> file when in fact I though I was inputting directly into the workbook VBA
> editor?
>
> the wkbks were begun on Excel 2003 and the macros may have been done on 2003
> or 2007. There were no VB passwords. I believe the macros are IN the wkbk
> and not in a system file. My experience with VB is VERY LIMITED.
>
> Can you think of anything else?
>
> Susan Sawicki
>
> To: ExcelVBA@yahoogroups.com
> From: yahoo@grugeon.com.au
> Date: Sun, 12 Aug 2012 13:59:45 +1000
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Hi Susan
>
>
>
> It looks as though mine did not get through.
>
>
>
> You need to remove the code in the Sheet1 module and remove all the standard
>
> modules, not just empty them. (Right click each module in the editor and
>
> then click remove.
>
>
>
> Best Regards
>
> David Grugeon
>
> Excel VBA Group Moderator
>
>
>
> -----Original Message-----
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
>
> Of Susan Sawicki
>
> Sent: Sunday, 12 August 2012 7:21 AM
>
> To: ExcelVBA@yahoogroups.com
>
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> Paul,
>
>
>
> I've drug the workbooks to 3 computers since the original computer crashed
>
> and it appears the VB macro code is in the workbook itself. Alt-F11 brought
>
> up the VB window displaying the macros and I deleted them, or thought I
>
> deleted them. This was on the (recent) Windows 5. Yet the problem still
>
> exists in some form and the Workbook is blocked.
>
>
>
> Susan
>
>
>
> To: ExcelVBA@yahoogroups.com
>
> From: schreiner_paul@att.net
>
> Date: Fri, 10 Aug 2012 04:40:38 -0700
>
> Subject: Re: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> Susan,
>
>
>
> I agree with David's response.
>
>
>
> However, I'd like to pursue something a bit further.
>
>
>
> You said you saved the file in .xlsx format (which itself implies that
>
> you're
>
>
>
> using either Excel 2007 or 2010)
>
>
>
> This format CANNOT have macros.
>
>
>
> If you created it using File->Save As-> and change the file type,
>
>
>
> it should have removed the macros (and warned you about it beforehand)
>
>
>
> If it did not, then somehow it didn't really save it as .xlsx
>
>
>
> which is highly suspicious.
>
>
>
> also, your statement:
>
>
>
> "I've been operating under the impression that I could only disable the
>
>
>
> macros if working on the computer the workbooks were created upon"
>
>
>
> makes me wonder what gave you that impression?
>
>
>
> the comment David made about the macros being in your Personal.xlsb
>
>
>
> file may be a clue.
>
>
>
> In the "default" installation of MicroSoft Office, your Personal.xlsb file
>
> is
>
>
>
> created in
>
>
>
> a sub-directory of the installation directory.
>
>
>
> Which usually is in C:\Program Files (or C:\Program Files (x86))
>
>
>
> Which, WOULD only be on the computer where the macro is created.
>
>
>
> The same thing applies to "Add-Ins".
>
>
>
> I haven't checked in Office 2010 (and I don't remember actually testing it
>
> in
>
>
>
> 2007)
>
>
>
> but Excel does (or used to do) a wierd thing with add-ins.
>
>
>
> If you save a file in .xla format (or .xlsam format) and open this file,
>
>
>
> it actually copies the file to the folder that is defined in your Office
>
> setup
>
>
>
> to
>
>
>
> "open all files in"
>
>
>
> (in my Windows 7 installation, it's:
>
>
>
> C:\Program Files (x86)\Microsoft Office\Office14\XLSTART)
>
>
>
> thereafter, whenever you open Excel, this addin is also open.
>
>
>
> Try opening JUST a blank workbook in Excel, check the Developer tab and see
>
> if
>
>
>
> the macros are available.
>
>
>
> If the macros are in either your Personal.xlsb file or an add-in, then the
>
>
>
> macros aren't actually in your payroll sheets.
>
>
>
> Which means that saving the file in the .xlsx format would have no effect
>
>
>
> because the macros aren't there to begin with...
>
>
>
> Which essentially solves your problem (removing the macros)..
>
>
>
> Paul
>
>
>
> -----------------------------------------
>
>
>
> "Do all the good you can,
>
>
>
> By all the means you can,
>
>
>
> In all the ways you can,
>
>
>
> In all the places you can,
>
>
>
> At all the times you can,
>
>
>
> To all the people you can,
>
>
>
> As long as ever you can." - John Wesley
>
>
>
> -----------------------------------------
>
>
>
> ________________________________
>
>
>
> From: David Grugeon <yahoo@grugeon.com.au>
>
>
>
> To: ExcelVBA@yahoogroups.com
>
>
>
> Sent: Fri, August 10, 2012 6:18:01 AM
>
>
>
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> Hi Susan
>
>
>
> The issue will be if the VBA has been locked. If it has and you do not
>
>
>
> remember the password there is little chance of removing them unless there
>
>
>
> are password busters available.
>
>
>
> Otherwise you just open the files. You should be able to stop the macros
>
>
>
> running by holding down the Shift key while you open them. Then press
>
>
>
> Alt-F11 to open the VBE and delete the macros from wherever they are -
>
>
>
> Module, Worksheet module, or thisworkbook module.
>
>
>
> I feel I am missing something. You say you have tried saving as xlsx which
>
>
>
> should remove the macros and it does not remove them so I am assuming you
>
>
>
> are able to access the files and open them. The fact that the disk is a
>
>
>
> raid disk is irrelevant - so far as Excel is concerned it is just storage.
>
>
>
> Macros do not have to be removed on the same computer they were created on.
>
>
>
> A thought - perhaps the macros are in your personal workbook,
>
>
>
> (PERSONAL.XLSB) and not in the files you are trying to remove them from?
>
>
>
> Perhaps the macros themselves are somehow hidden? If you created them you
>
>
>
> would know that though.
>
>
>
> If you can think of anything that might help me help you, let me know.
>
>
>
> If you want to send a file direct to me (david at Grugeon dot com dot au)
>
>
>
> you are very welcome to (if you can get at the file). I realise they will
>
>
>
> contain confidential info which may prevent you doing this.
>
>
>
> It might help to know what version of Excel and Operating system you are
>
>
>
> using. Also what version of Excel they were created with.
>
>
>
> Best Regards
>
>
>
> David Grugeon
>
>
>
> Excel VBA Group Moderator
>
>
>
> -----Original Message-----
>
>
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
>
>
>
> Of Susan Sawicki
>
>
>
> Sent: Friday, 10 August 2012 3:26 PM
>
>
>
> To: ExcelVBA@yahoogroups.com
>
>
>
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> David
>
>
>
> Thank you. Yes I want to remove the macros from the files on the drive so I
>
>
>
> can open the files w/out the macros. I've tried saving a workbook under
>
>
>
> .xlsx and it won't disable the macros, even after all the warnings seem to
>
>
>
> be run thru. It seems that Excel won't let go of my macros because there's
>
>
>
> VB in the workbook. As bad as this is, you've cleared me for the next step.
>
>
>
> But what step?
>
>
>
> And I've been operating under the impression that I could only disable the
>
>
>
> macros if working on the computer the workbooks were created upon. Is there
>
>
>
> merit in this?
>
>
>
> Susan
>
>
>
> To: ExcelVBA@yahoogroups.com
>
>
>
> From: yahoo@grugeon.com.au
>
>
>
> Date: Mon, 6 Aug 2012 22:28:32 +1000
>
>
>
> Subject: RE: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> Hi Susan
>
>
>
> Not sure what you want.
>
>
>
> Do you want to remove the macros from the files on the drive so you can open
>
>
>
> the files without the macros?
>
>
>
> Do you want to recover the macros so you can use them on other files?
>
>
>
> Do you want to recover the files on the drive?
>
>
>
> I would think your options, for doing anything with the drive are:
>
>
>
> (a) to mount it on your new computer
>
>
>
> (b) to get someone else to mount it on their computer (perhaps a computer
>
>
>
> shop) and copy the files onto, say, a DVD.
>
>
>
> Then you can access the files and do what you want with them.
>
>
>
> Assuming the files are accessible you can remove the macros by saving the
>
>
>
> files as .xlsx files and the macros will be excluded (after warnings).
>
>
>
> More info -> more help.
>
>
>
> Best Regards
>
>
>
> David Grugeon
>
>
>
> Excel VBA Group Moderator
>
>
>
> -----Original Message-----
>
>
>
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
>
>
>
> Of susan.sawicki
>
>
>
> Sent: Monday, 6 August 2012 5:26 AM
>
>
>
> To: ExcelVBA@yahoogroups.com
>
>
>
> Subject: [ExcelVBA] Macro seems Unremovable - please help
>
>
>
> Am unable to remove macros from payroll spreadsheets I created. They're
>
>
>
> simple macros - to click to employee grids and summary pages. The
>
>
>
> spreadsheets are stored on the original Raid drive, a dual storage hard
>
>
>
> drive. The computer is crashed and gone. Who do I take my Raid drive to
>
>
>
> for macro removal?
>
>
>
> Susan Sawicki
>
>
>
> ------------------------------------
>
>
>
> ----------------------------------
>
>
>
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
>
>
>
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
>
>
>
> ARCHIVES for EXCEL VBA.
>
>
>
> ----------------------------------
>
>
>
> Visit our ExcelVBA group home page for more info and support files:
>
>
>
> http://groups.yahoo.com/group/ExcelVBA
>
>
>
> ----------------------------------
>
>
>
> More free tutorials and resources available at:
>
>
>
> http://www.mousetrax.com
>
>
>
> ----------------------------------Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>
>
> ----------------------------------
>
>
>
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
>
>
>
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
>
>
>
> ARCHIVES for EXCEL VBA.
>
>
>
> ----------------------------------
>
>
>
> Visit our ExcelVBA group home page for more info and support files:
>
>
>
> http://groups.yahoo.com/group/ExcelVBA
>
>
>
> ----------------------------------
>
>
>
> More free tutorials and resources available at:
>
>
>
> http://www.mousetrax.com
>
>
>
> ----------------------------------Yahoo! Groups Links
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
>
>
> ----------------------------------
>
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
>
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
>
> ARCHIVES for EXCEL VBA.
>
>
>
> ----------------------------------
>
> Visit our ExcelVBA group home page for more info and support files:
>
> http://groups.yahoo.com/group/ExcelVBA
>
>
>
> ----------------------------------
>
> More free tutorials and resources available at:
>
> http://www.mousetrax.com
>
>
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here:
>http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES
>for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>
--
===========================
http://uk.linkedin.com/in/drjohnbullas
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar