Macro Only working on my PC

  • Thread starter Thread starter J Wheatley
  • Start date Start date
J

J Wheatley

Hi,

I am very new to Macro's and have no experience. I have created a VERY basic
macro on a spreadsheet, where you click a button named "complete" and it
automaticly turns the spreadsheet into a attachment on an email. It works
perfectly fine on my PC, but it doesn't work for anyone else??

Can anyone help please?

PS I am using excel 2007
 
Are the recipients enabling macros when they open your file?

What version of excel are you using?

If it's xl2007, are you sending a macro enable workbook?
 
What happens when they try to run the macro?

Does it start and fail or just not run at all?
 
You need to enable macros in other machines by visiting Office Button ->
Excel Options -> Trust Centre -> Trust Centre Settings -> Macro Settings ->
Enable all macros and Trust Access to the VBA project...

Run the macro from your friend machine after copying it or creating the
macro...

Cheerz,
Jijin
 
Back
Top