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]

__._,_.___

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

Messages in this topic (7)

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

.

__,_._,___