cannot edit a macro

[John]

Hi,
PC running XP
Excel 2003
I can record and play macros but when I try to edit a macro Excel hangs and
I have to close the program
I run the same program on a laptop with Vista and here I can edit macros
Can any one help me edit macros on the PC
Thank you
John

 

[Jan Karel Pieterse]

Hi John,

I can record and play macros but when I try to edit a macro Excel hangs and
I have to close the program

Try Help, Detect and repair from Excel's menu, I expect there is a problem with
your Office setup.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[you]

did you try to reinstal the excel
Korisnik "John" napisao je:

 

[john_marshall via OfficeKB.com]

Hi,
I have done a reinstall of Excell and Word on the PC but still can't edit a
macro. I have also installed the same two programs on a laptop running XP and
there is no problem editing macros.

did you try to reinstal the excel
Korisnik "John" napisao je:

Hi,
PC running XP

[quoted text clipped - 5 lines]

Thank you
John

 

[john_marshall via OfficeKB.com]

Hi,
Yes I have reinstalled both Excel and Word but no different, every time I try
to edit a macro the program stops and I have to close it.
I have no problem with the two programs on a laptop with XP installed from
the same disc.
The problem only happens using the PC
John

did you try to reinstal the excel
Korisnik "John" napisao je:

Hi,
PC running XP

[quoted text clipped - 5 lines]

Thank you
John

 

[john_marshall via OfficeKB.com]

Hi Jan
I have run detect and repair and there is no difference, I still cannot edit
a macro. Works fine on a laptop also running XP.
John

 

[Jan Karel Pieterse]

Hi John,

I have run detect and repair and there is no difference, I still cannot edit
a macro. Works fine on a laptop also running XP.

I guess it is time to remove Office and install it again.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[Jan Karel Pieterse]

Hi John_marshall,

I have done a reinstall of Excell and Word on the PC but still can't edit a
macro.

Can you edit macro's when you start Excel in safe mode ? (press and hold the
control key when you open Excel)

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi,
Thanks for your time.
Just tried your suggestion, it changes the macro security level so that I
could not run a macro until I had changed the macro security level. I can now
run macros but still not edit them, as soon as I go into macro - edit macro -
Excel stops responding and I have to close the program. I then get the window
that asks me if I want to send a report to Microsoft.
John

 

[Jan Karel Pieterse]

Hi John_marshall,

as soon as I go into macro - edit macro -
Excel stops responding and I have to close the program. I then get the window

Have you got any plugins installed for the VBA Editor?
If so, check out the COM addins.

See my website how to access the COM addins installed in Excel:
www.jkp-ads.com/articles/startupproblems.asp

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi Jan
Thanks for your help.
There are 8 addins but none are ticked
No Com addins showing
Nothing in XLStart
Regards
John

 

[Jan Karel Pieterse]

Hi John_marshall,

There are 8 addins but none are ticked
No Com addins showing
Nothing in XLStart

OK, time to dive into the registry then.

Close all Office programs.

Check this path of your registry:

HKEY_CURRENT_USER\Software\Microsoft\VBA\VBE\6.0\Addins

Which are listed?

If any, export that key by rightclicking on "addins" in the tree and choosing
Export. Then remove the entries shown on the right in that key one-by one, each
time retrying the VBE.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi Jan,
Thanks for your suggestions.
In the registry there is the following

VBA\6.0\Common\
Default
CtlsShowSelected
Dock
DsnShowSelected
FolderView
MainWindow
MdiMaximized
PropertiesWindow
Tool
UiAccess

In VBA there is also
VBA\MSAccess
Default
RequiredDeclaration

And
VBA\Trusted
Default

There is no VBE
I cannot see any Addins

Regards
John

 

[Jan Karel Pieterse]

Hi John_marshall,

There is no VBE
I cannot see any Addins

OK.

Next step then.
Try closing all Office applications.

Now locate a file called vba6.dll

(search for the file using Windows Find, make sure to look in hidden folders
and for hidden files)

Try if you can rename that file and if so, do an Office setup, repair option.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi Jan,
Thanks for putting in so much time on this, any time you want to stop let me
know.
I have searched the PC for the file Vba6.dll and cannot find it even in the
hidden files.
I have searched the laptop, that I can edit macros on, and the file is not
there either.
Regards
John

 

[Jan Karel Pieterse]

Hi John_marshall,

Thanks for putting in so much time on this, any time you want to stop let me
know.
I have searched the PC for the file Vba6.dll and cannot find it even in the
hidden files.
I have searched the laptop, that I can edit macros on, and the file is not
there either.

I'm very sorry, I misspelled the name, which should have been VBE6.dll!

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi Jan,
I have found the file, renamed it.
Opened Excel tried to write a macro and Excel would not let me.
Asked me if I wanted to repair, answered Yes, and it Installed Microsoft
Excel Feature

Checked VBE6.dll and a new one is in place

Opened Excel, wrote a macro, saved file, ran the macro no problem
Tried to edit the macro and Excel stopped responding.

Regards
John

 

[Jan Karel Pieterse]

Hi John_marshall,

Opened Excel, wrote a macro, saved file, ran the macro no problem
Tried to edit the macro and Excel stopped responding.

<sigh> This *is* a persistent one!

Could you try to remove the VBE's registry entry entirely (please export it
first)? Did we already try to remove Excel's registry entry?

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

 

[john_marshall via OfficeKB.com]

Hi Jan,
Thanks for your time, any time you want to stop let me know.
I have looked in the registry and cannot find any VBE
There is a VBA which has the following;
6.0 common
MS Access
Trusted

There is also:
Visual Basic
6.0

Regards
John

 

[Jan Karel Pieterse]

Hi John_marshall,

Thanks for your time, any time you want to stop let me know.
I have looked in the registry and cannot find any VBE
There is a VBA which has the following;

Try exporting and then removing this key:

HKEY_CURRENT_USER\Software\Microsoft\VBA

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com