Attachng a Macro to a worksheet/book

  • Thread starter Thread starter ezeetyger
  • Start date Start date
E

ezeetyger

I have created a spreadsheet that contains a macro to perform certain
calcuations and functions. However, it ony works on my PC. If I send
it via email to someone else to use I get a message stating that "The
macros in this Project are Disabled"

However, when I go into Tools, Macros and Run Macro, I can see it, but
it will not run it? Any ideas?
 
Hi ezeetyger!

Sounds like the security settings in the other person's computer are
set to high.

Use:

Tools > Macro > Security
Set to Medium (gives a choice on opening a book with macros in it)
Set to Low (allows all macros)
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top