Macro worksheets- Excel URGENT!!! 1

[JoanneM]

Hi there

do any of you guys have a long........ memory
I have a huge problem an old file has included xl4 macro worksheet

Due to enhancement requirements this file has to be copied
naturally the worksheet is a worksheet not a macro worksheet.

I have tried defining named ranges etc and calling etc -
Am I missing a step in the process
How do I go about getting these macros to run

Please help
Password protection from 1995 prevents me from cannibalising the original

regards

jo

 

[SkipVought]

Joanne,

I had to "convert" a workbook with XL4 macros to VBA. All I did was...

1. observe & document the functionality
2. look at some of the macro code when necessary
3. create VBA procedures from scratch

There are password breaker programs that can be purchased if you can't get into the Excel 95 macros.

Hope this helps Skip,
SkipAndMary1017@mindspring.com