Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to record Macro
Whenever I click on Tools, Record a Macro
I get an error message ... "Unable to Record " Why is this happening? If I pull up a spreadsheet with a macro in it, I can Record a new macro in that spreadsheet ... but I can not do it in a new spreadsheet. Some sort of security setting set somewhere??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unable to record Macro
What's the name of the workbook where you're going to store the macro?
Maybe you're recording into Personal.xls and personal.xls has been "quarantined". 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.) Can not Record Macro wrote: Whenever I click on Tools, Record a Macro I get an error message ... "Unable to Record " Why is this happening? If I pull up a spreadsheet with a macro in it, I can Record a new macro in that spreadsheet ... but I can not do it in a new spreadsheet. Some sort of security setting set somewhere??? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to record macro to roll over monthly data | New Users to Excel | |||
Can I record or write a macro to send a worksheet via Outlook? | Excel Discussion (Misc queries) | |||
How do I get a macro to record selections in a dialog box? | Excel Worksheet Functions | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Unable ot Break link for Macro with no source | Excel Discussion (Misc queries) |