Hi, I have a macro called create_report
I would like to insert this in a command button. I want the comman
button to only be clicked once when the sheet is open, and it should b
disabled afterwards. So, if the sheet is closed and reopened, th
button should work once and then be disabled. I have the following
it's not making my button work at all:

Private Sub CommandButton1_Click()
Create_Report
CommandButton1.Enabled = False
End Sub


Please help.


richard

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