Old time macrosheets?

[Salmon Egg]

It has been a long time since I used macros I prepared in Excel. Since
then, Visual Basic seems to be the preferred route toward a macro. I
have not kept up with this.

If my memory serves me well, I remember being asked when I wanted a new
sheet whether I wished to open a spreadsheet or a macrosheet. I cannot
seem to find the equivalent in a newer although several year old version
of Excel. The appearance of the macrosheet started out with wide columns
compared to spreadsheet columns,

I was thinking of doing a sham macro recording and then trying to edit
the macro. With all the other things I a trying to do, I just have not
gotten around to it.

Is there a way to open an old fashioned macrosheet?

Bill

 

[John]

Hi
From memory, the old macro sheet had the extension .XLM and you can open and
edit them the same way as a regular .XLS file.
BTW, i'm using 2003 not 2007 XL version
HTH
John

 

[Jim Cone]

Ctrl + F11
--
Jim Cone
Portland, Oregon USA


"Salmon Egg" <[email protected]>
wrote in message
It has been a long time since I used macros I prepared in Excel. Since
then, Visual Basic seems to be the preferred route toward a macro. I
have not kept up with this.
If my memory serves me well, I remember being asked when I wanted a new
sheet whether I wished to open a spreadsheet or a macrosheet. I cannot
seem to find the equivalent in a newer although several year old version
of Excel. The appearance of the macrosheet started out with wide columns
compared to spreadsheet columns,
I was thinking of doing a sham macro recording and then trying to edit
the macro. With all the other things I a trying to do, I just have not
gotten around to it.
Is there a way to open an old fashioned macrosheet?
Bill

 

[Dave Peterson]

If you rightclick on the worksheet tab and choose Insert..., you'll see an
option for the 4.0 macro sheet.

And that ends my knowledge of those old style macros <vbg>.

 

[Don Guillett]

Which version of excel are you now using? If you have xl95 and open the file
there you will see a macro sheet.

 

[Shane Devenshire]

Hi,

If my memory serves me, you can't record the old style macros anymore, you
need to write them from scratch. The macro recorder will only record Visual
Basic and there is no comparison between that and the old macro language.

 

[Salmon Egg]

Ctrl + F11

Thank you for the reply. It does not seem to work. It is interesting
that a friend indicated that I should use Alt + F11.

It seems that my function keys do not work. I found a table in the Excel
help for fujnction keys. F3 should copy and F4 should paste. They did
not work. F3 did not copy because Cmd + V pasted what I had copied
earlier with a Cmd + C,

I looked through preferences and a few other places to see if there was
a way to toggle F keys on and off. I could not find a way.
Unfortunately, I do not have the time right now to track down the
problem.

I am wondering if the problem may be that my computer and operating
system is too new. I am using a Mac Pro and Leopard. My version of Excel
was from before the days of Intel Macs.

Bill

 

[Salmon Egg]

If my memory serves me, you can't record the old style macros anymore, you
need to write them from scratch. The macro recorder will only record Visual
Basic and there is no comparison between that and the old macro language.

Thank you and others who tried to help. I think I have some fundamental
problems. For example, I get messages that I cannot record, as you think
might be the case.

Bill