validation before exit or save

P

parajf

New Member
Joined
Nov 20, 2010
Messages
25
Dear all,

please please help for below requirement

I want excel not to save unless i have A1 = 2, that means i want validation for number 2 in A1 cell before saving, if A1 <> 2 then it will give message " Data not valid" , please... please help

regards
juzar para

00971504966280
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Sort by date Sort by votes
Try in the ThisWorkbook module

Rich (BB code): 
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Sheets("Sheet1").Range("A2").Value <> 2 Then
    Cancel = True
    MsgBox "Data not valid" & vbNewLine & "File NOT saved", vbExclamation
End If
End Sub

Change Sheet1 to the name of the sheet.
 
Upvote 0
Thank you friend,

It worked very fine, below is my mobile number,

regards

juzar para


VoG said:
Try in the ThisWorkbook module

Rich (BB code): 
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If Sheets("Sheet1").Range("A2").Value <> 2 Then
    Cancel = True
    MsgBox "Data not valid" & vbNewLine & "File NOT saved", vbExclamation
End If
End Sub

Change Sheet1 to the name of the sheet.
Click to expand...
 
Upvote 0
Dear all,

I want to create more than three floating radio buttons on right side of excel sheet, it should be visible all the time and it should link me to different sheet or workbooks, I am not considering freeze

Regards

Juzar para
 
Upvote 0
You should really start a new thread for this completely different question.

Do you really need radio buttons? If you right click in the navigation arrows (bottom left) you will get a pop-up list of sheets.
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Data Validation - Significant Loss of Functionality - Error
Replies
1
Views
190
RoryA
RoryA
K
  • Question
Help with VB Code to copy workbook
Replies
0
Views
157
kizzie37
K
K
  • Question
Disabling Save button (while enabling SaveAs) NO LONGER WORKS!!! (Insert cursing emoji here)
Replies
4
Views
128
kgartin
K
Leorand
  • Question
Is it possible to make data validation using sources from another workbooks?
Replies
7
Views
174
Leorand
Leorand
S
  • Question
VBA or data validation to create a fillable form, (with multiple cells required) that must be filled in before saving
Replies
5
Views
465
WillemS
W

Forum statistics

Threads
1,214,992
Messages
6,122,631
Members
449,095
Latest member
bsb1122

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top