help with code in a mack

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 29 Mar 2008 23:00 GMT

How would I run this code in a mack. The command button will not activate on
the sheet

Reply to this Message

Niek Otten - 29 Mar 2008 23:40 GMT

Hi Richard,

<this code>

what code?

<mack>

A Mac?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| How would I run this code in a mack. The command button will not activate on
| the sheet

Reply to this Message

Richard - 30 Mar 2008 12:11 GMT

Private Sub CommandButton1_Click()

Worksheets("Sent to Assembly").Range("A3:B100,c3:c100").Copy
Worksheets("Parts Sent to Assembly").Range("a65000").End(xlUp).Offset(1,
0).PasteSpecial
Worksheets("Sent to Assembly").Range("a3:a100,b3:B100").ClearContents
Worksheets("Schedule").Range("d1,L1,a3:a100,b3:B100,d3:d100").ClearContents

End Sub

> Hi Richard,
>
[quoted text clipped - 8 lines]
> | How would I run this code in a mack. The command button will not activate on
> | the sheet

Reply to this Message

Dave Peterson - 29 Mar 2008 23:50 GMT

Did you try the suggestions from yesterday?

> How would I run this code in a mack. The command button will not activate on
> the sheet

Signature

Dave Peterson

Reply to this Message

Richard - 30 Mar 2008 12:13 GMT

I don't know what you mean? Is it the same as in Windows? Thanks for your help

Private Sub CommandButton1_Click()

Worksheets("Sent to Assembly").Range("A3:B100,c3:c100").Copy
Worksheets("Parts Sent to Assembly").Range("a65000").End(xlUp).Offset(1,
0).PasteSpecial
Worksheets("Sent to Assembly").Range("a3:a100,b3:B100").ClearContents
Worksheets("Schedule").Range("d1,L1,a3:a100,b3:B100,d3:d100").ClearContents

End Sub

> Did you try the suggestions from yesterday?
>
> > How would I run this code in a mack. The command button will not activate on
> > the sheet

Reply to this Message

Dave Peterson - 30 Mar 2008 12:31 GMT

Mac's don't support the objects from the control toolbox toolbar. You'll have
to replace it with a button from the Forms toolbar.

Then move the code from the worksheet to a general module. Maybe modify the
code. And assign the macro to that button.

> I don't know what you mean? Is it the same as in Windows? Thanks for your help
>
[quoted text clipped - 16 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message