Is it just me? In NT I add two buttons to an Excel 2000 spreadsheet and the VB Code below. Open up task manager and alternately click on the buttons and the memory usage increments by 8K when you click and another 4K when you move the pointer off the button. It also uses up 4 handles every click. I tried the same thing in Excel 97 and its even worse. Am I doing something wrong?
Private Sub CommandButton1_Click()
CommandButton1.Enabled = False
CommandButton2.Enabled = True
End Sub
Private Sub CommandButton2_Click()
CommandButton1.Enabled = True
CommandButton2.Enabled = False
End Sub
Private Sub CommandButton1_Click()
CommandButton1.Enabled = False
CommandButton2.Enabled = True
End Sub
Private Sub CommandButton2_Click()
CommandButton1.Enabled = True
CommandButton2.Enabled = False
End Sub