{"id":4523,"date":"2024-12-06T11:05:27","date_gmt":"2024-12-06T11:05:27","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve\/"},"modified":"2024-12-06T11:05:27","modified_gmt":"2024-12-06T11:05:27","slug":"cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/06\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve\/","title":{"rendered":"C\u00e1ch s\u1eeda file Excel b\u1ecb n\u1eb7ng ch\u1eadm, v\u00e0 g\u1ee1 b\u1ecf m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p>V\u1edbi b\u00e0i <a href=\"http:\/\/blog.ezworkapp.com\/file-excel-bi-nang-lam-sao-de-giam-dung-luong.html\" target=\"_blank\" rel=\"noopener noreferrer\">B\u00ed k\u00edp gi\u1ea3m c\u00e2n gi\u1ea3m dung l\u01b0\u1ee3ng cho file Excel t\u1eadp 1<\/a>, ch\u00fang ta bi\u1ebft c\u00e1ch \u0111\u1ec3 d\u00f9ng c\u00f4ng c\u1ee5 ASAP c\u0169ng nh\u01b0 c\u00e1ch th\u1ee7 c\u00f4ng \u0111\u1ec3 x\u00f3a b\u1ecf \u0111i c\u00e1c Object v\u00e0 Name trong file Excel. Tuy nhi\u00ean khi t\u1eadp tin Excel \u0111\u00e3 c\u00f3 qu\u00e1 nhi\u1ec1u Text box, c\u00e1c Objects d\u01b0 th\u1eeba, th\u00ec vi\u1ec7c \u201cgi\u1ea3m c\u00e2n\u201d th\u00f4ng qua c\u00f4ng c\u1ee5 s\u1ebd kh\u00f4ng c\u00f2n hi\u1ec7u qu\u1ea3. H\u00f4m nay, m\u00ecnh gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n m\u1ed9t c\u00e1ch kh\u00e1c, s\u1ebd gi\u00fap c\u00e1c b\u1ea1n thao t\u00e1c nhanh ch\u00f3ng h\u01a1n.<\/p>\n<p>Trong khu\u00f4n kh\u1ed5 b\u00e0i vi\u1ebft n\u00e0y c\u00f3 \u0111\u1ec1 c\u1eadp \u0111\u1ebfn vi\u1ec7c m\u1edf kh\u00f3a m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 sheet, m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 c\u1ea5u tr\u00fac workbook, v\u00e0 m\u1eadt kh\u1ea9u VBA \u00e1p d\u1ee5ng khi c\u00e1c b\u1ea1n c\u1ea7n ch\u1ec9nh s\u1eeda l\u1ea5y l\u1ea1i file c\u1ee7a m\u00ecnh khi b\u1ecb qu\u00ean m\u1eadt kh\u1ea9u. M\u1ecdi thao t\u00e1c can thi\u1ec7p v\u00e0o t\u1eadp tin c\u1ee7a kh\u00f4ng ph\u1ea3i c\u1ee7a m\u00ecnh, c\u00e1c b\u1ea1n s\u1ebd ph\u1ea3i t\u1ef1 ch\u1ecbu tr\u00e1ch nhi\u1ec7m v\u1edbi vi\u1ec7c m\u00ecnh l\u00e0m. V\u00ec v\u1eady, c\u00e1c b\u1ea1n c\u0169ng n\u00ean c\u1ea9n tr\u1ecdng khi thao t\u00e1c li\u00ean quan \u0111\u1ebfn m\u1eadt kh\u1ea9u.<\/p>\n<p>V\u00e0 c\u00e1c \u1ee9ng d\u1ee5ng c\u1ea7n thi\u1ebft cho c\u00f4ng vi\u1ec7c n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 b\u1ea5m v\u00e0o link \u0111\u1ec3 download v\u00e0 c\u00e0i \u0111\u1eb7t:<\/p>\n<ul>\n<li>Ph\u1ea7n m\u1ec1m ch\u1ec9nh s\u1eeda n\u1ed9i dung file xml:\u00a0<strong><a href=\"https:\/\/notepad-plus-plus.org\/download\/v7.5.9.html\" target=\"_blank\" rel=\"noopener noreferrer\">Notepad++<\/a><\/strong>.<\/li>\n<li>Ph\u1ea7n m\u1ec1m gi\u1ea3i n\u00e9n v\u00e0 n\u00e9n t\u1eadp tin .zip, .rar:<strong> Winrar<\/strong> ho\u1eb7c <strong><a href=\"https:\/\/www.7-zip.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">7-zip.org<\/a><\/strong><\/li>\n<li>HexEdit: v\u1edbi ph\u1ea7n m\u1ec1n <strong><a href=\"https:\/\/mh-nexus.de\/en\/hxd\/\" target=\"_blank\" rel=\"noopener noreferrer\">HxD<\/a><\/strong>, d\u00f9ng \u0111\u1ec3 ch\u1ec9nh s\u1eeda file\u00a0vbaProject.bin file m\u1eadt kh\u1ea9u VBA.<\/li>\n<\/ul>\n<p>N\u00e0o ch\u00fang ta c\u00f9ng b\u1eaft \u0111\u1ea7u t\u00ecm hi\u1ec3u nh\u00e9!<\/p>\n<ol>\n<li>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6752a3ecc22cb\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#Tap_tin_Office_deu_luu_tru_theo_XML_doi_ten_va_giai_nen\" title=\"T\u1eadp tin Office \u0111\u1ec1u l\u01b0u tr\u1eef theo XML, \u0111\u1ed5i t\u00ean v\u00e0 gi\u1ea3i n\u00e9n.\">T\u1eadp tin Office \u0111\u1ec1u l\u01b0u tr\u1eef theo XML, \u0111\u1ed5i t\u00ean v\u00e0 gi\u1ea3i n\u00e9n.<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#workbookxml_File_chua_thong_tin_ve_Workbook_noi_chua_name_va_mat_khau_protect_structure\" title=\"workbook.xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 Workbook, n\u01a1i ch\u1ee9a name v\u00e0 m\u1eadt kh\u1ea9u protect structure.\n\">workbook.xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 Workbook, n\u01a1i ch\u1ee9a name v\u00e0 m\u1eadt kh\u1ea9u protect structure.<br \/>\n<\/a><\/p>\n<ul class=\"ez-toc-list-level-6\">\n<li class=\"ez-toc-heading-level-6\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#Protect_Workbook\" title=\"Protect Workbook:\">Protect Workbook:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-6\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#Name_rac\" title=\"Name r\u00e1c\">Name r\u00e1c<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#vbaProjectbin_File_chua_thong_tin_ve_VBA_Projects\" title=\"vbaProject.bin: File ch\u1ee9a th\u00f4ng tin v\u1ec1 VBA Projects.\">vbaProject.bin: File ch\u1ee9a th\u00f4ng tin v\u1ec1 VBA Projects.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#drawingsdrawing%E2%80%A6xml_va_sheetssheet%E2%80%A6xml_File_chua_thong_tin_ve_cac_doi_tuong_object_textbox\" title=\"drawingsdrawing[\u2026].xml v\u00e0 sheetssheet[\u2026].xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng object, textbox.\">drawingsdrawing[\u2026].xml v\u00e0 sheetssheet[\u2026].xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng object, textbox.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#sheetssheet%E2%80%A6xml_Go_bo_sheet_protection_ma_khong_can_mat_khau\" title=\"sheetssheet[\u2026].xml: G\u1ee1 b\u1ecf sheet protection m\u00e0 kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u.\">sheetssheet[\u2026].xml: G\u1ee1 b\u1ecf sheet protection m\u00e0 kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#Dong_goi_file_lai_voi_dinh_dang_file_zip_va_doi_ten_nhu_cu\" title=\"\u0110\u00f3ng g\u00f3i file l\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng file .zip, v\u00e0 \u0111\u1ed5i t\u00ean nh\u01b0 c\u0169.\">\u0110\u00f3ng g\u00f3i file l\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng file .zip, v\u00e0 \u0111\u1ed5i t\u00ean nh\u01b0 c\u0169.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#File_xlsb_thi_khong_giong_cho_lam_Phai_lam_sao\" title=\"File .xlsb th\u00ec kh\u00f4ng gi\u1ed1ng cho l\u1eafm? Ph\u1ea3i l\u00e0m sao?\">File .xlsb th\u00ec kh\u00f4ng gi\u1ed1ng cho l\u1eafm? Ph\u1ea3i l\u00e0m sao?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/cach-sua-file-excel-bi-nang-cham-va-go-bo-mat-khau-bao-ve.html#Co_cach_nao_nhanh_hon_khong_Co_VBA\" title=\"C\u00f3 c\u00e1ch n\u00e0o nhanh h\u01a1n kh\u00f4ng? C\u00f3 VBA!\">C\u00f3 c\u00e1ch n\u00e0o nhanh h\u01a1n kh\u00f4ng? C\u00f3 VBA!<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Tap_tin_Office_deu_luu_tru_theo_XML_doi_ten_va_giai_nen\"><\/span>T\u1eadp tin Office \u0111\u1ec1u l\u01b0u tr\u1eef theo XML, \u0111\u1ed5i t\u00ean v\u00e0 gi\u1ea3i n\u00e9n.<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div>C\u00e1c t\u1eadp tin Office (Excel, Word, PowerPoint) th\u1ef1c ra \u0111\u1ec1u l\u00e0 m\u1ed9t file \u0111\u01b0\u1ee3c n\u00e9n l\u1ea1i t\u1eeb r\u1ea5t nhi\u1ec1u file kh\u00e1c, v\u00e0 n\u1ed9i dung file l\u01b0u theo chu\u1ea9n XML. N\u00f3i v\u1eady ngh\u0129a l\u00e0 sao? C\u00f3 bao gi\u1edd b\u1ea1n th\u1eed \u0111\u1ed5i t\u00ean m\u1edf r\u1ed9ng c\u1ee7a file Office th\u00e0nh .zip v\u00e0 gi\u1ea3i n\u00e9n ch\u00fang ch\u01b0a? V\u00ed d\u1ee5 b\u1ea1n c\u00f3 t\u1eadp tin: File-Excel.xlsx,\u00a0b\u1ea1n th\u1eed \u0111\u1ed5i ph\u1ea7n .xlsx (ph\u1ea7n m\u1edf r\u1ed9ng) th\u00e0nh .zip v\u00e0 gi\u1ea3i n\u00e9n\u00a0ra th\u00e0nh th\u01b0 m\u1ee5c.<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/file-zip-extension-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23277\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201284%20377'%3E%3C\/svg%3E\" alt=\"\" width=\"1284\" height=\"377\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-zip-extension-1.jpg 1284w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-zip-extension-1-600x176.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-zip-extension-1-300x88.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-zip-extension-1-768x225.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-zip-extension-1-1024x301.jpg 1024w\" data-lazy-sizes=\"(max-width: 1284px) 100vw, 1284px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-zip-extension-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23277\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-zip-extension-1.jpg\" width=\"1284\" height=\"377\" title=\"file-zip-extension-1\"><\/a><br \/>\nTr\u01b0\u1eddng h\u1ee3p n\u1ebfu trong My Computer b\u1ea1n kh\u00f4ng th\u1ea5y ph\u1ea7n m\u1edf r\u1ed9ng c\u1ee7a file, th\u00ec b\u1ea1n c\u1ea7n ch\u1ecdn [x] File name extensions (N\u1ebfu b\u1ea1n d\u00f9ng Windows phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y \u1edf ph\u1ea7n Folder Options).<\/p>\n<p>Sau khi xu\u1ea5t ra, b\u1ea1n \u0111\u00e3 c\u00f3 th\u01b0 m\u1ee5c tu\u1ea7n t\u1ef1 nh\u01b0 sau, vi\u1ec7c c\u1ee7a ch\u00fang ta s\u1ebd quan t\u00e2m \u0111\u1ebfn c\u00e1c file theo tu\u1ea7n t\u1ef1 sau:<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/file-xml.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23266\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20601%20517'%3E%3C\/svg%3E\" alt=\"\" width=\"601\" height=\"517\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-xml.jpg 601w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-xml-300x258.jpg 300w\" data-lazy-sizes=\"(max-width: 601px) 100vw, 601px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-xml.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23266\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-xml.jpg\" width=\"601\" height=\"517\" title=\"file-xml\"><br \/>\n<\/a><br \/>\nL\u00fac n\u00e0y ch\u00fang ta quan t\u00e2m \u0111\u1ebfn c\u00e1c t\u1eadp tin, th\u01b0 m\u1ee5c sau:<\/p>\n<ol>\n<li>\n<h5><strong>workbook.xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 Workbook, n\u01a1i ch\u1ee9a name v\u00e0 m\u1eadt kh\u1ea9u protect structure.<br \/>\n<\/strong><\/h5>\n<ul>\n<li>\n<h6><span class=\"ez-toc-section\" id=\"Protect_Workbook\"><\/span>Protect Workbook:<span class=\"ez-toc-section-end\"><\/span><\/h6>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23275\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201057%20319'%3E%3C\/svg%3E\" alt=\"\" width=\"1057\" height=\"319\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/protect-workbook.jpg 1057w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/protect-workbook-600x181.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/protect-workbook-300x91.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/protect-workbook-768x232.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/protect-workbook-1024x309.jpg 1024w\" data-lazy-sizes=\"(max-width: 1057px) 100vw, 1057px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/protect-workbook.jpg\"><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23275\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/protect-workbook.jpg\" width=\"1057\" height=\"319\" title=\"protect-workbook\"><br \/>\nV\u1edbi file n\u00e0y, ch\u00fang ta s\u1ebd t\u00ecm th\u1ea5y d\u1eef li\u1ec7u li\u00ean quan \u0111\u1ebfn c\u1ea5u tr\u00fac file, v\u00e0 \u0111\u1eb7c bi\u1ec7t l\u00e0 \u0111\u00e2y l\u00e0 n\u01a1i ch\u1ee9a m\u1eadt kh\u1ea9u Protect Workbook. Protect Workbook Structure: nh\u1eb1m h\u1ea1n ch\u1ebf ng\u01b0\u1eddi d\u00f9ng thay \u0111\u1ed5i c\u1ea5u tr\u00fac file v\u00ed d\u1ee5 nh\u01b0 kh\u00f4ng cho thay \u0111\u1ed5i t\u00ean Sheet, ho\u1eb7c di chuy\u1ec3n s\u1eafp x\u1ebfp c\u00e1c sheet v.v\u2026 L\u01b0u \u00fd: ph\u1ea7n n\u00e0y kh\u00e1c v\u1edbi m\u1eadt kh\u1ea9u khi m\u1edf file v\u00e0 m\u1eadt kh\u1ea9u h\u1ecfi khi m\u1edf file kh\u00f4ng \u0111\u1ec1 c\u1eadp \u0111\u1ebfn trong b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n<p>\u0110\u1ec3 s\u1eeda file n\u00e0y v\u00e0 <strong>g\u1ee1 b\u1ecf \u0111i m\u1eadt kh\u1ea9u Protect Workbook<\/strong> n\u00e0y, ch\u00fang ta l\u00e0m tu\u1ea7n t\u1ef1 theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> Ch\u00fang ta click ph\u1ea3i v\u00e0o file workbook.xml, ch\u1ecdn Open with Notepad++.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> T\u00ecm \u0111o\u1ea1n \u201c<strong>&lt;workbookProtection<\/strong> \u2026\/&gt;\u201d, v\u00e0 x\u00f3a \u0111i.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> L\u01b0u file workbook.xml \u0111\u00e3 ch\u1ec9nh s\u1eeda.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/remove-protect-workbook.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23274\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201356%20629'%3E%3C\/svg%3E\" alt=\"\" width=\"1356\" height=\"629\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-protect-workbook.jpg 1356w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/remove-protect-workbook-600x278.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/remove-protect-workbook-300x139.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/remove-protect-workbook-768x356.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/remove-protect-workbook-1024x475.jpg 1024w\" data-lazy-sizes=\"(max-width: 1356px) 100vw, 1356px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-protect-workbook.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23274\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/remove-protect-workbook.jpg\" width=\"1356\" height=\"629\" title=\"remove-protect-workbook\"><br \/>\n<\/a>V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 ti\u1ebfn h\u00e0nh b\u1ecf \u0111i m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 workbook. V\u00e0 l\u01b0u \u00fd khi x\u00f3a ph\u1ea3i \u0111\u00fang tag c\u1ee7a\u00a0<strong>workbookProtection<\/strong>, c\u1ea5u tr\u00fac tag th\u01b0\u1eddng m\u1edf \u0111\u1ea7u \u201c<strong>&lt;workbookProtection<\/strong>\u201d\u00a0v\u00e0 k\u1ebft th\u00fac b\u1eb1ng \u201c<strong>\/&gt;<\/strong>\u201c.<\/p>\n<\/li>\n<li>\n<h6><span class=\"ez-toc-section\" id=\"Name_rac\"><\/span>Name r\u00e1c<span class=\"ez-toc-section-end\"><\/span><\/h6>\n<p>C\u00e1c name r\u00e1c v\u00ec sao l\u1ea1i xu\u1ea5t hi\u1ec7n? Ph\u1ea7n l\u00e0 v\u00ec virus, ph\u1ea7n c\u00f2n l\u1ea1i do ch\u00ednh ch\u00fang ta \u201cx\u1ea3 r\u00e1c\u201d m\u00e0 kh\u00f4ng hay bi\u1ebft! V\u00ec thao t\u00e1c sao ch\u00e9p, move\/copy sheet, ho\u1eb7c copy d\u1eef li\u1ec7u r\u1ed3i d\u00e1ng, v\u00f4 t\u00ecnh k\u00e9o theo c\u00e1c \u201c\u0111\u1ed3ng ch\u00ed mang b\u00ed danh\u201d l\u00fac n\u00e0o kh\u00f4ng hay bi\u1ebft.\u00a0 C\u00e1c name s\u1ebd l\u00e0 \u201c<strong>&lt;definedName&gt;[\u2026]&lt;\/definedName&gt;<\/strong>\u201c, v\u00e0 Name r\u00e1c th\u01b0\u1eddng l\u00e0 c\u00f3 l\u1ed7i: \u201c<strong>&lt;definedName&gt;#REF!&lt;\/definedName&gt;<\/strong>\u201c.<\/p>\n<p>\u0110\u1ec3 t\u00ecm v\u00e0 thay th\u1ebf nhanh ch\u00f3ng, ch\u00fang ta l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong>\u00a0M\u1edf file Workbook.xml v\u1edbi Notepad++. \u0110\u1eb7t d\u1ea5u con tr\u1ecf ngay v\u1ecb tr\u00ed \u0111\u1ea7u ti\u00ean c\u1ee7a file (ngay tr\u01b0\u1edbc \u201c&lt;?xml\u201d).<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n CTRL+H (t\u00ecm v\u00e0 thay th\u1ebf), sau \u0111\u00f3 ch\u1ecdn \u1edf ph\u1ea7n [x] Regular\u00a0Expression trong ph\u1ea7n Search Mode.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> T\u00ecm v\u1edbi t\u1eeb kh\u00f3a sau: \u201c<strong>(&lt;definedNames.*&gt;#REF!&lt;\/definedName&gt;)<\/strong>\u201c. (Kh\u00f4ng bao g\u1ed3m d\u1ea5u nh\u00e1y k\u00e9p \u201c\u201d)<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Sau \u0111\u00f3 t\u00ecm ki\u1ebfm th\u1eed, t\u00ecm th\u1ea5y s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u (highlight), v\u00e0 b\u1ea1n ch\u1ecdn Replace All (nh\u1ea5n ALT + A).<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> L\u01b0u file l\u1ea1i Workbook.xml, v\u00e0 \u0111\u00f3ng Notepad++.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/find-replace-definedName-regex.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23285\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201347%20642'%3E%3C\/svg%3E\" alt=\"\" width=\"1347\" height=\"642\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-definedname-regex.jpg 1347w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/find-replace-definedName-regex-600x286.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/find-replace-definedName-regex-300x143.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/find-replace-definedName-regex-768x366.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/find-replace-definedName-regex-1024x488.jpg 1024w\" data-lazy-sizes=\"(max-width: 1347px) 100vw, 1347px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-definedname-regex.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23285\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/find-replace-definedname-regex.jpg\" width=\"1347\" height=\"642\" title=\"find-replace-definedname-regex\"><\/a><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"vbaProjectbin_File_chua_thong_tin_ve_VBA_Projects\"><\/span><strong>vbaProject.bin: File ch\u1ee9a th\u00f4ng tin v\u1ec1 VBA Projects.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0110\u1ec3 ti\u1ebfn h\u00e0nh b\u1ecf m\u1eadt kh\u1ea9u VBA Project, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> M\u1edf file vbaProject.bin v\u1edbi \u1ee9ng d\u1ee5ng HxD Hex Editor.<br \/>\n(\u1edf \u0111\u00e2y m\u00ecnh c\u00e0i HxD c\u00f3 bi\u1ec3u t\u01b0\u1ee3ng s\u1eb5n HxD ch\u1ec9 c\u1ea7n double click \u0111\u1ec3 m\u1edf, ho\u1eb7c click ph\u1ea3i ch\u1ecdn Open With v\u00e0 t\u00ecm \u1ee9ng d\u1ee5ng HxD Hex Editor.)<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n Ctrl+F t\u00ecm t\u1eeb kh\u00f3a: \u201cDPB\u201d v\u00e0 s\u1eeda ch\u1eef \u201cDPB\u201d th\u00e0nh \u201cDPx\u201d.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> L\u01b0u l\u1ea1i, v\u00e0 \u0111\u00f3ng \u1ee9ng d\u1ee5ng HxD<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Sau khi n\u00e9n l\u1ea1i file, m\u1edf file Excel n\u1ebfu g\u1eb7p th\u00f4ng b\u00e1o b\u1ea1n ch\u1ecdn Yes, n\u1ebfu c\u00f3 th\u00f4ng b\u00e1o ti\u1ebfp b\u1ea1n ch\u1ecdn OK.<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Nh\u1ea5n ALT+F11 \u0111\u1ec3 m\u1edf c\u1eeda s\u1ed5 Visual Basic.<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Click ph\u1ea3i v\u00e0o t\u00ean file, ch\u1ecdn VBA Projects Properties\u2026 Ch\u1ecdn tab Protection, v\u00e0 b\u1ecf ch\u1ecdn [ ] \u201cLock project for viewing\u201d. V\u1eady l\u00e0 xong, l\u01b0u v\u00e0 \u0111\u00f3ng file.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/file-vbaProjectbin-remove-dpb.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23278\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20957%20758'%3E%3C\/svg%3E\" alt=\"\" width=\"957\" height=\"758\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-vbaprojectbin-remove-dpb.jpg 957w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-vbaProjectbin-remove-dpb-600x475.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-vbaProjectbin-remove-dpb-300x238.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-vbaProjectbin-remove-dpb-768x608.jpg 768w\" data-lazy-sizes=\"(max-width: 957px) 100vw, 957px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-vbaprojectbin-remove-dpb.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23278\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-vbaprojectbin-remove-dpb.jpg\" width=\"957\" height=\"758\" title=\"file-vbaprojectbin-remove-dpb\"><br \/>\n<\/a>V\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 b\u1ecf \u0111\u01b0\u1ee3c m\u1eadt kh\u1ea9u VBA Project.<\/p>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"drawingsdrawing%E2%80%A6xml_va_sheetssheet%E2%80%A6xml_File_chua_thong_tin_ve_cac_doi_tuong_object_textbox\"><\/span>drawingsdrawing[\u2026].xml v\u00e0 sheetssheet[\u2026].xml: File ch\u1ee9a th\u00f4ng tin v\u1ec1 c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng object, textbox.<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0110\u00e2y ch\u00ednh n\u01a1i l\u00e0 c\u00e1c file ch\u1ee9a c\u00e1c object (c\u00e1c textbox, h\u00ecnh \u1ea3nh). V\u00ec sao l\u1ea1i l\u00e0 x\u1ea3y ra t\u00ecnh tr\u1ea1ng g\u1ecdi l\u00e0 \u201cr\u00e1c\u201d. L\u00e0 v\u00ec m\u1eb7c \u0111\u1ecbnh c\u00e1c textbox, ho\u1eb7c c\u00e1c h\u00ecnh \u1ea3nh s\u1ebd t\u1ef1 \u0111\u1ed9ng thu nh\u1ecf (resize) theo c\u00e1c d\u00f2ng c\u1ed9t, khi b\u1ea1n \u1ea9n d\u00f2ng c\u1ed9t \u0111i, th\u00ec v\u00f4 t\u00ecnh c\u00e1c textbox, h\u00ecnh \u1ea3nh c\u0169ng b\u1ecb thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc theo. V\u00e0 l\u00fac n\u00e0y k\u00edch th\u01b0\u1edbc c\u00e1c textbox g\u1ea7n nh\u01b0 l\u00e0 0, n\u00ean ch\u00fang ta kh\u00f4ng th\u1ec3 nh\u00ecn th\u1ea5y \u0111\u01b0\u1ee3c, v\u00e0 l\u1ea1i n\u1eb1m l\u1eabn trong \u00f4, n\u00ean khi k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng, v\u00f4 t\u00ecnh c\u00e1c h\u00ecnh \u1ea3nh c\u0169ng t\u1ef1 sao ch\u00e9p ra.<\/p>\n<div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/drawing-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23279\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201133%20549'%3E%3C\/svg%3E\" alt=\"\" width=\"1133\" height=\"549\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheet.jpg 1133w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheet-600x291.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheet-300x145.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheet-768x372.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheet-1024x496.jpg 1024w\" data-lazy-sizes=\"(max-width: 1133px) 100vw, 1133px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23279\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheet.jpg\" width=\"1133\" height=\"549\" title=\"drawing-sheet\"><\/a><\/p>\n<p>V\u1eady, l\u00e0m sao \u0111\u1ec3 x\u00f3a s\u1eeda vi\u1ec7c n\u00e0y? T\u01b0\u01a1ng \u1ee9ng v\u1edbi c\u00e1c <strong>objects<\/strong>\u00a0trong m\u1ed7i sheet[\u2026].xml t\u01b0\u01a1ng \u1ee9ng v\u1edbi m\u1ed7i file drawing[\u2026].xml, trong sheet[\u2026].xml s\u1ebd c\u00f3 ch\u1ed7 ch\u1ee9a s\u1ebd l\u00e0 \u201c<strong>&lt;drawing \u2026\/&gt;<\/strong>\u201c.\u00a0\u0110\u1ec3 x\u00f3a n\u1ed9i dung \u0111i, ta l\u00e0m t\u01b0\u01a1ng t\u1ef1 v\u1edbi workbook.xml [ph\u1ea7n 1], s\u1ebd m\u1edf tu\u1ea7n t\u1ef1 c\u00e1c file <strong>sheet[..].xml<\/strong> ra v\u00e0 t\u00ecm x\u00f3a \u0111i c\u00e1c \u0111o\u1ea1n ch\u1ee9a \u201c<strong>&lt;drawing\u2026 \/&gt;<\/strong>\u201c.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/drawing-in-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23280\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201345%20634'%3E%3C\/svg%3E\" alt=\"\" width=\"1345\" height=\"634\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-in-sheet.jpg 1345w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-in-sheet-600x283.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-in-sheet-300x141.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-in-sheet-768x362.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-in-sheet-1024x483.jpg 1024w\" data-lazy-sizes=\"(max-width: 1345px) 100vw, 1345px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-in-sheet.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23280\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-in-sheet.jpg\" width=\"1345\" height=\"634\" title=\"drawing-in-sheet\"><\/a><\/p>\n<p>\u0110\u1ec3 x\u00f3a nhanh ch\u00f3ng, ch\u00fang ta l\u00e0m tu\u1ea7n t\u1ef1 theo c\u00e1c b\u01b0\u1edbc sau:<br \/>\n<strong>B\u01b0\u1edbc 1:<\/strong> Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c file sheet[\u2026].xml trong th\u01b0 m\u1ee5c sheets, click ph\u1ea3i ch\u1ecdn Open with Notepad++.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> Nh\u1ea5n CTRL+H, v\u00e0 ch\u1ecdn [x] RegEx \u1edf Search Mode.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> T\u00ecm \u0111o\u1ea1n sau: \u201c<strong>(&lt;drawing r:id=\u201d.*\u201d\/&gt;)<\/strong>\u201d (kh\u00f4ng bao g\u1ed3m d\u1ea5u nh\u00e1y k\u00e9p).<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> Nh\u1ea5n Replace All in Opened Documents (Ph\u00edm t\u1eaft ALT + O).<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn File =&gt; Save All (ho\u1eb7c nh\u1ea5n CTRL+SHIFT+S) v\u00e0 \u0111\u00f3ng Notepad++ l\u1ea1i.<\/p>\n<p><strong>B\u01b0\u1edbc 6:\u00a0<\/strong>Ch\u00fang ta t\u00ecm \u0111\u1ebfn trong th\u01b0 m\u1ee5c <strong>drawings<\/strong><\/p>\n<p><strong>B\u01b0\u1edbc 7:<\/strong> X\u00f3a h\u1ebft t\u1ea5t c\u1ea3 c\u00e1c file b\u00ean trong. V\u1eady l\u00e0 xong.<\/p>\n<figure id=\"attachment_23289\" aria-describedby=\"caption-attachment-23289\" style=\"width: 1274px\" class=\"wp-caption alignnone\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/drawing-sheets-regex.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23289 size-full\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201274%20488'%3E%3C\/svg%3E\" alt=\"\" width=\"1274\" height=\"488\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheets-regex.jpg 1274w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheets-regex-600x230.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheets-regex-300x115.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheets-regex-768x294.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/drawing-sheets-regex-1024x392.jpg 1024w\" data-lazy-sizes=\"(max-width: 1274px) 100vw, 1274px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheets-regex.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23289 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/drawing-sheets-regex.jpg\" width=\"1274\" height=\"488\" title=\"drawing-sheets-regex\"><\/a><figcaption id=\"caption-attachment-23289\" class=\"wp-caption-text\">\u1ea2nh minh h\u1ecda thao t\u00e1c B\u01b0\u1edbc 1 -&gt; B\u01b0\u1edbc 4<\/figcaption><\/figure>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/file-chua-object-rac.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23281 size-full\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20658%20532'%3E%3C\/svg%3E\" alt=\"\" width=\"658\" height=\"532\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-chua-object-rac.jpg 658w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-chua-object-rac-600x485.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-chua-object-rac-300x243.jpg 300w\" data-lazy-sizes=\"(max-width: 658px) 100vw, 658px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-chua-object-rac.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-23281 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-chua-object-rac.jpg\" width=\"658\" height=\"532\" title=\"file-chua-object-rac\"><\/a><\/p>\n<p>\u1ea2nh minh h\u1ecda b\u01b0\u1edbc 7<\/p>\n<p>Sau khi n\u00e9n l\u1ea1i file, v\u00e0 m\u1edf v\u1edbi Excel, b\u1ea1n s\u1ebd g\u1eb7p l\u1ea7n l\u01b0\u1ee3t c\u00e1c th\u00f4ng b\u00e1o sau.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/file-drawing-remove-object.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23282\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20849%20402'%3E%3C\/svg%3E\" alt=\"\" width=\"849\" height=\"402\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-drawing-remove-object.jpg 849w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-drawing-remove-object-600x284.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-drawing-remove-object-300x142.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/file-drawing-remove-object-768x364.jpg 768w\" data-lazy-sizes=\"(max-width: 849px) 100vw, 849px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-drawing-remove-object.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23282\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/file-drawing-remove-object.jpg\" width=\"849\" height=\"402\" title=\"file-drawing-remove-object\"><\/a><\/p>\n<p>Cu\u1ed1i c\u00f9ng, l\u00e0 b\u1ea1n \u0111\u00e3 lo\u1ea1i b\u1ecf \u0111i to\u00e0n b\u1ed9 c\u00e1c object d\u01b0 th\u1eeba, kh\u00f4ng c\u1ea7n thi\u1ebft. N\u1ebfu b\u1ea1n c\u00f3 Object c\u1ea7n s\u1eed d\u1ee5ng, th\u00ec c\u00f3 th\u1ec3 t\u1ea1o l\u1ea1i, ho\u1eb7c t\u00ecm x\u00f3a th\u1ee7 c\u00f4ng nh\u1eefng c\u00e1i kh\u00f4ng d\u00f9ng. Thao t\u00e1c tr\u00ean s\u1ebd x\u00f3a \u0111i to\u00e0n b\u1ed9 object trong file Excel.\n<\/p>\n<\/div>\n<\/li>\n<li>\n<h5><span class=\"ez-toc-section\" id=\"sheetssheet%E2%80%A6xml_Go_bo_sheet_protection_ma_khong_can_mat_khau\"><\/span><strong>sheetssheet[\u2026].xml: G\u1ee1 b\u1ecf sheet protection m\u00e0 kh\u00f4ng c\u1ea7n m\u1eadt kh\u1ea9u.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>\u0110\u00f4i khi ch\u00fang ta \u0111\u1eb7t m\u1eadt kh\u1ea9u b\u1ea3o v\u1ec7 sheet, r\u1ed3i sau \u0111\u00f3, ch\u00fang ta l\u1ea1i qu\u00ean m\u1ea5t, v\u1eady l\u00e0m sao \u0111\u1ec3 b\u1ecf \u0111i \u0111\u1ec3 ch\u1ec9nh s\u1eeda l\u1ea1i file? R\u1ea5t \u0111\u01a1n gi\u1ea3n v\u1edbi c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p><strong>B\u01b0\u1edbc 1:<\/strong> <strong>Ch\u1ecdn t\u1ea5t c\u1ea3<\/strong> sheet[\u2026].xml trong th\u01b0 m\u1ee5c <strong>sheets<\/strong>, v\u00e0 <strong>M\u1edf v\u1edbi Notepad++<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 2:<\/strong> B\u1ea1n nh\u1ea5n <strong>CTRL+H<\/strong> \u0111\u1ec3 m\u1edf c\u00f4ng c\u1ee5 Find &amp; Replace trong Notepad++.<\/p>\n<p><strong>B\u01b0\u1edbc 3:<\/strong> V\u1eabn nh\u01b0 tr\u00ean, b\u1ea1n ch\u1ecdn<strong> [x] Regular Expenssion<\/strong> trong<strong> Search Mode<\/strong>.<\/p>\n<p><strong>B\u01b0\u1edbc 4:<\/strong> T\u00ecm theo t\u1eeb kh\u00f3a: \u201c<strong>&lt;sheetProtection .*\/&gt;<\/strong>\u201d (kh\u00f4ng bao g\u1ed3m d\u1ea5u nh\u00e1y k\u00e9p).<\/p>\n<p><strong>B\u01b0\u1edbc 5:<\/strong> Ch\u1ecdn <strong>Replace All in All Opened Documents<\/strong> (nh\u1ea5n ALT+O).<\/p>\n<p><strong>B\u01b0\u1edbc 6:<\/strong> Nh\u1ea5n <strong>CTRL+SHIFT+S<\/strong>, ho\u1eb7c ch\u1ecdn File =&gt; Save all \u0111\u1ec3 l\u01b0u l\u1ea1i t\u1ea5t c\u1ea3.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/sheet-protection-remove-all.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23294\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%201364%20583'%3E%3C\/svg%3E\" alt=\"\" width=\"1364\" height=\"583\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sheet-protection-remove-all.jpg 1364w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/sheet-protection-remove-all-600x256.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/sheet-protection-remove-all-300x128.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/sheet-protection-remove-all-768x328.jpg 768w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/sheet-protection-remove-all-1024x438.jpg 1024w\" data-lazy-sizes=\"(max-width: 1364px) 100vw, 1364px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sheet-protection-remove-all.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23294\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/sheet-protection-remove-all.jpg\" width=\"1364\" height=\"583\" title=\"sheet-protection-remove-all\"><\/a><\/p>\n<\/li>\n<\/ol>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Dong_goi_file_lai_voi_dinh_dang_file_zip_va_doi_ten_nhu_cu\"><\/span><strong>\u0110\u00f3ng g\u00f3i file l\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng file .zip, v\u00e0 \u0111\u1ed5i t\u00ean nh\u01b0 c\u0169.<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Sau khi ho\u00e0n t\u1ea5t c\u00e1c ph\u1ea7n b\u00ean tr\u00ean, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m t\u1ea5t c\u1ea3 ho\u1eb7c ch\u1ec9 m\u1ed9t trong c\u00e1c \u0111\u1ec1 m\u1ee5c nh\u1ecf b\u00ean tr\u00ean. Sau khi ho\u00e0n t\u1ea5t\u00a0ph\u1ea7n tr\u00ean, ch\u00fang ta l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>B\u01b0\u1edbc 1: Ra ngo\u00e0i th\u01b0 m\u1ee5c ch\u1ee9a\u00a0sau khi gi\u1ea3i n\u00e9n ban \u0111\u1ea7u. Ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c file, v\u00e0 ch\u1ecdn 7zip -&gt; Ch\u1ecdn Add to \u201c[t\u00ean file\u2026].zip\u201d. \u0110\u1ec3 n\u00e9n l\u1ea1i to\u00e0n b\u1ed9 th\u01b0 m\u1ee5c v\u00e0 file v\u00e0o trong file .zip.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/zip-file-7zip.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23290\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20882%20343'%3E%3C\/svg%3E\" alt=\"\" width=\"882\" height=\"343\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/zip-file-7zip.jpg 882w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/zip-file-7zip-600x233.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/zip-file-7zip-300x117.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/zip-file-7zip-768x299.jpg 768w\" data-lazy-sizes=\"(max-width: 882px) 100vw, 882px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/zip-file-7zip.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23290\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/zip-file-7zip.jpg\" width=\"882\" height=\"343\" title=\"zip-file-7zip\"><\/a><\/p>\n<p>B\u01b0\u1edbc 2: Ti\u1ebfn h\u00e0nh \u0111\u1ed5i t\u00ean v\u00e0 m\u1edf file. L\u01b0u \u00fd, file b\u1ea1n ban \u0111\u1ea7u theo \u0111\u1ecbnh d\u1ea1ng th\u1ebf n\u00e0o th\u00ec \u0111\u1ed5i l\u1ea1i nh\u01b0 v\u1eady. (N\u1ebfu ban \u0111\u1ea7u l\u00e0: .xlsx, th\u00ec s\u1ebd l\u00e0 .xlsx, t\u01b0\u01a1ng t\u1ef1 .xlsm, s\u1ebd l\u00e0 .xlsm).<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2018\/10\/rename-file-zip-to-xlsx.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23291\" src=\"\/\/www.w3.org\/2000\/svg'%20viewBox='0%200%20924%20198'%3E%3C\/svg%3E\" alt=\"\" width=\"924\" height=\"198\" data-lazy-srcset=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rename-file-zip-to-xlsx.jpg 924w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/rename-file-zip-to-xlsx-600x129.jpg 600w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/rename-file-zip-to-xlsx-300x64.jpg 300w, https:\/\/blog.hocexcel.online\/wp-content\/uploads\/2018\/10\/rename-file-zip-to-xlsx-768x165.jpg 768w\" data-lazy-sizes=\"(max-width: 924px) 100vw, 924px\" data-lazy-src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rename-file-zip-to-xlsx.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-23291\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rename-file-zip-to-xlsx.jpg\" width=\"924\" height=\"198\" title=\"rename-file-zip-to-xlsx\"><\/a><\/p>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"File_xlsb_thi_khong_giong_cho_lam_Phai_lam_sao\"><\/span>File .xlsb th\u00ec kh\u00f4ng gi\u1ed1ng cho l\u1eafm? Ph\u1ea3i l\u00e0m sao?<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi file theo \u0111\u1ecbnh d\u1ea1ng Binary, b\u1ea1n m\u1edf ra s\u1ebd kh\u00f4ng t\u00ecm th\u1ea5y <strong>.xml<\/strong> m\u00e0 ch\u1ec9 th\u1ea5y <strong>.bin<\/strong>, v\u1eady l\u00e0m sao \u0111\u1ec3 s\u1eeda?<br \/>\n\u0110\u01a1n gi\u1ea3n, h\u00e3y m\u1edf file v\u00e0 l\u01b0u l\u1ea1i v\u1edbi \u0111\u1ecbnh d\u1ea1ng<strong> .xlsx, <\/strong>ho\u1eb7c<strong> .xlsm <\/strong>(n\u1ebfu c\u00f3 macro)\u00a0\u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c vi\u1ec7c tr\u00ean. Xong xu\u00f4i, ta l\u1ea1i l\u01b0u tr\u1edf l\u1ea1i .xlsb.<\/p>\n<\/li>\n<li>\n<h4><span class=\"ez-toc-section\" id=\"Co_cach_nao_nhanh_hon_khong_Co_VBA\"><\/span>C\u00f3 c\u00e1ch n\u00e0o nhanh h\u01a1n kh\u00f4ng? C\u00f3 VBA!<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>V\u1edbi VBA b\u1ea1n ho\u00e0n to\u00e0n c\u00f3 th\u1ec3 l\u00e0m vi\u1ec7c n\u00e0y ch\u1ec9 v\u1edbi c\u00e1i click chu\u1ed9t \u0111\u1ec3 th\u1ef1c hi\u1ec7n to\u00e0n b\u1ed9 c\u00e1c vi\u1ec7c tr\u00ean.<br \/>\nC\u00f9ng \u0111\u00f3n ch\u1edd t\u1eadp 3, v\u1edbi VBA.<\/p>\n<\/li>\n<\/ol>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>V\u1edbi b\u00e0i B\u00ed k\u00edp gi\u1ea3m c\u00e2n gi\u1ea3m dung l\u01b0\u1ee3ng cho file Excel t\u1eadp 1, ch\u00fang..<\/p>\n","protected":false},"author":1,"featured_media":4524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4523","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\/4523","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=4523"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4523\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4524"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4523"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4523"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4523"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}