I know I'm late to the party, but here's my thoughts:
It sounds like you have multiple sheets and you have the same macro
"worksheet macro? event macro?"
in each sheet module.
Sometimes this happens when you have a macro in a sheet module and then
copy the worksheet multiple times.
Each macro is "private" and only available to the sheet where it resides.
now you want to change the macro, but need it to be reflected in each
sheet module.
I ran into this early in my programming career.
My workbooks soon became large and difficult to manage, especially when I
made "improvements" to the macro.
What I did instead is move the macro to a "standard" module.
Then, changed each SHEET macro to call the one in the "standard" module.
I even "standardized" the macro names.
the macro called by the sheet change events was called WS_Change
Now, to update the macro only requires making changes to the macro in the
"standard" module.
Paul
On Friday, October 23, 2015 at 1:30:29 AM UTC-4, Pravin Gunjal wrote:
> Hi Friend
> pl help me out to replace a macro in all sheets of the same file. Or any
> other solution may welcome.
> Thanks
> Pravin Gunjal
> On Oct 22, 2015 1:09 PM, "Pravin Gunjal" <isk...@gmail.com <javascript:>>
> wrote:
>
>> Can anyone help me on this issue plz.
>> On Oct 21, 2015 3:26 PM, "Pravin Gunjal" <isk...@gmail.com <javascript:>>
>> wrote:
>>
>>> Hi Mandeep
>>>
>>> The code you have replaced in this mail has to be replaced in other
>>> sheets also of the same file.. file is attached for your immediate
>>> reference.
>>>
>>> Pl help me out on this.
>>>
>>> Thanks,
>>> Pravin Gunjal.
>>>
>>> On Oct 20, 2015 4:35 PM, "Mandeep Baluja" <
>>>
>>>
>>> rocke...@gmail.com <javascript:>> wrote:
>>>
>>>> Hi Praveen,
>>>>
>>>> Welcome,I am sorry but Please elaborate your query Modify in what sense
>>>> and for all sheets means you have the same code in all sheets what kind of
>>>> modification you're looking for whether it is automated or it is manual.
>>>>
>>>> Regards,
>>>> Mandeep Baluja
>>>>
>>>>
>>>>
>>>> On Tuesday, October 20, 2015 at 4:20:14 PM UTC+5:30, Pravin Gunjal
>>>> wrote:
>>>>>
>>>>> Dear Mandeep
>>>>> Thank you so much.. it works fantastic.
>>>>>
>>>>> Can you tell me one more thing, how to modify the vba code in all
>>>>> sheets...
>>>>>
>>>>> Regards,
>>>>> Pravin Gunjal.
>>>>> On Oct 20, 2015 2:47 PM, "Mandeep Baluja" <rocke...@gmail.com> wrote:
>>>>>
>>>>>> check this out !!
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> Private Sub Worksheet_Change(ByVal Target As Excel.Range)
>>>>>>
>>>>>> If Not Application.Intersect(Target, Range("n4:n100")) Is Nothing
>>>>>> Then
>>>>>> For Each cell In Target
>>>>>> If cell.Value <> "" Then
>>>>>> cell.Offset(0, 1).Value = Application.UserName
>>>>>> End If
>>>>>> Next
>>>>>> End If
>>>>>>
>>>>>> End Sub
>>>>>>
>>>>>> Regards,
>>>>>> Mandeep baluja
>>>>>> https://www.facebook.com/groups/825221420889809/
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>>>> https://www.facebook.com/discussexcel
>>>>>>
>>>>>> FORUM RULES
>>>>>>
>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to a topic in
>>>>>> the Google Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To unsubscribe from this topic, visit
>>>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe
>>>>>> .
>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>> excel-macros...@googlegroups.com.
>>>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/discussexcel
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to a topic in the
>>>> Google Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this topic, visit
>>>> https://groups.google.com/d/topic/excel-macros/IAYAJFr4fQ8/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> excel-macros...@googlegroups.com <javascript:>.
>>>> To post to this group, send email to excel-...@googlegroups.com
>>>> <javascript:>.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
