Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all, i have macro in Sheet Module (see below)
Private Sub Worksheet_Change(ByVal Target As Range) If Range("K24").Value < "NOT AUTHORISED" Then Range("M4").Value = "AUTHORISED" MsgBox "THANKS FOR AUTHORISATION", vbInformation, "AUTHORISED" Range("B27").Select End If End Sub the macro above works fine but problem is that if any user go again after sheet get Authorised and do some changes in sheet the MsgBox pop up again. Is it not possible that when some one put some thing in cell "K24" the MsgBox pop up just once but if some one go againg in the sheet and do some changing doesnt matter in what cell including "K24" then MsgBox should not pop up. Please can any one have any idea that how can i stop MsgBox to appear more that one time. Please note that i dont want to protect sheet as some time user have to change things after it get Authorise. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB - ignore a msgbox prompt | Excel Discussion (Misc queries) | |||
Entering variables on Msgbox prompt | Excel Programming | |||
Msgbox prompt and tabbing | Excel Programming | |||
MsgBox Prompt w/ No "X" to close | Excel Programming | |||
msgbox prompt when user selects data from combo box | Excel Programming |