{"id":6613,"date":"2024-12-21T15:43:18","date_gmt":"2024-12-21T15:43:18","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thiet-lap-bao-ve-nhieu-trang-tinh-mot-lan-trong-excel\/"},"modified":"2024-12-21T15:43:18","modified_gmt":"2024-12-21T15:43:18","slug":"cach-thiet-lap-bao-ve-nhieu-trang-tinh-mot-lan-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-thiet-lap-bao-ve-nhieu-trang-tinh-mot-lan-trong-excel\/","title":{"rendered":"C\u00e1ch thi\u1ebft l\u1eadp b\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh m\u1ed9t l\u1ea7n trong Excel"},"content":{"rendered":"
\n

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi nhi\u1ec1u trang t\u00ednh, v\u00e0 b\u1ea1n c\u1ea7n b\u1ea3o v\u1ec7 t\u1ea5t c\u1ea3 ho\u1eb7c m\u1ed9t s\u1ed1 trang t\u00ednh. Trong Excel, th\u00f4ng th\u01b0\u1eddng b\u1ea1n c\u00f3 th\u1ec3 thi\u1ebft l\u1eadp b\u1ea3o v\u1ec7 cho t\u1eebng trang m\u1ed9t v\u1edbi ch\u1ee9c n\u0103ng Protect Sheet, nh\u01b0ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y g\u00e2y m\u1ea5t th\u1eddi gian n\u1ebfu c\u00f3 nhi\u1ec1u trang t\u00ednh. Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng.<\/p>\n

B\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh m\u1ed9t l\u00fac b\u1eb1ng m\u00e3 VBA<\/strong><\/p>\n

V\u1edbi m\u00e3 VBA, b\u1ea1n c\u00f3 th\u1ec3 c\u00f9ng l\u00fac b\u1ea3o v\u1ec7 nhi\u1ec1u trang t\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh \u0111ang m\u1edf v\u1edbi c\u00f9ng m\u1ed9t password. H\u00e3y l\u00e0m nh\u01b0 sau:<\/p>\n

1. Gi\u1eef ALT+F11<\/strong>, \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Microsoft Visual Basic for Applications<\/strong>.<\/p>\n

2. B\u1ea5m Insert<\/strong> > Module<\/strong>, d\u00e1n \u0111o\u1ea1n m\u00e3 sau v\u00e0o c\u1eeda s\u1ed5 Module<\/strong><\/p>\n<\/p>\n

View the code on Gist<\/a>.<\/div>\n
\n
<\/div>\n
3. Nh\u1ea5n F5 \u0111\u1ec3 ch\u1ea1y m\u00e3, nh\u1eadp password \u0111\u1ec3 kh\u00f3a trang t\u00ednh trong h\u1ed9p tho\u1ea1i nh\u01b0 h\u00ecnh:<\/div>\n
\"doc-protect-multiple-sheets1-1\"\"doc-protect-multiple-sheets1-1\"<\/div>\n
4. Nh\u1ea5n OK v\u00e0 x\u00e1c nh\u1eadn l\u1ea1i password<\/div>\n
\"doc-protect-multiple-sheets2-2\"\"doc-protect-multiple-sheets2-2\"<\/div>\n
5. Nh\u1ea5n OK. V\u1eady l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 b\u1edfi c\u00f9ng m\u1ed9t password.<\/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":"

Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh v\u1edbi nhi\u1ec1u trang t\u00ednh, v\u00e0 b\u1ea1n c\u1ea7n b\u1ea3o..<\/p>\n","protected":false},"author":1,"featured_media":6614,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-6613","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\/6613","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=6613"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6613\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6614"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}