Re: Excel a hypertextove odkazy

• Previous message: MISHKA: "Free prog. na ICONy?"
• In reply to: Miso: "Excel a hypertextove odkazy"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Hello Miso,

21. marca 2003, 11:34:46, si napisal:


M> Zdravim konferu,
M> mozno je to jednoduche, ale ja jednoducho neviem ako na to....
M> Ako HROMADNE odstranim v Exceli (popr. i vo Worde) hypertextove odkazy?
M> Jednotlivo to odstranovat pri 500-1000 polozkach je to vcelku
M> otravne....Chce to makro, alebo nieco podobne?
M> Dakujem za pripadnu pomoc
M> SW

makro:
Sub hyperlinks()
    Cells.Select
    Selection.hyperlinks.Delete
End Sub



-- 
Zdravi,
Jani
mailto:JBystriansky@seznam.cz

• Previous message: MISHKA: "Free prog. na ICONy?"
• In reply to: Miso: "Excel a hypertextove odkazy"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.6 : 24. 03. 2003, 15:43 CET