{"id":590,"date":"2023-10-21T12:39:59","date_gmt":"2023-10-21T12:39:59","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/"},"modified":"2023-12-25T10:25:32","modified_gmt":"2023-12-25T10:25:32","slug":"actualizacion-de-pantalla","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/","title":{"rendered":"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4122428460\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es la actualizaci\u00f3n de pantalla de VBA?<\/h2>\n<p> ScreenUpdating es una propiedad en VBA que puede usar para activar y desactivar la actualizaci\u00f3n de la pantalla cuando ejecuta c\u00f3digo. Puede deshabilitarlo antes de ejecutar cualquier c\u00f3digo que acelere la ejecuci\u00f3n de su c\u00f3digo y luego habilitarlo nuevamente despu\u00e9s de que el c\u00f3digo haya terminado de ejecutarse. Puede leer y escribir esta propiedad. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55686\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\" sizes=\"auto, \" srcset=\"\" alt=\"actualizaci\u00f3n de pantalla vba\" width=\"512\" height=\"332\"><\/figure>\n<\/div>\n<p> De forma predeterminada, la actualizaci\u00f3n de pantalla est\u00e1 \u00abactivada\u00bb en Excel. Cuando <a href=\"https:\/\/exceladvisor.org\/es\/ejecutar-una-macro-2\/\">ejecuta un c\u00f3digo normalmente,<\/a> se necesita mucho parpadeo si ese c\u00f3digo tarda mucho tiempo, pero si desactiva la actualizaci\u00f3n de la pantalla, tardar\u00e1 menos de lo normal en ejecutarse.<\/p>\n<h2 class=\"wp-block-heading\"> Deshabilitar la actualizaci\u00f3n de pantalla en VBA<\/h2>\n<ol type=\"1\">\n<li> Primero escriba la palabra clave \u00abAplicaci\u00f3n\u00bb.<\/li>\n<li> Despu\u00e9s de eso, toque \u201c. \u00bb para abrir la lista de propiedades y m\u00e9todos.<\/li>\n<li> Ahora seleccione \u00abActualizaci\u00f3n de pantalla\u00bb.<\/li>\n<li> Al final, especifique \u00abFalso\u00bb. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55687\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-desactiver-la-mise-a-jour-de-lecran.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"463\" height=\"180\"><\/figure>\n<\/div>\n<p> Una vez que deshabilite la actualizaci\u00f3n de la pantalla, VBA no la habilitar\u00e1 despu\u00e9s de que se ejecute el c\u00f3digo. Por lo tanto, siempre es mejor apagarlo por su parte. El c\u00f3digo ser\u00eda algo as\u00ed como a continuaci\u00f3n. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-55688\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-desactiver-la-mise-a-jour-de-lecran.png\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"477\" height=\"363\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Cosas para considerar<\/h2>\n<ul>\n<li> Aseg\u00farese de que la pantalla est\u00e9 actualizada a \u00abON\u00bb cuando utilice un formulario de usuario.<\/li>\n<li> Si est\u00e1 depurando c\u00f3digo, es mejor tener una pantalla de actualizaci\u00f3n \u00abON\u00bb para que pueda ver toda la actividad tal como est\u00e1.<\/li>\n<\/ul>\n<div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/vba\/\">\u00bfQu\u00e9 es VBA?<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltar-valores-duplicados\/\">Resalte valores duplicados usando VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/extraer-hipervinculo\/\">Extraer direcci\u00f3n de hiperv\u00ednculo (URL) VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/campo-de-entrada\/\">Cuadro de entrada en VBA<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/archivos-de-texto\/\">VBA crea y escribe en un archivo de texto<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfQu\u00e9 es la actualizaci\u00f3n de pantalla de VBA? ScreenUpdating es una propiedad en VBA que puede usar para activar y desactivar la actualizaci\u00f3n de la pantalla cuando ejecuta c\u00f3digo. Puede deshabilitarlo antes de ejecutar cualquier c\u00f3digo que acelere la ejecuci\u00f3n de su c\u00f3digo y luego habilitarlo nuevamente despu\u00e9s de que el c\u00f3digo haya terminado de [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-590","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?<\/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:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?\" \/>\n<meta property=\"og:description\" content=\"\u00bfQu\u00e9 es la actualizaci\u00f3n de pantalla de VBA? ScreenUpdating es una propiedad en VBA que puede usar para activar y desactivar la actualizaci\u00f3n de la pantalla cuando ejecuta c\u00f3digo. Puede deshabilitarlo antes de ejecutar cualquier c\u00f3digo que acelere la ejecuci\u00f3n de su c\u00f3digo y luego habilitarlo nuevamente despu\u00e9s de que el c\u00f3digo haya terminado de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:25:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\",\"name\":\"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\",\"datePublished\":\"2023-10-21T12:39:59+00:00\",\"dateModified\":\"2023-12-25T10:25:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?","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:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?","og_description":"\u00bfQu\u00e9 es la actualizaci\u00f3n de pantalla de VBA? ScreenUpdating es una propiedad en VBA que puede usar para activar y desactivar la actualizaci\u00f3n de la pantalla cuando ejecuta c\u00f3digo. Puede deshabilitarlo antes de ejecutar cualquier c\u00f3digo que acelere la ejecuci\u00f3n de su c\u00f3digo y luego habilitarlo nuevamente despu\u00e9s de que el c\u00f3digo haya terminado de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:25:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/","url":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/","name":"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png","datePublished":"2023-10-21T12:39:59+00:00","dateModified":"2023-12-25T10:25:32+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-mise-a-jour-de-lecran-vba.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/actualizacion-de-pantalla\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo habilitar y deshabilitar la actualizaci\u00f3n de pantalla en vba?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/590","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=590"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/590\/revisions"}],"predecessor-version":[{"id":1076,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/590\/revisions\/1076"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}