Frankie needs HELP
New Member
- Joined
- Apr 3, 2002
- Messages
- 43
I need to produce a message box containing two buttons (Yes and No.
When you click on the Yes I need to make my spreatsheet ("Analysis") move to a new workbook and the user prompted to enter a filename where the workbook should be saved, including allowing saving to a different folder or drive. It should also automatically close the macro down.
If No is clicked, the macro should simply terminate, and leave the worksheets visable.
HELP!!!
When you click on the Yes I need to make my spreatsheet ("Analysis") move to a new workbook and the user prompted to enter a filename where the workbook should be saved, including allowing saving to a different folder or drive. It should also automatically close the macro down.
If No is clicked, the macro should simply terminate, and leave the worksheets visable.
HELP!!!