| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I am trying to create some macros in Excel that will be available whenever I open any Excel spreadsheet so I think I need to store the Macro in my Personal Macro Workbook. When I click record macro and select store macro in Personal Macro Workbook it is unable to record the Macro and says "Personal Macro Workbook in the startup folder must stay open for recording". How do I set my computer so the personal macro workbook in the startup folder stays open? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=558586 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros
create your presonel.xls on other folder and than copy to the startup folder
hth regards from Brazil Marcelo "Cincy" escreveu: I am trying to create some macros in Excel that will be available whenever I open any Excel spreadsheet so I think I need to store the Macro in my Personal Macro Workbook. When I click record macro and select store macro in Personal Macro Workbook it is unable to record the Macro and says "Personal Macro Workbook in the startup folder must stay open for recording". How do I set my computer so the personal macro workbook in the startup folder stays open? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=558586 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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.) Cincy wrote: I am trying to create some macros in Excel that will be available whenever I open any Excel spreadsheet so I think I need to store the Macro in my Personal Macro Workbook. When I click record macro and select store macro in Personal Macro Workbook it is unable to record the Macro and says "Personal Macro Workbook in the startup folder must stay open for recording". How do I set my computer so the personal macro workbook in the startup folder stays open? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=558586 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros
Thanks. I went to the disabled items location you mentioned and enabled the folder. Once I did that the macro buttons and macros automatically appeared in my spreadsheets because I had previously created the macros but couldn't view them because they were disabled. It did say the personal.xls file was disabled to allow other programs to function so I hope by re-enabling it it doesn't cause me other problems. I am confused by your statement about creating a backup and that if the workbook is really bad I may want to delete that copy and put a copy into my xlstart folder. How do I know if the personal.xls file located in my xlstart folder is bad? How do I create a backup? I also did a search on my computer for the xlstart folder and found that the xlstart folder under program files is empty but I did find the personal.xls file under the Documents and Setting folder for one of the users. Is this the correct location for the personal.xls file? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=558586 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros
ToolsOptionsSecurity.
Set macro security to "medium". The go to HelpAboutDisabled Items If Personal.xls is disabled, enable it. Gord Dibben MS Excel MVP On Wed, 5 Jul 2006 12:56:34 -0500, Cincy wrote: I am trying to create some macros in Excel that will be available whenever I open any Excel spreadsheet so I think I need to store the Macro in my Personal Macro Workbook. When I click record macro and select store macro in Personal Macro Workbook it is unable to record the Macro and says "Personal Macro Workbook in the startup folder must stay open for recording". How do I set my computer so the personal macro workbook in the startup folder stays open? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros
If excel disabled the workbook, then it thought something was bad with that
workbook. Deleting the current version and replacing it with a "clean" backup may clear up the problem. I just use windows explorer to copy my personal.xls to a new location whenever I want a backup made. Then if I screw something up, I can use that backup copy. Cincy wrote: Thanks. I went to the disabled items location you mentioned and enabled the folder. Once I did that the macro buttons and macros automatically appeared in my spreadsheets because I had previously created the macros but couldn't view them because they were disabled. It did say the personal.xls file was disabled to allow other programs to function so I hope by re-enabling it it doesn't cause me other problems. I am confused by your statement about creating a backup and that if the workbook is really bad I may want to delete that copy and put a copy into my xlstart folder. How do I know if the personal.xls file located in my xlstart folder is bad? How do I create a backup? I also did a search on my computer for the xlstart folder and found that the xlstart folder under program files is empty but I did find the personal.xls file under the Documents and Setting folder for one of the users. Is this the correct location for the personal.xls file? -- Cincy ------------------------------------------------------------------------ Cincy's Profile: http://www.excelforum.com/member.php...o&userid=35172 View this thread: http://www.excelforum.com/showthread...hreadid=558586 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macros
Yes.
Gord Dibben MS Excel MVP On Wed, 5 Jul 2006 14:13:38 -0500, Cincy wrote: I also did a search on my computer for the xlstart folder and found that the xlstart folder under program files is empty but I did find the personal.xls file under the Documents and Setting folder for one of the users. Is this the correct location for the personal.xls file? |
| 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) | |||
Linear Mode
