Macros

  • Thread starter Thread starter Noxzema
  • Start date Start date
N

Noxzema

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 ' '. 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...
 
Back
Top