Excel warning when save worksheet.

[Jack40]

Hi all,


i have a excel template for accounting function. i have to tally the some of cells.

can we set, if Cell A1 = change as "false", then a warning option have to display whenever we give save that workbook?

Regards

Jack

[bonny24tycoon]

Hi Mate,

Welcome to the forum..

Here you go.. Add the below code as a private sub on your workbook sheet like below - ( To add a private sub - ALT+F11 ---->> Click on sheet names on left hand side of the window i.e. Sheet1 or Sheet2 and paste below code on right hand window)

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim KeyCells As Range

    ' The variable KeyCells contains the cells that will
    ' cause an alert when they are changed.
    Set KeyCells = Range("A1")
    
    If KeyCells = "False" Then
      
        MsgBox "Cell " & Target.Address & " has changed to FALSE."
       
    End If
End Sub

You would then need to enable macros.. And You should be fine

[Jack40]

Hi Boony,


It working find thanks for your help... ( Am little scared, when i saw you location )

Regards

Jack

[bonny24tycoon]

Thats great I have you query resolved..

Haha.. No worries mate.. I'm from India too..