VBA PC-Mac Compatibility

I'm writing VBA code to be used on both PC & Mac, using Excel 2003 SP1.
Everything works but turning off screenupdating on the Mac. I copy ranges
from 3 sheets in 1 workbook and paste them into another workbook, and I don't
want the users to see this.

Alternatively, I tried to copy without choosing the workbook, with a command:

workbook(A),sheets(B).range(C).copy

instead of

workbook(A).select
sheets(B)range(C).copy

but I can't do that (why?), so the Mac user keeps seeing the back-and-forth
copying.

From the posts I've read by Mac Users, I would have thought that you were doing
things perfectly.

But if you don't get a response in this newsgroup, you may want to try:
microsoft.public.mac.office.excel



MikeM wrote:
>
> I'm writing VBA code to be used on both PC & Mac, using Excel 2003 SP1.
> Everything works but turning off screenupdating on the Mac. I copy ranges
> from 3 sheets in 1 workbook and paste them into another workbook, and I don't
> want the users to see this.
>
> Alternatively, I tried to copy without choosing the workbook, with a command:
>
> workbook(A),sheets(B).range(C).copy
>
> instead of
>
> workbook(A).select
> sheets(B)range(C).copy
>
> but I can't do that (why?), so the Mac user keeps seeing the back-and-forth
> copying.

--

Dave Peterson