compile error

Maui

Board Regular
Joined
Jan 13, 2006
Messages
159
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.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Hi

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

Richard
 

Maui

Board Regular
Joined
Jan 13, 2006
Messages
159
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

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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?
 

Forum statistics

Threads
1,176,070
Messages
5,901,200
Members
434,882
Latest member
tchien69

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top