-- Forwarded message --
From: vidyut more
Date: Thu, Jul 22, 2010 at 6:45 PM
Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
To: excel-macros@googlegroups.com
Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then
unprotect the sheet. The sheet will reprotect after any change.
> As for multiple selections, why do you need it?
> Regards - Dave.
>
> --
> Date: Thu, 22 Jul 2010 20:09:26 +0530
>
> Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
> F
+0530
Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
From: sudhir.p...@gmail.com
To: excel-macros@googlegroups.com
CC: davebonall...@hotmail.com
in addition of this macro,there is one more thing , if i want to edit one of my
cell, and want to allow multiple secletion, then how it
gt;
>
>
> On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack > wrote:
>
>> You're welcome.
>> Dave.
>>
>> > From: vidyutm...@gmail.com
>> > Date: Thu, 22 Jul 2010 17:42:58 +0530
>> > Subject: Re: $$Excel-Macros$$ RE: Need macro for a
Dear Dave Bonallack sir thanks for sharing this important macro
On Thu, Jul 22, 2010 at 6:29 PM, Dave Bonallack
wrote:
> You're welcome.
> Dave.
>
> > From: vidyutm...@gmail.com
> > Date: Thu, 22 Jul 2010 17:42:58 +0530
> > Subject: Re: $$Excel-Macros$$
Sir i stuck in your macro. 1 ) filter is not working 2) I have
usecanother macro for that sheet then where should i put ur macro. my
macro as follows
'Private Sub Worksheet_Change(ByVal Target As Range)
Dim Cell As Range
Dim pcNum As Long
Dim party As String
Dim prod As String
Dim ws As Worksheet
You're welcome.Dave.
> From: vidyutm...@gmail.com
> Date: Thu, 22 Jul 2010 17:42:58 +0530
> Subject: Re: $$Excel-Macros$$ RE: Need macro for attd workbook
> To: excel-macros@googlegroups.com
>
> Thank you so much sir "Dave Bonallack". Its what i was looking for.
Thank you so much sir "Dave Bonallack". Its what i was looking for. Thanks again
On Thu, Jul 22, 2010 at 5:37 PM, Dave Bonallack
wrote:
> Hi,
> Have a look at the attached.
> The macro prevents the selection of multiple cells.
> If the selected cell contains data, it will be locked.
> If the sele
Hi,
Have a look at the attached.
The macro prevents the selection of multiple cells.
If the selected cell contains data, it will be locked.
If the selected cell is blank, it will be unlocked.
Once a blank cell is edited, it will be locked automatically.
The protection is not password protect
