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
