View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pt pt is offline
external usenet poster
 
Posts: 2
Default the default worksheet

hi,all:
I face a problem, I have a button control in worksheet 2,
and the code as below:

Private Sub CommandButton1_Click()
Worksheets(1).Activate
Cells(1, 1).Value = "kk"
End Sub

and It seems that worksheet 1 is activated ,but kk is
set at the worksheet 2's cell (1,1) not at the worksheet 1.
It seems that the defaultworksheet is not the active worksheet.
It is so strange. Why it is so?

many thanks,
PanTao