Thread: Macros
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Noxzema Noxzema is offline
external usenet poster
 
Posts: 4
Default Macros

if only...

My personal is a .xlsb and still nothing. there is one person who
everything is working fine for in and out of excel and the program we use to
manage the files. i set them up for her and I can't tell what is different
about the settings on our computers. everything is exactly the same as far
as I can tell. what am I not seeing?!?!?!?

"Don Guillett" wrote:

Wouldn't it be NICE if we could use the SAME personal file for both 2003 and
2007!!

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Noxzema" wrote in message
...
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...