l sheets except the new one, which should
be hidden.
Regards - Dave.
Date: Tue, 27 Apr 2010 13:10:16 +0800
Subject: Re: $$Excel-Macros$$ worksheet change event problem
From: osav...@gmail.com
To: excel-macros@googlegroups.com
Thank you Dave,
The code you suggested worked fine. Although i disc
Change the sheet name to suit.
> Regards - Dave.
>
> ------
> Date: Mon, 26 Apr 2010 16:30:04 +0800
> Subject: $$Excel-Macros$$ worksheet change event problem
> From: osav...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Dear group,
>
&
Exclamation
MsgBox "Please contact EDP "
ThisWorkbook.Close savechanges:=False
End If
End Sub
Change the sheet name to suit.
Regards - Dave.
Date: Mon, 26 Apr 2010 16:30:04 +0800
Subject: $$Excel-Macros$$ worksheet change event problem
From: osav...@gmail.com
To: excel-
Dear group,
i try to catch the user's action via worksheet change event. My worksheet
has a value at cell D6 that i would like to remain constant and if that
value is change by user the workbook is closed.
My problem now is, even if this values are unchanged but if any other range
of cell is del
