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

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

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,141,588
Messages
5,707,264
Members
421,498
Latest member
matinebi

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