View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default 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