Macro

[fiona]

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

 

[little_creature]

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?

 

[Jim Gordon MVP]

Hi

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

-Jim Gordon
Mac MVP

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

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[fiona]

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

Thanks

 

[JE McGimpsey]

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.