Sabtu, 06 Oktober 2012

RE: [ExcelVBA] Macro seems Unremovable - please help

 


David,

I apologize for delay in responding to the several in the group who've offered help to me with the unremovable macros. I've had an accident and am inching back to my computer. I'll post to you in several days for the remote help you've offered.

Susan

To: ExcelVBA@yahoogroups.com
From: yahoo@grugeon.com.au
Date: Tue, 28 Aug 2012 21:18:42 +1000
Subject: RE: [ExcelVBA] Macro seems Unremovable - please help

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



[Non-text portions of this message have been removed]

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (31)
Recent Activity:
----------------------------------
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