Hello, Thanks for the reply. I have nearly 1000 graphical object in the work sheet. Macro is taking lot of time to get run some times it hangs also. I have a good processor & ram speed.
Could you please suggest on this. Thanks in advance. Regards, Chandra Shekar B On Fri, Mar 2, 2012 at 3:34 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>wrote: > Dear Chandra, > > You can also use.. > > Sub test() > Dim sh As Shape > For Each sh In ActiveSheet.Shapes > On Error Resume Next > sh.Hyperlink.Delete > Next > End Sub > > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > > On Fri, Mar 2, 2012 at 5:10 PM, NOORAIN ANSARI > <noorain.ans...@gmail.com>wrote: > >> Dear Chandra, >> >> Please check it >> >> >> http://www.bigresource.com/VB-remove-hyperlinks-from-graphical-objects-in-excel-sv9vpXaqEN.html#APhFEcBxqn >> >> >> On Fri, Mar 2, 2012 at 4:56 PM, Chandra Shekar < >> chandrashekarb....@gmail.com> wrote: >> >>> Hello, >>> >>> Could you please let me know how to remove hyperlinks linked to >>> graphical objects (Its nearly 1000 objects) >>> >>> Thanks in advance. >>> >>> Regards, >>> >>> Chandra Shekar B >>> >>> -- >>> FORUM RULES (986+ members already BANNED for violation) >>> >>> 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) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> >>> >>> ------------------------------------------------------------------------------------------------------ >>> To post to this group, send email to excel-macros@googlegroups.com >>> >> >> >> >> >> > > > > -- > Thanks & regards, > Noorain Ansari > ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
