Dear Navneet,
Please do not post your questions in other topics in discussion and
create a new post going forward as per the group policy. You have
posted a query in "Macro to Sort" topic.
This is definitely possible to prevent excel from saving if some
condition is not met. You need to write code in ThisWorkbook object
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Sheets(1).Range("A1") = "" Then
MsgBox "Please fill the value in Cell A1"
Cancel = True
End If
End Sub
Hope it helps. Let us know of any further assistance is required.
Best Regards,
Ayush Jain
Microsoft MVP 2010.
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
