According to Hector's reply to my earlier posting, I probably can't
edit macros in an old spreadsheet because they were created using
version 4. Is there any way to get my hands on version 4 so I can edit
just a couple of macros, rather than having to recreate the entire
spreadsheet? Or, any other way to do the edits, other than finding
version 4 software?

You can still edit Excel 4 macros. You can even write new ones, you just can't record them anymore by doing something and have
Excel record it in a macro sheet.
Open a new macro sheet with CTRL+F11. Not ALT+F11, that will open the VBA macro editor.
BTW you should see your macro sheets if you have Excel display all tabs. Just click a macro tab and you can edit the formulas like
they were "normal" Excel formulas.
HELP on Excel4 macros is still available; search in MS site.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"TinaF" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| According to Hector's reply to my earlier posting, I probably can't
| edit macros in an old spreadsheet because they were created using
| version 4. Is there any way to get my hands on version 4 so I can edit
| just a couple of macros, rather than having to recreate the entire
| spreadsheet? Or, any other way to do the edits, other than finding
| version 4 software?
|

Niek, below was my earlier post. I've tried to edit the old macros and
nothing happens (see below). Hector replied to this posting and said
that it was probably because they're version 4.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
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?

Niek Otten wrote:
> You can still edit Excel 4 macros. You can even write new ones, you just can't record them anymore by doing something and have
> Excel record it in a macro sheet.
> Open a new macro sheet with CTRL+F11. Not ALT+F11, that will open the VBA macro editor.
> BTW you should see your macro sheets if you have Excel display all tabs. Just click a macro tab and you can edit the formulas like
> they were "normal" Excel formulas.
> HELP on Excel4 macros is still available; search in MS site.
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "TinaF" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> | According to Hector's reply to my earlier posting, I probably can't
> | edit macros in an old spreadsheet because they were created using
> | version 4. Is there any way to get my hands on version 4 so I can edit
> | just a couple of macros, rather than having to recreate the entire
> | spreadsheet? Or, any other way to do the edits, other than finding
> | version 4 software?
> |

<and I'm back in the worksheet>

The worksheet you were in or a macro sheet? Macro sheets look a lot like normal worksheets. Do you see commands in the cells,
preceded by a = sign?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"TinaF" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Niek, below was my earlier post. I've tried to edit the old macros and
| nothing happens (see below). Hector replied to this posting and said
| that it was probably because they're version 4.
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 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?
|
| Niek Otten wrote:
| > You can still edit Excel 4 macros. You can even write new ones, you just can't record them anymore by doing something and have
| > Excel record it in a macro sheet.
| > Open a new macro sheet with CTRL+F11. Not ALT+F11, that will open the VBA macro editor.
| > BTW you should see your macro sheets if you have Excel display all tabs. Just click a macro tab and you can edit the formulas
like
| > they were "normal" Excel formulas.
| > HELP on Excel4 macros is still available; search in MS site.
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > "TinaF" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| > | According to Hector's reply to my earlier posting, I probably can't
| > | edit macros in an old spreadsheet because they were created using
| > | version 4. Is there any way to get my hands on version 4 so I can edit
| > | just a couple of macros, rather than having to recreate the entire
| > | spreadsheet? Or, any other way to do the edits, other than finding
| > | version 4 software?
| > |
|

hi, Tina !

> ... Is there any way to get my hands on version 4 so I can edit just a couple of macros
> rather than having to recreate the entire spreadsheet?
> Or, any other way to do the edits, other than finding version 4 software?

IF... we are talking about a 'really' xl4 macro/s IN xl4 macro-sheet/s... -?-
-> try with the following 'steps' [keep in mind one of the macros 'name' that you can not 'edit']...

1) go to [menu] insert / name / define...
-> seek / locate the macro name
-> you will see the [macro]sheet name AND the cell to where the [macro] name is referencing to

2) [now] you *should* be able to see that [macro] sheet name/tab

3) IF... you can not 'see' that sheet-tab [maybe]...
the creator of that 'ancient' macros [in a macro-sheet] used a [very]hidden macro-sheet -?-
and probably this is 'why' you are 'backing' to your 'worksheet' eery time you try to 'edit' the macro -?-
[also, the creator might used hidden names too] -?-

regarding the 'need' to 'find' version 4 software [as i said to you in your previous post]...
===== begin-snip of previous reply =====
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 -?-
===== end-snip of previous reply =====

if any doubts [or further information]... would you please comment ?
hth,
hector.