>
> is this a new query?
>
> Paul
>
>
> *From:* sudheer lolla
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, October 13, 2010 7:00:18 AM
>
> *Subject:* Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY
> SHEET
>
> *Hi *
> *
> *
&g
How is this related to "Delete of a value Deltes that from every sheet" ??
is this a new query?
Paul
>
>From: sudheer lolla
>To: excel-macros@googlegroups.com
>Sent: Wed, October 13, 2010 7:00:18 AM
>Subject: Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM E
*Hi *
*
*
*I have developed a custom button with name "Only one applicable".After user
clicks that it does some functions.*
*i want this button to be disabled later.*
*
*
*AT ANY TIME USER SHOULD BE ABLE TO CLICK THAT BUTTON ONLY ONCE.LATER THAT
HAS BE GRAYED OUT.*
*
*
*HOW CAN THAT BE DONE I USED
Hi Siti Vi
*Superbly codedThat was excellent..full praise you*
Thanks for excellent reply
Regards
L SUDHEER
On Tue, Oct 12, 2010 at 7:02 AM, siti Vi wrote:
> Hi Lolla,
> check this code
>
> - the VBA code -
> Dim *DelValue*
>
> Private Sub Works
*Hi siti Vi*
*
*
*Thanks for your reply .That was efficient*
*
*
*But i had a problem the order of the values may not be the same in all
sheets*
*
*
*for example:if "17" is in row 17 in sheet "A" it may be in row 20 in sheet
"B"*
*Your code works effectively if the order is same.You are comparing w
How to do that progamatically using VBA...
On 10/8/10, krishna mummina wrote:
>
> Hey Dude,
>
>
> Do this,
>
>
> Select the Cell which you want to delete and Ctrl+Select Every Sheet, then
> press Delete.
>
>
> I hope it will helpful.
>
>
> Regards,
> Krrish
>
>
> On Fri, Oct 8, 2010 at 6:40 PM, s
Hey Dude,
Do this,
Select the Cell which you want to delete and Ctrl+Select Every Sheet, then
press Delete.
I hope it will helpful.
Regards,
Krrish
On Fri, Oct 8, 2010 at 6:40 PM, sudheer lolla wrote:
> Hi guys
>
> I Have a column "xyz" which is there in every sheet of the workbook
> and th
Hi guys
I Have a column "xyz" which is there in every sheet of the workbook
and the column number in sheet A is 1 ,sheet B is 2,sheet C is 1
If i delete a value from that column "xyz" in sheet A,the deleted cell has
to be deleted from these B,C sheets
But the vice-versa should not happen i.e Del
