Hi,
I want a VB code when it run, Msg box appear as "Save Changes ?" if I click yes then Activeworkbook Save and if Click No then Activeworkbook Close Without Save any Changes.
Please Help.
Hi,
I want a VB code when it run, Msg box appear as "Save Changes ?" if I click yes then Activeworkbook Save and if Click No then Activeworkbook Close Without Save any Changes.
Please Help.
My English is very poor, so please be patient >_<"
Thanks & Regards.
hkbhansali
![]()
Sub Macro1() Flag = MsgBox("Save Workbook", vbYesNo) If Flag = 6 Then ActiveWorkbook.Save End If ActiveWorkbook.Close False End Sub
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hi,
mehmetcik
above code works fine
thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks