RE: $$Excel-Macros$$ Object Hyperlin : Deletion

/2012 04:57 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Object Hyperlin : Deletion 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

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

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

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

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/* On

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

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 wrote: > Hello, > > Could you please let me know how to remove hyperlinks linked to graphical > objects (Its n

$$Excel-Macros$$ Object Hyperlin : Deletion

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 H