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
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