{"id":1369,"date":"2025-11-30T02:51:44","date_gmt":"2025-11-30T02:51:44","guid":{"rendered":"https:\/\/growhome.vn\/?p=1369"},"modified":"2025-11-30T02:51:45","modified_gmt":"2025-11-30T02:51:45","slug":"su-dung-macro-vba-de-xoa-mau-nen-cho-tat-ca-cac-bang-tu-dong-hoa","status":"publish","type":"post","link":"https:\/\/growhome.vn\/?p=1369","title":{"rendered":"S\u1eed d\u1ee5ng Macro (VBA) \u0111\u1ec3 x\u00f3a m\u00e0u n\u1ec1n cho T\u1ea4T C\u1ea2 c\u00e1c b\u1ea3ng (T\u1ef1 \u0111\u1ed9ng h\u00f3a)"},"content":{"rendered":"
\n\t\t\t\t\t\n\t\t\t\t\t\t\"Fb-Button\"\n\t\t\t\t\t<\/a>\n\t\t\t\t<\/div>
<\/fb:like><\/div><\/div>\n

\u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p nhanh nh\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t n\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng n\u1eb1m r\u1ea3i r\u00e1c trong file Word. N\u00f3 s\u1ebd ch\u1ea1y qua t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng v\u00e0 x\u00f3a m\u00e0u n\u1ec1n c\u1ee7a ch\u00fang.<\/p>\n\n\n\n

B\u01b0\u1edbc 1: M\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA<\/h3>\n\n\n\n
    \n
  1. Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm:\u00a0Alt + F11<\/strong>\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications.<\/li>\n<\/ol>\n\n\n\n

    B\u01b0\u1edbc 2: Ch\u00e8n m\u1ed9t Module m\u1edbi<\/h3>\n\n\n\n
      \n
    1. Trong c\u1eeda s\u1ed5 VBA v\u1eeba m\u1edf, v\u00e0o menu\u00a0Insert<\/strong>\u00a0(Ch\u00e8n).<\/li>\n\n\n\n
    2. Ch\u1ecdn\u00a0Module<\/strong>. M\u1ed9t c\u1eeda s\u1ed5 so\u1ea1n th\u1ea3o tr\u1ed1ng s\u1ebd hi\u1ec7n ra.<\/li>\n<\/ol>\n\n\n\n

      B\u01b0\u1edbc 3: D\u00e1n \u0111o\u1ea1n m\u00e3 Macro<\/h3>\n\n\n\n
        \n
      1. Sao ch\u00e9p (Copy) \u0111o\u1ea1n m\u00e3 sau v\u00e0 d\u00e1n (Paste) v\u00e0o c\u1eeda s\u1ed5 Module v\u1eeba m\u1edf:<\/li>\n<\/ol>\n\n\n\n

        link t\u1ea3i m\u00e3: https:\/\/drive.google.com\/file\/d\/1ycNqfIhRZL-Ak8jjjO8GxQTzKGl9BhQw\/view?usp=sharing<\/a><\/p>\n\n\n\n

        B\u01b0\u1edbc 4: Ch\u1ea1y Macro<\/h3>\n\n\n\n
          \n
        1. Quay tr\u1edf l\u1ea1i c\u1eeda s\u1ed5 Word c\u1ee7a b\u1ea1n.<\/li>\n\n\n\n
        2. Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm:\u00a0Alt + F8<\/strong>\u00a0\u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Macro.<\/li>\n\n\n\n
        3. Trong danh s\u00e1ch Macro, t\u00ecm v\u00e0 ch\u1ecdn Macro t\u00ean l\u00e0\u00a0XoaMauNenCuaTatCaCacBang<\/strong>.<\/li>\n\n\n\n
        4. Nh\u1ea5n n\u00fat\u00a0Run (Ch\u1ea1y)<\/strong>.<\/li>\n<\/ol>\n\n\n\n

          Sau khi Macro ch\u1ea1y xong, n\u00f3 s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t th\u00f4ng b\u00e1o \u0111\u00e3 ho\u00e0n t\u1ea5t. L\u00fac n\u00e0y, to\u00e0n b\u1ed9 c\u00e1c b\u1ea3ng trong t\u00e0i li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c chuy\u1ec3n v\u1ec1 \u0111\u1ecbnh d\u1ea1ng kh\u00f4ng c\u00f3 m\u00e0u n\u1ec1n.<\/p>\n\n\n\n

          <\/p>\n","protected":false},"excerpt":{"rendered":"

          \u0110\u00e2y l\u00e0 ph\u01b0\u01a1ng ph\u00e1p nhanh nh\u1ea5t v\u00e0 hi\u1ec7u qu\u1ea3 nh\u1ea5t n\u1ebfu b\u1ea1n c\u00f3 r\u1ea5t nhi\u1ec1u b\u1ea3ng n\u1eb1m r\u1ea3i r\u00e1c trong file Word. N\u00f3 s\u1ebd ch\u1ea1y qua t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng v\u00e0 x\u00f3a m\u00e0u n\u1ec1n c\u1ee7a ch\u00fang. B\u01b0\u1edbc 1: M\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA B\u01b0\u1edbc 2: Ch\u00e8n m\u1ed9t Module m\u1edbi B\u01b0\u1edbc 3: D\u00e1n \u0111o\u1ea1n m\u00e3 Macro…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-1369","post","type-post","status-publish","format-standard","hentry","category-meo-xu-ly-van-ban-word"],"_links":{"self":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1369","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1369"}],"version-history":[{"count":1,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1369\/revisions"}],"predecessor-version":[{"id":1370,"href":"https:\/\/growhome.vn\/index.php?rest_route=\/wp\/v2\/posts\/1369\/revisions\/1370"}],"wp:attachment":[{"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/growhome.vn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}