{"id":2194,"date":"2015-01-16T17:19:49","date_gmt":"2015-01-16T22:19:49","guid":{"rendered":"https:\/\/www.cavsi.com\/blog\/?p=2194"},"modified":"2015-01-16T17:19:49","modified_gmt":"2015-01-16T22:19:49","slug":"eliminar-todos-los-hipervinculos-en-una-hoja-excel","status":"publish","type":"post","link":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/","title":{"rendered":"Eliminar todos los hiperv\u00ednculos en una hoja Excel"},"content":{"rendered":"

Para eliminar todos los hiperv\u00ednculos en una hoja en Excel sin tener que editar celda por celda, deber\u00e1s escribir una macro sencilla utilizando el editor de Aplicaciones Visual Basic (VBA) El objetivo de crear una macro es eliminar r\u00e1pidamente los hiperv\u00ednculo que contiene la hoja de trabajo Excel, con esto evitamos tener que seleccionar uno a uno los objetos o celdas y quitar manualmente los hiperv\u00ednculos.<\/p>\n

\"insertar<\/p>\n

Pasos para crear macro que elimine todos los hiperv\u00ednculos en\u00a0Excel:<\/p>\n

    \n
  1. Abre la hoja de c\u00e1lculo Excel que contiene los hiperv\u00ednculos que deseas eliminar.<\/li>\n
  2. Presiona al mismo tiempo las teclas [Alt] [F11]<\/strong> para ir al editor de Visual Basic.<\/li>\n
  3. Crea un nuevo m\u00f3dulo. Puede hacer esto mediante en la selecci\u00f3n de m\u00f3dulo en el men\u00fa Insertar.<\/li>\n
  4. Pega el siguiente c\u00f3digo en m\u00f3dulo creado anteriormente<\/li>\n<\/ol>\n

    Sub QuitarVinculos()<\/strong><\/p>\n

    \u00a0\u00a0 ‘Remover todos los hipervinculos de la hoja de trabajo<\/strong><\/p>\n

    \u00a0\u00a0 ActiveSheet.Hyperlinks.Delete<\/strong><\/p>\n

    End Sub<\/strong><\/p><\/blockquote>\n

      \n
    1. Cierra la ventana del editor de Visual Basic mediante la opci\u00f3n “Cerrar y volver a Microsoft Excel” del men\u00fa Archivo.<\/li>\n
    2. Ahora, ve a la hoja que contiene los hiperv\u00ednculos que desea eliminar.<\/li>\n
    3. En el men\u00fa Herramientas, selecciona\u00a0Macro> Macros<\/strong>.<\/li>\n
    4. Aparecer\u00e1\u00a0la\u00a0ventana “Macro”, selecciona la macro creada anteriormente”QuitarVinculos” y haz clic en el bot\u00f3n <Ejecutar><\/strong><\/li>\n<\/ol>\n

       <\/p>\n

      Ahora los hiperv\u00ednculos se habr\u00e1n eliminado y solo quedara el texto que se mostraba como referencia. Si necesitas quitar hiperv\u00ednculos de otras hojas, simplemente repite los pasos anteriores.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Para eliminar todos los hiperv\u00ednculos en una hoja en Excel sin tener que editar celda por celda, deber\u00e1s escribir una macro sencilla utilizando el editor de Aplicaciones Visual Basic (VBA) El objetivo de crear una macro es eliminar r\u00e1pidamente los hiperv\u00ednculo que contiene la hoja de trabajo Excel, con esto evitamos tener que seleccionar uno a uno los objetos o celdas y quitar manualmente los hiperv\u00ednculos.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","footnotes":""},"categories":[189],"tags":[247],"class_list":["post-2194","post","type-post","status-publish","format-standard","hentry","category-excel","tag-hipervinculo-excel"],"yoast_head":"\nEliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Eliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI\" \/>\n<meta property=\"og:description\" content=\"Para eliminar todos los hiperv\u00ednculos en una hoja en Excel sin tener que editar celda por celda, deber\u00e1s escribir una macro sencilla utilizando el editor de Aplicaciones Visual Basic (VBA) El objetivo de crear una macro es eliminar r\u00e1pidamente los hiperv\u00ednculo que contiene la hoja de trabajo Excel, con esto evitamos tener que seleccionar uno a uno los objetos o celdas y quitar manualmente los hiperv\u00ednculos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"CAVSI\" \/>\n<meta property=\"article:published_time\" content=\"2015-01-16T22:19:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\"},\"headline\":\"Eliminar todos los hiperv\u00ednculos en una hoja Excel\",\"datePublished\":\"2015-01-16T22:19:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\"},\"wordCount\":262,\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg\",\"keywords\":[\"Hipervinculo Excel\"],\"articleSection\":[\"Microsoft Excel\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\",\"name\":\"Eliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI\",\"isPartOf\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg\",\"datePublished\":\"2015-01-16T22:19:49+00:00\",\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg\"},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#website\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"name\":\"CAVSI\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#organization\",\"name\":\"CAVSI\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"contentUrl\":\"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png\",\"width\":300,\"height\":70,\"caption\":\"CAVSI\"},\"image\":{\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/www.cavsi.com\/espanol\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Eliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Eliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI","og_description":"Para eliminar todos los hiperv\u00ednculos en una hoja en Excel sin tener que editar celda por celda, deber\u00e1s escribir una macro sencilla utilizando el editor de Aplicaciones Visual Basic (VBA) El objetivo de crear una macro es eliminar r\u00e1pidamente los hiperv\u00ednculo que contiene la hoja de trabajo Excel, con esto evitamos tener que seleccionar uno a uno los objetos o celdas y quitar manualmente los hiperv\u00ednculos.","og_url":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/","og_site_name":"CAVSI","article_published_time":"2015-01-16T22:19:49+00:00","og_image":[{"url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#article","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/"},"author":{"name":"admin","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff"},"headline":"Eliminar todos los hiperv\u00ednculos en una hoja Excel","datePublished":"2015-01-16T22:19:49+00:00","mainEntityOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/"},"wordCount":262,"publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg","keywords":["Hipervinculo Excel"],"articleSection":["Microsoft Excel"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/","url":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/","name":"Eliminar todos los hiperv\u00ednculos en una hoja Excel - CAVSI","isPartOf":{"@id":"https:\/\/www.cavsi.com\/espanol\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg","datePublished":"2015-01-16T22:19:49+00:00","inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/blog\/eliminar-todos-los-hipervinculos-en-una-hoja-excel\/#primaryimage","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/excel\/hipervinculos\/macro-eliminar-hipervinculos.jpg"},{"@type":"WebSite","@id":"https:\/\/www.cavsi.com\/espanol\/#website","url":"https:\/\/www.cavsi.com\/espanol\/","name":"CAVSI","description":"","publisher":{"@id":"https:\/\/www.cavsi.com\/espanol\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.cavsi.com\/espanol\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.cavsi.com\/espanol\/#organization","name":"CAVSI","url":"https:\/\/www.cavsi.com\/espanol\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/","url":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","contentUrl":"https:\/\/www.cavsi.com\/espanol\/wp-content\/uploads\/cavsi-logo.png","width":300,"height":70,"caption":"CAVSI"},"image":{"@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/57c63c4dea5ec4e8bf85058874df52ff","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.cavsi.com\/espanol\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/38f97bae72bd8d118f2ee7ee4d212c7aa72f5943f65b507ca8ff646774bed2bc?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/www.cavsi.com\/espanol"]}]}},"_links":{"self":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/2194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/comments?post=2194"}],"version-history":[{"count":0,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/posts\/2194\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/media?parent=2194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/categories?post=2194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cavsi.com\/espanol\/wp-json\/wp\/v2\/tags?post=2194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}