I created a userform called frmLeaveRequest that I want to start whe
the user double clicks on the excel file


Code
-------------------

Private Sub Workbook_Open()
frmLeaveRequest.Show
End Sub

-------------------


I don't want the worksheet to be visible to the user, just th
userform
How can I do this?

I also want to close the active workbook and Excel if there are n
other active workbook. What else do I have to and to this code t
accomplish this??


Code
-------------------

Private Sub cmdExit_Click()
ActiveWorkbook.Close
End Sub

-------------------

--
cedtech2
-----------------------------------------------------------------------
cedtech23's Profile: http://www.excelforum.com/member.php...fo&userid=3102
View this thread: http://www.excelforum.com/showthread.php?threadid=56333