Macro

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fiona@spatchurst.com.au - 10 Apr 2007 04:30 GMT

hi
excel has just been upgraded to excel x from 95 and the operating
system also upgraded to X on mac. I was using simple macros on
previous spreadsheets created by using the " tools macro record, start
and stop" method, but these did not carry across with the files. I
have attempted to create a new macro using the same format however get
a message "unable to record". Could you please help me ? Im not that
savy with mac.

Thanks
Fiona

Reply to this Message

little_creature - 10 Apr 2007 10:46 GMT

Hi,
was that macro strored in that file or in Personal Macro workbook - that's
file where macros are recorded by default - you are asked for location of
macro storage when you do record macro in *Record macro* dialog box.

Can you tell us what action was the macro supposed to do?

On 10.4.2007 5:30, in article
1176175825.070482.129570@n59g2000hsh.googlegroups.com,

> hi
> excel has just been upgraded to excel x from 95 and the operating
[quoted text clipped - 7 lines]
> Thanks
> Fiona

Reply to this Message

fiona@spatchurst.com.au - 26 Apr 2007 04:10 GMT

It was stored in the Personal Macro Workbook. The macro basically
deleted columns, inserted worksheets/rows/ headings and inserted a
formula.

Thanks

On Apr 10, 7:46 pm, little_creature
<littlecreat...@discussions.microsoft.com> wrote:

> Hi,
> was that macro strored in that file or in Personal Macro workbook - that's
[quoted text clipped - 18 lines]
> > Thanks
> > Fiona

Reply to this Message

JE McGimpsey - 27 Apr 2007 15:22 GMT

> It was stored in the Personal Macro Workbook. The macro basically
> deleted columns, inserted worksheets/rows/ headings and inserted a
> formula.

If you can find your old Personal Macro Workbook, you can put it in the

Microsoft Office X:Office:Startup:Excel

folder, and the macros will be available.

Reply to this Message

Jim Gordon MVP - 10 Apr 2007 22:35 GMT

Hi

Is it possible that you didn't install Visual Basic?

-Jim Gordon
Mac MVP

Quoting from "fiona@spatchurst.com.au" <fiona@spatchurst.com.au>, in article
1176175825.070482.129570@n59g2000hsh.googlegroups.com, on [DATE:

> hi
> excel has just been upgraded to excel x from 95 and the operating
[quoted text clipped - 7 lines]
> Thanks
> Fiona

Signature

Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/

Reply to this Message

Mac Forum / Applications / Excel / April 2007

Macro