compile error

[Maui]

I am sending sheet with macro's in.

When some peoplpe recieve the email and run the macro they are getting compile error. Why is it working on some and not others, any ideas.

 

[Richard Schollar]

Hi

Please post the macro code - without it, it is very difficult for anyone to suggest anything.

Richard

 

[Maui]

I dont think its a mcro code related thing. The macro works on some peoples. Here is code if you think it will help

Sub S1_()

ScreenUpdating = False
Sheets(Array("Format", "Area in region", "Area Ranked ")).Select
Sheets("Format").Activate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Area ").Select
ActiveWindow.SelectedSheets.PrintOut From:=11, To:=13, Copies:=1, Collate _
:=True
Sheets("Print").Select

ScreenUpdating = True

End Sub



Basicaslly I send the macro to about 20 people. I have had complaints that some get this compile error. When I send it to a colleague who sits next to me it works, but others it doesnt work.

 

[Richard Schollar]

Are all the recipients using the same version of Excel (or newer) as you?

 

[Maui]

all using new version

 

[Richard Schollar]

are they getting any indication why it isn't compiling eg does the VBE open up in debug mode? if so, where is it erroring out on? What is the exact message they are seeing?