RE: $$Excel-Macros$$ Plz do the needfull

2011-11-11 Thread Asa Rossoff
.com] On Behalf Of Anil Saxena Sent: Thursday, November 10, 2011 11:32 PM To: Dilip Pandey Cc: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Plz do the needfull Hi All, How can we remove the hyperlink only short key not formula. -- FORUM RULES (934+ members already BANNED for v

Re: $$Excel-Macros$$ Plz do the needfull

2011-11-10 Thread ashish koul
Sub removehyperlinks() Selection.Hyperlinks.Delete End Sub or type 0 in any blank cell then copy the cell select the data with hyperlinks right click ->paste specia -> multiple and click on ok On Fri, Nov 11, 2011 at 1:01 PM, Anil Saxena wrote: > Hi All, > How can we remove the hyperlink

$$Excel-Macros$$ Plz do the needfull

2011-11-10 Thread Anil Saxena
Hi All, How can we remove the hyperlink only short key not formula. -- FORUM RULES (934+ 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 atte