Donna C;7058947 Wrote:
On workbook open I have a message box telling the user
what workbook they are in.
I have two questions: When they click "ok" on the message box
I want the user form to open.
The user form is basic with Yes/No boxes.
How do I code for:
When yes is clicked insert new worksheet and run module 1,
when no is clicked simply open the workbook as is for the user to
use??
Thanks in advance
Donna C.Donna it's done soemthing like this
Code:
--------------------
If MsgBox("you are in " & ActiveWorkbook.Name & " Would you like to proceed?", vbYesNo, "Workbook Confirmation") = vbYes Then
Sheets.Add
Call '''''''ENTER YOUR MACRO NAME AFTER CALL HERE!
End If
--------------------
Regards,
SImon


--
Simon Lloyd