CorpusSpongiosum
New Member
- Joined
- Mar 8, 2002
- Messages
- 9
I have a workbook with two worksheets "Rota" and "Message Board". The "Rota" worksheet has a command button (Comman Button1) which when clicked saves the workbook, emails it to a specified destination, inactivates the command button and displays a message box indicating that the workbook has been emailed. Is it possible to include code that will re-activate the control button 1 in the event of the worksheet being re-opened. Is it also possible to include code to close the workbook upon the OK button of the message box being clicked on?
Many thanks
Craig
Many thanks
Craig