Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
hi, I need some help with recording a macro but every time I try to record the macro in the personal macro workbook, I get a pop stating that the personal workbook needs to be opened in the start up folder in order to record, but I don't know how to open it. I would appreciate any suggestions. Thanks, Calli -- calli ------------------------------------------------------------------------ calli's Profile: http://www.excelforum.com/member.php...o&userid=37561 View this thread: http://www.excelforum.com/showthread...hreadid=571941 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
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: hi, I need some help with recording a macro but every time I try to record the macro in the personal macro workbook, I get a pop stating that the personal workbook needs to be opened in the start up folder in order to record, but I don't know how to open it. I would appreciate any suggestions. Thanks, Calli -- calli ------------------------------------------------------------------------ calli's Profile: http://www.excelforum.com/member.php...o&userid=37561 View this thread: http://www.excelforum.com/showthread...hreadid=571941 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
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 On Tue, 15 Aug 2006 21:27:02 +0100, Marcelo wrote: save the personal.xls at C:\program files\microsoft Office\OFFICE11\XLSTART |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
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.) calli wrote: hi, I need some help with recording a macro but every time I try to record the macro in the personal macro workbook, I get a pop stating that the personal workbook needs to be opened in the start up folder in order to record, but I don't know how to open it. I would appreciate any suggestions. Thanks, Calli -- calli ------------------------------------------------------------------------ calli's Profile: http://www.excelforum.com/member.php...o&userid=37561 View this thread: http://www.excelforum.com/showthread...hreadid=571941 -- Dave Peterson |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
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 On Tue, 15 Aug 2006 16:18:26 -0400, calli wrote: hi, I need some help with recording a macro but every time I try to record the macro in the personal macro workbook, I get a pop stating that the personal workbook needs to be opened in the start up folder in order to record, but I don't know how to open it. I would appreciate any suggestions. Thanks, Calli |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
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 On Tue, 15 Aug 2006 13:27:02 -0700, Marcelo wrote: save the personal.xls at C:\program files\microsoft Office\OFFICE11\XLSTART |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
Hmmm. I may be redundant, huh?
Gord Dibben wrote: 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 On Tue, 15 Aug 2006 16:18:26 -0400, calli wrote: hi, I need some help with recording a macro but every time I try to record the macro in the personal macro workbook, I get a pop stating that the personal workbook needs to be opened in the start up folder in order to record, but I don't know how to open it. I would appreciate any suggestions. Thanks, Calli -- Dave Peterson |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HELP with Macros
-------------------------------------------------------------------------------- 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.) I checked under Help and there is no Disabled Item, I don't have an Excel 2002 + version, as well, I know where the PERSONAL.XLS file is stored and the file is there. So... I don't know what to do anymore? Need more help, Thanks. Calli -- calli ------------------------------------------------------------------------ calli's Profile: http://www.excelforum.com/member.php...o&userid=37561 View this thread: http://www.excelforum.com/showthread...hreadid=571941 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |