Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default Settings for a New Worksheet | Excel Discussion (Misc queries) | |||
Making a worksheet default | Excel Discussion (Misc queries) | |||
How To Open First Worksheet By Default? | Excel Discussion (Misc queries) | |||
default excel worksheet | Excel Discussion (Misc queries) | |||
Trying to set default Worksheet file name from C++/MFC | Excel Programming |