Hi Gene:

I tried all 3 points. the applications.enableevents= true
My code was saved, and it was saved in sheet2, because my button is in
sheet 2. so I changed the thisworkbook code from:

Private Sub Workbook_Open()
Sheet1.CommandButton1.Enabled = True
End Sub

to

Private Sub Workbook_Open()
Sheet2.CommandButton1.Enabled = True
End Sub

But it's still not activating the button. I also changed the "code
name", same thing.

I don't mind taking a look at the macro you set up. Please send it to:


Thanks.

Richardo


---
Message posted from http://www.ExcelForum.com/