{"id":6330,"date":"2024-12-21T15:04:25","date_gmt":"2024-12-21T15:04:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/go-bao-ve-nhieu-trang-tinh-cung-luc-trong-excel\/"},"modified":"2024-12-21T15:04:25","modified_gmt":"2024-12-21T15:04:25","slug":"go-bao-ve-nhieu-trang-tinh-cung-luc-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/go-bao-ve-nhieu-trang-tinh-cung-luc-trong-excel\/","title":{"rendered":"G\u1ee1 b\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh c\u00f9ng l\u00fac trong Excel"},"content":{"rendered":"
\n

N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a nhi\u1ec1u trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 v\u1edbi c\u00f9ng m\u1ed9t m\u1eadt kh\u1ea9u, v\u00e0 b\u1ea1n c\u1ea7n g\u1ee1 b\u1ea3o v\u1ec7 \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng m\u1ed9t v\u00e0i th\u00f4ng tin. B\u1ea1n c\u00f3 th\u1ec3 g\u1ee1 b\u1ea3o v\u1ec7 t\u1eebng trang t\u00ednh m\u1ed9t b\u1eb1ng\u00a0Unprotect Sheet<\/strong><\/em>, nh\u01b0ng n\u1ebfu c\u00f3 nhi\u1ec1u trang t\u00ednh, c\u00e1ch n\u00e0y kh\u00e1 t\u1ed1n th\u1eddi gian. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n m\u1ed9t v\u00e0i c\u00e1ch nhanh ch\u00f3ng g\u1ee1 b\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh c\u00f9ng l\u00fac.<\/p>\n

G\u1ee1 b\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh c\u00f9ng l\u00fac b\u1eb1ng VBA Code<\/a><\/strong><\/h1>\n

N\u1ebfu b\u1ea1n gi\u1ecfi m\u00e3 VBA<\/a>, \u0111o\u1ea1n m\u00e3 d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n g\u1ee1 b\u1ea3o v\u1ec7 c\u00e1c trang t\u00ednh m\u1ed9t c\u00e1ch nhanh ch\u00f3ng.<\/p>\n

1. Nh\u1ea5n gi\u1eef\u00a0Alt + F11<\/strong><\/em>, c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications<\/strong><\/em>\u00a0m\u1edf ra.<\/p>\n

2. Nh\u1ea5n ch\u1ecdn Insert > Module<\/strong><\/em>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5\u00a0Module<\/strong><\/em>.<\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
<\/div>\n
<\/div>\n
3. Nh\u1ea5n\u00a0F5<\/strong><\/em> \u0111\u1ec3 ch\u1ea1y m\u00e3, nh\u1eadp m\u1eadt kh\u1ea9u (nh\u1edb r\u1eb1ng c\u00e1c trang t\u00ednh c\u1ea7n m\u1edf kh\u00f3a c\u00f3 c\u00f9ng m\u1ed9t m\u1eadt kh\u1ea9u).<\/div>\n
\"doc-unprotect-sheets1\"\"doc-unprotect-sheets1\"<\/div>\n
4. Nh\u1ea5n Ok, c\u00e1c trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c g\u1ee1 b\u1ea3o v\u1ec7 c\u00f9ng l\u00fac.<\/div>\n
<\/div>\n<\/div>\n
\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

N\u1ebfu b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh ch\u1ee9a nhi\u1ec1u trang t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 v\u1edbi c\u00f9ng..<\/p>\n","protected":false},"author":1,"featured_media":6331,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=6330"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6331"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}