Why does this simple thing not work?
Peter,
Additional information could help to answer your question...
What version of Excel are you using?
What is the error number and text?
On what code line does the error occur?
Is the Command button on a Worksheet, Chart or a UserForm?
Making a swag, try setting the "Take Focus on Click" property of
the command button to False.
Jim Cone
San Francisco, USA
"Peter"
wrote in message
Hi,
This is a very simple thing, so i tought, but it just keeps giving an error.
Private Sub CommandButton1_Click()
'BUTTON SAVE
ActiveSheet.Range("M5").Copy
Worksheets("Historiek").Select
Range("D3").Paste
End Sub
Can anyone tell me why or what it is i'm doing wrong?
Regards,
Peter
|