Re: [ExcelVBA] Macro seems Unremovable - please help

 

How big is the file with the macros or the references? Can you point
me to a copy or email it to me? John dot bullas at gmail dot com

Dr B

On 10/08/2012, Susan Sawicki <sawicki_savickas@hotmail.com> wrote:
>
> 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
>
>
>
>

--
Sent from my mobile device

===========================
http://uk.linkedin.com/in/drjohnbullas

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (9)

Recent Activity:

• New Members 4

Visit Your Group

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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___