{"id":34,"date":"2025-09-07T16:32:49","date_gmt":"2025-09-07T09:32:49","guid":{"rendered":"https:\/\/teencode.vip\/blog\/?p=34"},"modified":"2025-09-07T16:33:16","modified_gmt":"2025-09-07T09:33:16","slug":"cach-xoa-mo-khoa-mat-khau-vba-tren-excel","status":"publish","type":"post","link":"https:\/\/teencode.vip\/blog\/cach-xoa-mo-khoa-mat-khau-vba-tren-excel\/","title":{"rendered":"C\u00e1ch x\u00f3a, m\u1edf kh\u00f3a m\u1eadt kh\u1ea9u VBA tr\u00ean Excel"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;34&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;C\u00e1ch x\u00f3a, m\u1edf kh\u00f3a m\u1eadt kh\u1ea9u VBA tr\u00ean Excel&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n\n<ul class=\"wp-block-list\">\n<li>M\u1edf t\u1ec7p xls b\u1eb1ng tr\u00ecnh so\u1ea1n th\u1ea3o hex. (v\u00ed d\u1ee5: Hex Edit&nbsp;<a href=\"http:\/\/www.hexedit.com\/\">http:\/\/www.hexedit.com\/<\/a>&nbsp;)<\/li>\n\n\n\n<li>T\u00ecm ki\u1ebfm DPB<\/li>\n\n\n\n<li>Thay th\u1ebf DPB th\u00e0nh DPx<\/li>\n\n\n\n<li>L\u01b0u t\u1eadp tin.<\/li>\n\n\n\n<li>M\u1edf t\u1ec7p trong Excel.<\/li>\n\n\n\n<li>Nh\u1ea5p v\u00e0o &#8220;C\u00f3&#8221; n\u1ebfu b\u1ea1n nh\u1eadn \u0111\u01b0\u1ee3c b\u1ea5t k\u1ef3 h\u1ed9p th\u00f4ng b\u00e1o n\u00e0o.<\/li>\n\n\n\n<li>\u0110\u1eb7t m\u1eadt kh\u1ea9u m\u1edbi t\u1eeb VBA Project Properties.<\/li>\n\n\n\n<li>\u0110\u00f3ng v\u00e0 m\u1edf l\u1ea1i t\u1ec7p, sau \u0111\u00f3 nh\u1eadp m\u1eadt kh\u1ea9u m\u1edbi \u0111\u1ec3 b\u1ecf b\u1ea3o v\u1ec7.<\/li>\n<\/ul>\n\n\n\n<p><strong>C\u1eacP NH\u1eacT:<\/strong>&nbsp;\u0110\u1ed1i v\u1edbi Excel 2010 (Ho\u1ea1t \u0111\u1ed9ng v\u1edbi MS Office Pro Plus 2010 [14.0.6023.1000 64bit]),<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>M\u1edf t\u1ec7p XLSX b\u1eb1ng 7zip<\/li>\n<\/ul>\n\n\n\n<p><strong>N\u1ebfu s\u1ed5 l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duy\u1ec7t th\u01b0 m\u1ee5c<code>xl<\/code><\/li>\n\n\n\n<li>N\u1ebfu s\u1ed5 l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i&nbsp;<code>workbook.xml<\/code>v\u00e0 ch\u1ecdn&nbsp;<strong>Ch\u1ec9nh s\u1eeda<\/strong><\/li>\n\n\n\n<li>T\u00ecm ph\u1ea7n&nbsp;<code>&lt;workbookProtection workbookPassword=\"XXXX\" lockStructure=\"1\"\/&gt;<\/code>(&nbsp;<code>XXXX<\/code>l\u00e0 m\u1eadt kh\u1ea9u \u0111\u01b0\u1ee3c m\u00e3 h\u00f3a c\u1ee7a b\u1ea1n)<\/li>\n\n\n\n<li>Lo\u1ea1i b\u1ecf&nbsp;<code>XXXX<\/code>m\u1ed9t ph\u1ea7n. (t\u1ee9c l\u00e0&nbsp;<code>&lt;workbookProtection workbookPassword=\"\" lockStructure=\"1\"\/&gt;<\/code>)<\/li>\n\n\n\n<li>L\u01b0u t\u1eadp tin.<\/li>\n\n\n\n<li>Khi 7zip y\u00eau c\u1ea7u b\u1ea1n c\u1eadp nh\u1eadt kho l\u01b0u tr\u1eef, h\u00e3y ch\u1ecdn&nbsp;<strong>C\u00f3<\/strong>&nbsp;.<\/li>\n\n\n\n<li>\u0110\u00f3ng 7zip v\u00e0 m\u1edf l\u1ea1i XLSX.<\/li>\n\n\n\n<li>Nh\u1ea5p v\u00e0o&nbsp;<strong>B\u1ea3o v\u1ec7 b\u1ea3ng<\/strong>&nbsp;t\u00ednh tr\u00ean&nbsp;tab&nbsp;<strong>Xem l\u1ea1i .<\/strong><\/li>\n\n\n\n<li>T\u00f9y ch\u1ecdn: L\u01b0u t\u1ec7p c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n<p><strong>N\u1ebfu b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Duy\u1ec7t \u0111\u1ebfn&nbsp;<code>xl\/worksheets\/<\/code>th\u01b0 m\u1ee5c.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o&nbsp;<code>Sheet1.xml<\/code>,&nbsp;<code>sheet2.xml<\/code>, v.v. v\u00e0 ch\u1ecdn&nbsp;<strong>Ch\u1ec9nh s\u1eeda<\/strong>&nbsp;.<\/li>\n\n\n\n<li>T\u00ecm ph\u1ea7n<code>&lt;sheetProtection password=\"XXXX\" sheet=\"1\" objects=\"1\" scenarios=\"1\" \/&gt;<\/code><\/li>\n\n\n\n<li>X\u00f3a m\u1eadt kh\u1ea9u \u0111\u00e3 m\u00e3 h\u00f3a (v\u00ed d\u1ee5:&nbsp;<code>&lt;sheetProtection password=\"\" sheet=\"1\" objects=\"1\" scenarios=\"1\" \/&gt;<\/code>)<\/li>\n\n\n\n<li>L\u01b0u t\u1eadp tin.<\/li>\n\n\n\n<li>Khi 7zip y\u00eau c\u1ea7u b\u1ea1n c\u1eadp nh\u1eadt kho l\u01b0u tr\u1eef, h\u00e3y ch\u1ecdn&nbsp;<strong>C\u00f3<\/strong>&nbsp;.<\/li>\n\n\n\n<li>\u0110\u00f3ng 7zip v\u00e0 m\u1edf l\u1ea1i XLSX.<\/li>\n\n\n\n<li>Nh\u1ea5p v\u00e0o&nbsp;<strong>B\u1ecf b\u1ea3o v\u1ec7 trang t\u00ednh<\/strong>&nbsp;tr\u00ean tab&nbsp;<strong>Xem l\u1ea1i<\/strong>&nbsp;.<\/li>\n\n\n\n<li>T\u00f9y ch\u1ecdn: L\u01b0u t\u1ec7p c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n\n\n\n<p><strong>M\u1ed9t c\u00e1ch kh\u00e1c <\/strong><br><br>N\u1ebfu lo\u1ea1i t\u1ec7p l\u00e0 t\u1ec7p XLSM:<\/p>\n\n\n\n<p>T\u00ecm ki\u1ebfm&nbsp;<code>DPB=<\/code>v\u00e0 thay th\u1ebf n\u00f3 b\u1eb1ng<code>DPx=<\/code><\/p>\n\n\n\n<p>\u0110\u1ed5i t\u00ean&nbsp;<code>.xlsm<\/code>th\u00e0nh&nbsp;<code>.zip<\/code>(ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 m\u1edf .xlsm b\u1eb1ng 7zip\/WinRAR) v\u00e0 m\u1edf\/gi\u1ea3i n\u00e9n n\u00f3<\/p>\n\n\n\n<p>Ch\u1ec9nh s\u1eeda&nbsp;<code>xl\/vbaProject.bin<\/code>t\u1ec7p b\u1eb1ng Notepad++ ho\u1eb7c HexEdit<\/p>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>L\u01b0u t\u1eadp tin<\/li>\n\n\n\n<li>Sao ch\u00e9p t\u1eadp tin n\u00e0y tr\u1edf l\u1ea1i&nbsp;<code>.zip<\/code>(ho\u1eb7c n\u00e9n c\u00e1c t\u1eadp tin l\u1ea1i)<\/li>\n\n\n\n<li>\u0110\u1ed5i t\u00ean kho l\u01b0u tr\u1eef tr\u1edf l\u1ea1i th\u00e0nh<code>.xlsm<\/code><\/li>\n\n\n\n<li>M\u1edf t\u1ec7p trong Excel, n\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc &#8220;Ti\u1ebfp t\u1ee5c t\u1ea3i d\u1ef1 \u00e1n&#8221;, h\u00e3y nh\u1ea5p v\u00e0o C\u00f3. N\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc b\u00e1o l\u1ed7i, h\u00e3y nh\u1ea5p v\u00e0o OK.&nbsp;<em>L\u01b0u \u00fd: m\u00e3 c\u00f3 th\u1ec3 v\u1eabn tr\u1ed1ng ho\u1eb7c b\u1ecb l\u1ed7i, ch\u00fang t\u00f4i s\u1ebd s\u1eeda l\u1ed7i n\u00e0y trong b\u01b0\u1edbc ti\u1ebfp theo.<\/em><\/li>\n\n\n\n<li><strong>L\u01b0u t\u1ec7p d\u01b0\u1edbi d\u1ea1ng<\/strong>&nbsp;<code>.xlsm<\/code>&nbsp;t\u1ec7p m\u1edbi<\/li>\n\n\n\n<li>M\u1edf&nbsp;<strong>t\u1ec7p m\u1edbi trong Excel<\/strong>&nbsp;(b\u00e2y gi\u1edd s\u1ebd kh\u00f4ng c\u00f3 l\u1ed7i n\u00e0o)<\/li>\n\n\n\n<li>Nh\u1ea5n Alt+F11 \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA<\/li>\n<\/ol>\n\n\n\n<p><strong>ho\u1eb7c<\/strong><\/p>\n\n\n\n<p><strong>Th\u1ef1c hi\u1ec7n theo b\u01b0\u1edbc n\u00e0y c\u0169ng<\/strong><\/p>\n\n\n\n<p>T\u00f4i \u0111\u00e3 t\u00ecm ra m\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 n\u00e0y \u0111\u1ec3 tr\u00e1nh m\u1eadt kh\u1ea9u c\u1ee7a D\u1ef1 \u00e1n VBA, m\u00e0 kh\u00f4ng l\u00e0m m\u1ea5t m\u1eadt kh\u1ea9u Excel. s\u1eed d\u1ee5ng&nbsp;<strong>Hex-editor XVI32<\/strong>&nbsp;cho qu\u00e1 tr\u00ecnh n\u00e0y<\/p>\n\n\n\n<p>n\u1ebfu lo\u1ea1i t\u1ec7p l\u00e0 t\u1ec7p XLSM:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>M\u1edf t\u1ec7p XLSM b\u1eb1ng 7-Zip (nh\u1ea5p chu\u1ed9t ph\u1ea3i -&gt; 7-Zip -&gt; M\u1edf t\u1ec7p l\u01b0u tr\u1eef). 2. Sao ch\u00e9p t\u1ec7p xl\/vbaProject.bin ra kh\u1ecfi t\u1ec7p (b\u1ea1n c\u00f3 th\u1ec3 k\u00e9o v\u00e0 th\u1ea3 t\u1eeb 7-Zip), kh\u00f4ng \u0111\u00f3ng 7-Zip<\/li>\n\n\n\n<li>M\u1edf t\u1ec7p vbaProject.bin b\u1eb1ng HexEdit<\/li>\n\n\n\n<li>T\u00ecm ki\u1ebfm &#8220;DPB=&#8221; v\u00e0 thay th\u1ebf b\u1eb1ng &#8220;DPx=&#8221;<\/li>\n\n\n\n<li>L\u01b0u t\u1eadp tin<\/li>\n\n\n\n<li>Sao ch\u00e9p t\u1ec7p n\u00e0y tr\u1edf l\u1ea1i 7-Zip (m\u1ed9t l\u1ea7n n\u1eefa, k\u00e9o v\u00e0 th\u1ea3 v\u1eabn ho\u1ea1t \u0111\u1ed9ng)<\/li>\n\n\n\n<li>M\u1edf t\u1ec7p XLSX trong Excel, n\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc &#8220;Ti\u1ebfp t\u1ee5c t\u1ea3i d\u1ef1 \u00e1n&#8221;, h\u00e3y nh\u1ea5p v\u00e0o C\u00f3. N\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc b\u00e1o l\u1ed7i, h\u00e3y nh\u1ea5p v\u00e0o OK. 8. Nh\u1ea5n Alt+F11 \u0111\u1ec3 m\u1edf tr\u00ecnh so\u1ea1n th\u1ea3o VBA.<\/li>\n\n\n\n<li>Khi nh\u1ea5n s\u1ebd hi\u1ec3n th\u1ecb l\u1ed7i \u201cL\u1ed7i kh\u00f4ng mong mu\u1ed1n (40230)\u201d, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o OK (6 ho\u1eb7c 7 l\u1ea7n) cho \u0111\u1ebfn khi l\u1ed7i bi\u1ebfn m\u1ea5t.<\/li>\n\n\n\n<li>Sau \u0111\u00f3 n\u00f3 s\u1ebd t\u1ef1 \u0111\u1ed9ng m\u1edf<\/li>\n<\/ol>\n\n\n\n<p>(Ngu\u1ed3n s\u01b0u t\u1ea7m )<\/p>\n","protected":false},"excerpt":{"rendered":"<p>C\u1eacP NH\u1eacT:&nbsp;\u0110\u1ed1i v\u1edbi Excel 2010 (Ho\u1ea1t \u0111\u1ed9ng v\u1edbi MS Office Pro Plus 2010 [14.0.6023.1000 64bit]), N\u1ebfu s\u1ed5 l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7: N\u1ebfu b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7: M\u1ed9t c\u00e1ch kh\u00e1c N\u1ebfu lo\u1ea1i t\u1ec7p l\u00e0 t\u1ec7p XLSM: T\u00ecm ki\u1ebfm&nbsp;DPB=v\u00e0 thay th\u1ebf n\u00f3 b\u1eb1ngDPx= \u0110\u1ed5i t\u00ean&nbsp;.xlsmth\u00e0nh&nbsp;.zip(ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 m\u1edf .xlsm b\u1eb1ng 7zip\/WinRAR) v\u00e0 m\u1edf\/gi\u1ea3i n\u00e9n &#8230; <a title=\"C\u00e1ch x\u00f3a, m\u1edf kh\u00f3a m\u1eadt kh\u1ea9u VBA tr\u00ean Excel\" class=\"read-more\" href=\"https:\/\/teencode.vip\/blog\/cach-xoa-mo-khoa-mat-khau-vba-tren-excel\/\" aria-label=\"\u0110\u1ecdc th\u00eam v\u1ec1 C\u00e1ch x\u00f3a, m\u1edf kh\u00f3a m\u1eadt kh\u1ea9u VBA tr\u00ean Excel\">\u0110\u1ecdc ti\u1ebfp<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mo_disable_npp":"","pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[26],"tags":[35,34],"class_list":["post-34","post","type-post","status-publish","format-standard","hentry","category-cntt","tag-xoa-mat-khau-excel","tag-xoa-mat-khau-vba-excel"],"_links":{"self":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/34","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":2,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"predecessor-version":[{"id":36,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/posts\/34\/revisions\/36"}],"wp:attachment":[{"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teencode.vip\/blog\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}