HELP with Macros

[calli]

hi,

I need some help with recording a macro but every time I try to recor
the macro in the personal macro workbook, I get a pop stating that th
personal workbook needs to be opened in the start up folder in order t
record, but I don't know how to open it. I would appreciate an
suggestions.

Thanks,

Call

 

[Marcelo]

save the personal.xls at

C:\program files\microsoft Office\OFFICE11\XLSTART
--

hth
regards from Brazil
May the force be with you
Marcelo
*******************


"calli" escreveu:

 

[SteveW]

or even

C:\Documents and Settings\Owner\Application Data\Microsoft\Excel\XLSTART

depending what version of Excel you have

Best trick is to search for EXCEL.XLB there should be a XLSTART folder
PERSONAL.XLS goes there

Steve

 

[Dave Peterson]

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

 

[Gord Dibben]

Calli

Below is a posting by Dave Peterson...........................

Are you using xl2002+?

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

End Dave posting......................................


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Marcelo

My Excel 2003 has this for default path to XLSTART

C:\Documents and Settings\Gord\Application Data\Microsoft\Excel\XLSTART

To find out where it is on your computer..............

Open excel.

ALT + F11 to get to the VBE

CTRL + g to see the Immediate Window

Type this and hit enter:

?application.startuppath

With Excel 2003, WinXP Pro, the return is....................

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Hmmm. I may be redundant, huh?

Calli

Below is a posting by Dave Peterson...........................

Are you using xl2002+?

xl2002+ has the abililty to quarantine what it thinks are bad workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called: "Disabled
Items...".

Check under there to see if it's marked not to open. You can enable it there,
too.

If the workbook is really bad, you may want to delete that copy and put a copy
of your backup version into your XLStart folder.

End Dave posting......................................

Gord Dibben MS Excel MVP

 

[calli]

--------------------------------------------------------------------------------

xl2002+ has the abililty to quarantine what it thinks are ba
workbooks.

They can keep track of them so that it doesn't even try to open them.

If you look under Help|About MS Excel, you'll see a button called
"Disabled
Items...".

Check under there to see if it's marked not to open. You can enable i
there,
too.

If the workbook is really bad, you may want to delete that copy and pu
a copy
of your backup version into your XLStart folder.

(If you don't have a backup, take the time now and create one.)

I checked under Help and there is no Disabled Item, I don't have a
Excel 2002 + version, as well, I know where the PERSONAL.XLS file i
stored and the file is there. So... I don't know what to do anymore?

Need more help, Thanks.

Call