Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros
My office just upgraded to MS Office 2007 and I am having some problems with
the macros in Excel and Word. I have recorded them correctly and most of them work just fine, but there is one that I use often in Excel that everytime I try to use the macro I have created it gives me the error "Can not run the macro 'name'. The macro may not be available in this workbook or all macros may be disabled." But I set it up exactly the same as the same as the others in my PERSONAL.XLS and it is shown as a default to let them be in all open workbooks... In Word I set up a macro to do a signature block for letters, but every now and again it messes up??? Please HELP anyone that can give any answers would be hugely appreciated!!! Day 2... This a.m. I deleted my personal.xls and discovered I had 2 so I deleted both and retarted to regenerate an excel template. I rerecorded my macros and on the first try they worked, but then when I tried to use them inside of another program that we use as an add-in and also outside of that program in excel alone I got Microsoft Visual Basic Error 400. Another lady is having the exact same issue and we are both beyond fustrated and out of ideas any insight would be more than helpful at this point... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros: can you copy macros from one doc to another? | Excel Discussion (Misc queries) | |||
Excel 2007 macros - how to merge 5 macros together into one | Excel Discussion (Misc queries) | |||
Macros warning always shows up, even if all macros removed | Excel Discussion (Misc queries) | |||
Macros - copying macros from one computer to another | Excel Discussion (Misc queries) | |||
Training: More on how to use macros in Excel: Recording Macros | Excel Worksheet Functions |