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