$$Excel-Macros$$ COPY CODE FROM WORKBOOK THAT IS LOCKED

2010-10-04 Thread sudheer lolla
Hi IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS PROBLEMTHE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO DO IT?? 1..Running a particular code from .XLSB file 2..This .XLSB file is locked and i know the password also.3..Code which is in this locked .XLSB

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

2010-10-04 Thread sudheer lolla
HI PAUL THANKS FOR YOUR QUICK REPLY I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER SAVES IT OR NOT)WITH MACROS IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS IN "This Workbook" OF THE .XLSX FILE MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB I

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

2010-10-04 Thread sudheer lolla
ll in one protected workbook (both the workbook and VBA project are > password protected) > I run the macros which open 15 other files and operate on each one. > At no time do I copy modules into these files. > > what is the requirement that makes it necessary to have the macro >

$$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-08 Thread sudheer lolla
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

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-09 Thread sudheer lolla
> 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 the column number in sheet A is 1 ,sheet B is 2,sheet C is 1 >> >&g

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-10 Thread sudheer lolla
arget.Value > Sheets("C").Cells(Target.Row, 1) = Target.Value > End If > End If >End If > End Sub > > > > kindest regards, > siti Vi > jakarta > > > > * > On Fri, Oct 8, 2010 at 8:10 PM, sudheer lolla wrote: > >> Hi

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-12 Thread sudheer lolla
e*) > 0 Then > rC = .Match(*DelValue*, Sheets("C").Range("A:A"), 0) > Sheets("C").Cells(*rC*, 1) = ClearContents >End If > End With > End If > End If >End If > End Sub > >

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-13 Thread sudheer lolla
rolButton)* * With myCommandBarCtl* * .Caption = "Only one applicable"* * .Style = msoButtonCaption* * .TooltipText = "Only one applicable)"* * .OnAction = " Only one applicableSUB"* * End With* On Tue, Oct 12, 2010 at 3:33 PM, sudheer lolla wro

$$Excel-Macros$$ XLSB and XLSX related problem

2010-10-13 Thread sudheer lolla
Hi This is a very peculiar problem which am facing i have an *xlsb* which has some macros and is placed in *XLSTART* folder when an excel is opened the *XLSB* is attached to the *XLSX* file i*am saying attached because when any other excel is opened,XL is popping up message saying "XYZ.xlsb is

Re: $$Excel-Macros$$ DELETE OF A VALUE DELTES THAT FROM EVERY SHEET

2010-10-13 Thread sudheer lolla
> > 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

Re: $$Excel-Macros$$ XLSB and XLSX related problem

2010-10-13 Thread sudheer lolla
age > box causes the file to be opened TWICE! > (I found it in opening some LARGE files with EXTENSIVE macros) > > the trick I found is that you need to make an entry in the > DDE Application Not Running box: > [Rem Comment] > > this is a non-executable comment, so it doesn&

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

2010-10-24 Thread sudheer lolla
Hi Theres no one who can help me out...Please guys Regards SUDHEER On Fri, Oct 22, 2010 at 12:17 PM, sudheer lolla wrote: > Hi Paul > > > As i told that "I WILL BE SENDING THE .AVI FILE OF MY QUERY" .since the > screen capture software is not available with me am

$$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

2010-10-26 Thread sudheer lolla
-- Forwarded message -- From: sudheer lolla Date: Mon, Oct 25, 2010 at 10:42 AM Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE To: Paul Schreiner , MS EXCEL AND VBA MACROS < excel-macros@googlegroups.com> Hi Theres no one who can help me out...Pleas

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

2010-11-02 Thread sudheer lolla
HI GUYS...JUST WANT TO KNOW WHETHER THIS IS POSSIBLE TO DO OR NOT. On Tue, Oct 26, 2010 at 5:09 PM, sudheer lolla wrote: > > > -- Forwarded message -- > From: sudheer lolla > Date: Mon, Oct 25, 2010 at 10:42 AM > Subject: Re: $$Excel-Macros$$ COPY MODULES