Old time macrosheets?

  • Thread starter Thread starter Salmon Egg
  • Start date Start date
S

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
 
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
 
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
 
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>.
 
Which version of excel are you now using? If you have xl95 and open the file
there you will see a macro sheet.
 
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.
 
Jim Cone said:
Ctrl + F11
Click to expand...

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
 
Shane Devenshire said:
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.
Click to expand...

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
 
Back
Top