Excel 2000, cannot edit macro, nothing happens when I select "edit"

T

TinaF

I have a worksheet built by someone else with many macros built in and
they all are operational - no error messages. I want to edit one macro
in the worksheet. I follow the steps: Tools, Macro, Macros (here I
get the list of macros in the spreadsheet). I select the name of the
one in the list that I want to edit then select "Edit" and nothing
happens. The macro window closes and I'm back in the worksheet.
Microsoft Visual Basic does not open and there is no error message.

As a test, I recorded my own macro in the worksheet then followed the
same steps above but selected my test macro from the list and then
selected "Edit". When I did this, "Edit" worked as expected.
Microsoft Visual Basic opened and my macro code was displayed. I was
able to edit the macro code, save it and run it.

Why can't I edit the previously existing macros?
 
H

Héctor Miguel

hi, Tina !
I have a worksheet built by someone else with many macros built in and they all are operational - no error messages.
I want to edit one macro in the worksheet.
I follow the steps: Tools, Macro, Macros (here I get the list of macros in the spreadsheet).
I select the name of theone in the list that I want to edit then select "Edit" and nothing happens.
The macro window closes and I'm back in the worksheet [...]
Why can't I edit the previously existing macros?
Click to expand...

the macro/s you can not edit [probably] are stored in an 'old' version 4 excel macro-sheet [hidden ?]

hth,
hector.
 
T

TinaF

Héctor Miguel said:
hi, Tina !
I have a worksheet built by someone else with many macros built in and they all are operational - no error messages.
I want to edit one macro in the worksheet.
I follow the steps: Tools, Macro, Macros (here I get the list of macrosin the spreadsheet).
I select the name of theone in the list that I want to edit then select"Edit" and nothing happens.
The macro window closes and I'm back in the worksheet [...]
Why can't I edit the previously existing macros?
Click to expand...

the macro/s you can not edit [probably] are stored in an 'old' version 4 excel macro-sheet [hidden ?]

hth,
hector.
Click to expand...

Is there any way I can get my hands on an version 4 so I can do the
edits that I need to? Microsoft offer anything for someone in the
position that I am?
 
H

Héctor Miguel

hi, Tina !
the macro/s you can not edit [probably] are stored in an 'old' version 4 excel macro-sheet [hidden ?]
Click to expand...

Is there any way I can get my hands on an version 4 so I can do the edits that I need to?
Microsoft offer anything for someone in the position that I am?
Click to expand...

if this is a 'yes'... and we are 'talking' about excel 4 macro-sheet/s...

1) you might want to give a try downloading .HLP file/s from MS:
-> Macro97.exe http://support.microsoft.com/kb/e143466/
-> Macrofun.exe http://support.microsoft.com/kb/e128185/

2) [i guess] this is the way you could...
a) 'remember' how to... if you used to program in that 'ancient' macro language
b) start to 'deal with'... if you don't -?-

hth,
hector.
 
Top