View Single Post
  #3  
Old December 25th, 2009, 01:29 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
 
Posts: 19,791
Default Macro is not working properly

My first guess is that the security setting in the recipient's pc is set to
disable macros.

Depending on the version of excel they're using, you can toggle it:

In xl2003 menus:
tools|macro|security|security level tab
set it for medium

The user will be asked if they want to enable macros when they open a file with
macros. If they answer yes, then your macros should work.

If they answer no, you'll have to teach them that they want to answer yes for
this workbook.

If this doesn't help, you'll have to explain what not working means.

Sherees wrote:

Merry X'mas
created an excel file with macros in it for printing. when i saved this file
on other computers, the buttons with macros assigned is not working. Is it
because that i changed the file name when i was saving it on other computer,
but when i changed it to the previous name then also the macros are not
working, please advice the solution. The file is properly working in the
computer from where i created the macros, even thoughthe file name is
changed. Macros were enabled in all the computers.

Thanks & rgds
--
Life isa journey not a destination

"Sherees" wrote:


--
Life isa journey not a destination


--

Dave Peterson