{"id":8697,"date":"2024-01-01T00:00:31","date_gmt":"2023-12-31T20:30:31","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=8697"},"modified":"2024-09-26T13:27:54","modified_gmt":"2024-09-26T09:57:54","slug":"%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/","title":{"rendered":"\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 Personal Macro"},"content":{"rendered":"<p>\u0628\u0631\u0627\u06cc \u062f\u0627\u0634\u062a\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632 \u0631\u0627 \u0628\u0627 \u062f\u0642\u062a \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0627\u0631\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 \u0633\u0631\u0639\u062a \u0628\u0627\u0644\u0627\u062a\u0631 \u0648 \u0628\u0647\u062a\u0631 \u067e\u06cc\u0634 \u0628\u0628\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u062f\u0631 \u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 <a href=\"https:\/\/officebaz.ir\/ex\/%da%86%da%a9-%d8%a8%d8%a7%da%a9%d8%b3-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84\/\" target=\"_blank\" rel=\"noopener\">\u0686\u06a9 \u0628\u0627\u06a9\u0633 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a> \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645.<\/p>\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title ez-toc-toggle\" style=\"cursor:pointer\">\u0641\u0647\u0631\u0633\u062a \u0645\u062d\u062a\u0648\u0627<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%D8%B6%D8%A7%D9%81%D9%87_%DA%A9%D8%B1%D8%AF%D9%86_Personal_Macro_%D8%A8%D9%87_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 Personal Macro \u0628\u0647 \u0627\u06a9\u0633\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%D8%A7%D9%85%DA%A9%D8%A7%D9%86%D8%A7%D8%AA_%D9%88%DB%8C%DA%98%D9%87_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0627\u0641\u0632\u0648\u062f\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%DA%86%DA%A9_%D8%A8%D8%A7%DA%A9%D8%B3_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\" >\u0627\u0641\u0632\u0648\u062f\u0646 \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D9%86%D8%B1%D8%AE_%D8%A7%D8%B1%D8%B2_%D8%A8%D9%87_%D8%B5%D9%88%D8%B1%D8%AA_%D8%A2%D9%86%D9%84%D8%A7%DB%8C%D9%86_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0646\u0645\u0627\u06cc\u0634 \u0646\u0631\u062e \u0627\u0631\u0632 \u0628\u0647 \u0635\u0648\u0631\u062a \u0622\u0646\u0644\u0627\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%B3%D8%A7%D8%AE%D8%AA_%D9%BE%D9%88%D8%B4%D9%87_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\" >\u0633\u0627\u062e\u062a \u067e\u0648\u0634\u0647 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%B3%D9%88%D8%B1%D8%AF_%D9%82%D9%88%DB%8C_%D9%88_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\" >\u0627\u06cc\u062c\u0627\u062f \u067e\u0633\u0648\u0631\u062f \u0642\u0648\u06cc \u0648 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%AA%D9%87%DB%8C%D9%87_%D9%BE%D8%B4%D8%AA%DB%8C%D8%A8%D8%A7%D9%86_%D8%A7%D8%B2_%D9%81%D8%A7%DB%8C%D9%84_%D8%A7%DA%A9%D8%B3%D9%84\" >\u062a\u0647\u06cc\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%85%D8%AD%D8%AF%D9%88%D8%AF%D9%87_%D9%86%D8%A7%D9%85_%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D8%B1_%D8%B4%DB%8C%D8%AA\" >\u0627\u06cc\u062c\u0627\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0634\u06cc\u062a<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/officebaz.ir\/ex\/%d8%a7%d9%85%da%a9%d8%a7%d9%86%d8%a7%d8%aa-%d9%88%db%8c%da%98%d9%87-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%B4%DB%8C%D8%AA_INDEX_%D8%B4%D8%A7%D9%85%D9%84_%D9%86%D8%A7%D9%85_%D8%AA%D9%85%D8%A7%D9%85_%D8%B4%DB%8C%D8%AA%D9%87%D8%A7\" >\u0627\u06cc\u062c\u0627\u062f \u0634\u06cc\u062a INDEX \u0634\u0627\u0645\u0644 \u0646\u0627\u0645 \u062a\u0645\u0627\u0645 \u0634\u06cc\u062a\u0647\u0627<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B6%D8%A7%D9%81%D9%87_%DA%A9%D8%B1%D8%AF%D9%86_Personal_Macro_%D8%A8%D9%87_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 Personal Macro \u0628\u0647 \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u0633\u0639\u06cc \u06a9\u0646\u06cc\u062f \u062f\u0631 \u0622\u0646 \u0648\u0627\u062d\u062f \u0647\u0645\u06cc\u0646 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0628\u0627\u0632 \u0628\u0627\u0634\u062f \u060c \u0645\u0647\u0645 \u0646\u06cc\u0633\u062a \u06a9\u0647 \u0641\u0627\u06cc\u0644 \u062f\u0627\u0631\u0627\u06cc \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0628\u0627\u0634\u062f \u06cc\u0627 \u062e\u0627\u0645 \u0628\u0627\u0634\u062f . \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0637\u06cc \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0645\u0627\u06a9\u0631\u0648\u0647\u0627\u06cc \u0634\u062e\u0635\u06cc \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 \u062a\u0645\u0627\u0645 \u0641\u0627\u06cc\u0644\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0627\u06cc\u0646 \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f.<\/p>\n<ol>\n<li>\u0628\u0647 \u062a\u0628 Developer \u0628\u0631\u0648\u06cc\u062f \u0648 \u0631\u0648\u06cc \u06af\u0632\u06cc\u0646\u0647 Record Macro \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u062f\u0631 \u067e\u0646\u062c\u0631\u0647 \u0628\u0627\u0632 \u0634\u062f\u0647 \u06af\u0632\u06cc\u0646\u0647 Personal Macro \u0631\u0627 \u0645\u0627\u0646\u0646\u062f \u062a\u0635\u0648\u06cc\u0631 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f.<\/li>\n<li>\u0631\u0648 \u06af\u0632\u06cc\u0646\u0647 OK \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f .<\/li>\n<li>\u062d\u0627\u0644\u0627 \u0631\u0648\u06cc Stop Recording \u06a9\u0644\u06cc\u06a9 \u06a9\u0646\u06cc\u062f .<\/li>\n<li>\u0628\u0627 \u0632\u062f\u0646 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc Alt + F11 \u0628\u0647 \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0628\u0631\u0648\u06cc\u062f \u060c \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u06cc\u062f \u06a9\u0647 Personal.xlsb \u0627\u0636\u0627\u0641\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/li>\n<li>\u0641\u0627\u06cc\u0644 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f \u060c \u06a9\u0627\u0631 \u062a\u0645\u0627\u0645 \u0627\u0633\u062a \u0648 \u0628\u062e\u0634 \u0627\u0648\u0644 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f\u0647 \u0627\u06cc\u062f.<\/li>\n<\/ol>\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"571\" height=\"457\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro1.png\" alt=\"\u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644\" class=\"wp-image-8698\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro1.png 571w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro1-300x240.png 300w\" sizes=\"(max-width: 571px) 100vw, 571px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%D8%A7%D9%85%DA%A9%D8%A7%D9%86%D8%A7%D8%AA_%D9%88%DB%8C%DA%98%D9%87_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0627\u0641\u0632\u0648\u062f\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0628\u062e\u0634 \u0627\u0648\u0644 \u06a9\u0627\u0631 \u0631\u0627 \u06a9\u0647 \u062f\u0631 \u0648\u0627\u0642\u0639 \u06cc\u06a9 \u0628\u0627\u0631 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u0631\u0627 \u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u0642\u0628\u0644 \u0627\u0646\u062c\u0627\u0645 \u062f\u0627\u062f\u06cc\u0645 \u0648 \u062d\u0627\u0644\u0627 \u0648\u0642\u062a \u0622\u0646 \u0631\u0633\u06cc\u062f\u0647 \u06a9\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u0645 \u0648 \u06a9\u0627\u0641\u06cc\u0633\u062a \u06a9\u0647 \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 \u0648 \u0627\u0632 \u0627\u06a9\u0633\u0644 \u0644\u0630\u062a \u0628\u06cc\u0634\u062a\u0631\u06cc \u0628\u0628\u0631\u06cc\u0645.<\/p>\n<ul>\n<li>\u0628\u0627 \u0632\u062f\u0646 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc Alt + F11 \u0628\u0647 \u0642\u0633\u0645\u062a \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0627\u06a9\u0633\u0644 \u0645\u06cc \u0631\u0648\u06cc\u0645<\/li>\n<li>\u062f\u0631 \u0642\u0633\u0645\u062a \u0686\u067e \u06a9\u0647 \u0641\u0627\u06cc\u0644\u0647\u0627 \u0648 \u0622\u0628\u062c\u06a9\u062a\u0647\u0627 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u0631\u0648\u06cc <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/create-and-save-all-your-macros-in-a-single-workbook-66c97ab3-11c2-44db-b021-ae005a9bc790\" target=\"_blank\" rel=\"noopener\">Personal.xlsb<\/a> \u06a9\u0644\u06cc\u06a9 \u0645\u06cc\u06a9\u0646\u06cc\u0645.<\/li>\n<li>\u067e\u0648\u0634\u0647 Module \u0631\u0627 \u0628\u0627\u0632 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 Module1 \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u06cc \u06a9\u0646\u06cc\u0645\u00a0<\/li>\n<li>\u0646\u0627\u0645 \u0622\u0646 \u0631\u0627 \u0628\u0647 Main \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u062f\u0647\u06cc\u0645 \u06a9\u0647 \u0627\u0644\u0628\u062a\u0647 \u0627\u06cc\u0646 \u062f\u0644\u062e\u0648\u0627\u0647 \u0627\u0633\u062a .<\/li>\n<li>\u0631\u0648\u06cc Main \u062f\u0627\u0628\u0644 \u06a9\u0644\u06cc\u06a9 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u0648 \u062d\u0627\u0644\u0627 \u0641\u0636\u0627\u06cc \u062e\u0627\u0644\u06cc \u0633\u0645\u062a \u0631\u0627\u0633\u062a \u0622\u0645\u0627\u062f\u0647 \u0627\u0633\u062a<\/li>\n<\/ul>\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"946\" height=\"630\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro2.png\" alt=\"personal macro\" class=\"wp-image-8699\" srcset=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro2.png 946w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro2-300x200.png 300w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro2-768x511.png 768w, https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2023\/12\/PersonalMacro2-600x400.png 600w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%DA%86%DA%A9_%D8%A8%D8%A7%DA%A9%D8%B3_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\"><\/span>\u0627\u0641\u0632\u0648\u062f\u0646 \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0642\u0628\u0644\u0627 \u0645\u0641\u0635\u0644 \u062f\u0631 \u0645\u0648\u0631\u062f \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u0648 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0627\u0647\u0645\u06cc\u062a \u0622\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0648\u0631\u062f \u0627\u0632 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u0642\u0631\u0627\u0631 \u0627\u0633\u062a \u06a9\u0647 \u0628\u0647 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645 . \u06a9\u0627\u0641\u06cc\u0633\u062a \u06a9\u0647 \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0645\u0627\u0698\u0648\u0644 Main \u06a9\u0647 \u062f\u0631 \u0645\u0631\u0627\u062d\u0644 \u0642\u0628\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0631\u062f\u06cc\u0645 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u0645.<\/p>\n\n<div class=\"lightweight-accordion\"><details><summary class=\"lightweight-accordion-title\"><span>\u06a9\u062f\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0686\u06a9 \u0628\u0627\u06a9\u0633<\/span><\/summary><div class=\"lightweight-accordion-body\">\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vhdl&quot;,&quot;mime&quot;:&quot;text\/x-vhdl&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VHDL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vhdl&quot;}\">Sub AddCheckboxes()\n    Dim targetRange As Range\n    Dim cell As Range\n    Dim checkbox As Object\n    Dim response As VbMsgBoxResult\n    Dim defaultAddress As String\n    Dim strMasg As String\n    strMsg = ChrW(1605) &amp; ChrW(1581) &amp; ChrW(1583) &amp; ChrW(1608) &amp; ChrW(1583) &amp; ChrW(1607) &amp; ChrW(32) &amp; ChrW(1575) &amp; ChrW(1606) &amp; ChrW(1578) &amp; ChrW(1582) &amp; ChrW(1575) &amp; ChrW(1576) &amp; ChrW(1740) &amp; ChrW(32) &amp; ChrW(1583) &amp; ChrW(1575) &amp; ChrW(1585) &amp; ChrW(1575) &amp; ChrW(1740) &amp; ChrW(32) &amp; ChrW(1575) &amp; ChrW(1591) &amp; ChrW(1604) &amp; ChrW(1575) &amp; ChrW(1593) &amp; ChrW(1575) &amp; ChrW(1578) &amp; ChrW(32) &amp; ChrW(1575) &amp; ChrW(1587) &amp; ChrW(1578) &amp; ChrW(32) &amp; ChrW(1548) &amp; ChrW(32) &amp; ChrW(1580) &amp; ChrW(1575) &amp; ChrW(1740) &amp; ChrW(1711) &amp; ChrW(1586) &amp; ChrW(1740) &amp; ChrW(1606) &amp; ChrW(32) &amp; ChrW(1588) &amp; ChrW(1608) &amp; ChrW(1583) &amp; ChrW(32) &amp; ChrW(1567)\n    \n    defaultAddress = Selection.Address\n    Set targetRange = Selection\n    If targetRange Is Nothing Then\n        Exit Sub\n    End If\n    For Each cell In targetRange\n        If cell.Value &lt;&gt; &quot;&quot; Then\n            response = MsgBox(strMsg, vbYesNo + vbMsgBoxRight + vbExclamation, &quot;officebaz.ir&quot;)\n            If response = vbNo Then Exit Sub\n            Exit For\n        End If\n    Next cell\n    For Each cell In targetRange.Cells\n        cell.Font.Color = cell.Interior.Color       \n        Set checkbox = ActiveSheet.CheckBoxes.Add(cell.Left, cell.Top, cell.Width, cell.Height)       \n        With checkbox\n            .LinkedCell = cell.Address\n            .Caption = &quot;&quot;\n            .Name = &quot;chk_&quot; &amp; cell.Address\n            .Width = 14\n            .Height = 14\n            .Top = cell.Top + (cell.Height - .Height) \/ 2\n            .Left = cell.Left + (cell.Width - .Width) \/ 2\n        End With\n    Next cell\nEnd Sub<\/pre><\/div>\n\n<\/div><\/details><\/div>\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u0645 \u06a9\u062f\u0647\u0627\u06cc \u0628\u0627\u0644\u0627 \u0631\u0627 \u062f\u0631 \u062a\u0645\u0627\u0645 \u0641\u0627\u06cc\u0644\u0647\u0627\u06cc \u0627\u06a9\u0633\u0644 \u0627\u06cc\u0646 \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u0631\u0627\u0646 \u06a9\u0646\u06cc\u0645 \u06a9\u0627\u0641\u06cc\u0633\u062a \u06a9\u0627\u0631\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0648\u06cc\u062f\u06cc\u0648 \u0622\u0645\u0648\u0632\u0634\u06cc \u0627\u0648\u0644 \u0645\u0637\u0644\u0628 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0645 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f .<\/p>\n\n\n<h3 class=\"wp-block-heading\">\u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0634\u0645\u0627 \u0628\u0631\u0627\u06cc \u062a\u06a9\u0645\u06cc\u0644 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644<\/h3>\n\n\n<p>\u062a\u0627 \u0627\u06cc\u0646\u062c\u0627 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0641\u0642\u0637 \u0646\u062d\u0648\u0647 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 \u0631\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u06cc\u0645 \u0648 \u0642\u0637\u0639\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0642\u0627\u0628\u0644\u06cc\u062a\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631\u06cc \u0628\u0647 \u0627\u06a9\u0633\u0644 \u0627\u0641\u0632\u0648\u062f \u062a\u0627 \u06a9\u0627\u0631 \u0631\u0627 \u0633\u0631\u0639 \u062a\u0631 \u0648 \u0628\u0647\u062a\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645 .<\/p>\n<p>\u0686\u06cc\u0632\u06cc \u06a9\u0647 \u0628\u0647 \u0641\u06a9\u0631 \u062e\u0648\u062f\u0645 \u0645\u06cc \u0631\u0633\u062f \u062a\u0627 \u0627\u06cc\u0646\u062c\u0627 \u0627\u06cc\u0646\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u06af\u0632\u06cc\u0646\u0647 \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0642\u06cc\u0645\u062a \u0644\u062d\u0638\u0647 \u0627\u06cc \u062f\u0644\u0627\u0631 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u0645.<\/p>\n<p>\u0634\u0645\u0627 \u0627\u06af\u0631 \u0686\u06cc\u0632\u06cc \u062f\u06cc\u06af\u0631\u06cc \u0628\u0647 \u0630\u0647\u0646\u062a\u0627\u0646 \u0645\u06cc \u0631\u0633\u062f \u062a\u0627 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0627\u0641\u0632\u0627\u06cc\u0634 \u062f\u0647\u06cc\u0645 \u062d\u062a\u0645\u0627 \u062f\u0631 \u0642\u0633\u0645\u062a \u0646\u0638\u0631\u0627\u062a \u0639\u0646\u0648\u0627\u0646 \u0646\u0645\u0627\u0626\u06cc\u062f.<\/p>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C%D8%B4_%D9%86%D8%B1%D8%AE_%D8%A7%D8%B1%D8%B2_%D8%A8%D9%87_%D8%B5%D9%88%D8%B1%D8%AA_%D8%A2%D9%86%D9%84%D8%A7%DB%8C%D9%86_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0646\u0645\u0627\u06cc\u0634 \u0646\u0631\u062e \u0627\u0631\u0632 \u0628\u0647 \u0635\u0648\u0631\u062a \u0622\u0646\u0644\u0627\u06cc\u0646 \u062f\u0631 \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0628\u062e\u0634 \u0627\u0632 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u062d\u062b \u0646\u0645\u0627\u06cc\u0634 \u0642\u06cc\u0645\u062a \u062f\u0644\u0627\u0631 \u0648 \u062f\u0631\u0647\u0645 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0622\u0646\u0644\u0627\u06cc\u0646 \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647 \u0627\u06a9\u0633\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u0645 .\u00a0<\/p>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0648 \u0631\u0648\u0634 \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u06a9\u0631\u062f\u0645 \u06a9\u0647 \u0647\u0631 \u062f\u0648 \u0631\u0648\u0634 \u062f\u0631 \u0648\u06cc\u062f\u06cc\u0648 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0648 \u0628\u0647 \u062f\u0644\u06cc\u0644 \u0645\u0634\u06a9\u0644\u06cc \u06a9\u0647 \u0631\u0648\u0634 \u0627\u0648\u0644 \u062f\u0627\u0634\u062a \u060c \u0628\u0647 \u0646\u0627\u0686\u0627\u0631 \u0627\u0632 \u0631\u0648\u0634 \u0628\u0639\u062f\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0631\u062f\u0645 \u06a9\u0647 \u0628\u0647 \u0641\u0627\u06cc\u0644 \u06a9\u0645\u06a9\u06cc \u0627\u06a9\u0633\u0644 \u0646\u06cc\u0627\u0632\u06cc \u0646\u062f\u0627\u0631\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0642\u06cc\u0645\u062a \u0627\u0631\u0632\u0647\u0627\u06cc \u062f\u0644\u0627\u0631 \u0648 \u062f\u0631\u0647\u0645 \u0631\u0627 \u0628\u0647 \u0635\u0648\u0631\u062a \u0644\u062d\u0637\u0647 \u0627\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u06a9\u0627\u0641\u06cc\u0633\u062a \u0648\u06cc\u062f\u06cc\u0648 \u0632\u06cc\u0631 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u06a9\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0622\u0646 \u0622\u0648\u0631\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0631\u0627 \u0628\u0647 PERSONALMACRO.XLSB \u06a9\u0647 \u0642\u0628\u0644\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f \u0622\u0646 \u0635\u062d\u0628\u062a \u06a9\u0631\u062f\u06cc\u0645 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f . \u0627\u06cc\u0646 \u0647\u0645 \u06cc\u06a9\u06cc \u062f\u06cc\u06af\u0632 \u0627\u0632 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \ud83d\udc4d<\/p>\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/www.dl.officebaz.ir\/free\/excelLearning\/OfficebazUSDrating.mp4\"><\/video><\/figure>\n\n\n<div class=\"lightweight-accordion\"><details><summary class=\"lightweight-accordion-title\"><span>\u06a9\u062f\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u0646\u0645\u0627\u06cc\u0634 \u0642\u06cc\u0645\u062a \u0627\u0631\u0632 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/span><\/summary><div class=\"lightweight-accordion-body\">\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vhdl&quot;,&quot;mime&quot;:&quot;text\/x-vhdl&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VHDL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vhdl&quot;}\">Sub ExtractTableFromWebAndFormat()\n    ' \u0645\u062a\u063a\u064a\u0631\u0647\u0627\n    Dim webURLs(1 To 2) As String\n    Dim html As Object\n    Dim tableNumber As Integer\n    Dim table As Object\n    Dim targetRanges(1 To 2) As Range\n    Dim priceSheet As Worksheet\n\n    ' \u062a\u0646\u0638\u064a\u0645\u0627\u062a \u0627\u0648\u0644\u064a\u0647\n    webURLs(1) = &quot;https:\/\/www.tgju.org\/profile\/price_dollar_rl&quot;\n    webURLs(2) = &quot;https:\/\/www.tgju.org\/profile\/price_aed&quot;\n    tableNumber = 0 ' \u0634\u0645\u0627\u0631\u0647 \u062c\u062f\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\n\n    ' \u0686\u06a9 \u06a9\u0631\u062f\u0646 \u0648 \u062d\u0630\u0641 \u0634\u064a\u062a &quot;Price&quot; \u0627\u06af\u0631 \u0648\u062c\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\n    On Error Resume Next\n    Application.DisplayAlerts = False\n    Sheets(&quot;Price&quot;).Delete\n    Application.DisplayAlerts = True\n    On Error GoTo 0\n\n    ' \u0627\u064a\u062c\u0627\u062f \u0634\u064a\u062a \u062c\u062f\u064a\u062f \u0628\u0627 \u0646\u0627\u0645 &quot;Price&quot;\n    Set priceSheet = Sheets.Add(After:=Sheets(Sheets.Count))\n    priceSheet.Name = &quot;Price&quot;\n\n    ' \u062f\u0631\u062e\u0648\u0627\u0633\u062a \u0628\u0647 \u0648\u0628 \u0633\u0627\u064a\u062a \u0648 \u062f\u0631\u064a\u0627\u0641\u062a \u062c\u062f\u0648\u0644\n    For i = 1 To 2\n        With CreateObject(&quot;MSXML2.ServerXMLHTTP&quot;)\n            .Open &quot;GET&quot;, webURLs(i), False\n            .send\n            Set html = CreateObject(&quot;htmlfile&quot;)\n            html.body.innerHTML = .responseText\n        End With\n\n        ' \u062f\u0631\u064a\u0627\u0641\u062a \u062c\u062f\u0648\u0644 \u0645\u0648\u0631\u062f \u0646\u0638\u0631\n        Set table = html.getElementsByTagName(&quot;table&quot;)(tableNumber)\n\n        ' \u062a\u0639\u064a\u064a\u0646 \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0642\u0635\u062f (\u0633\u0644\u0648\u0644 \u0634\u0631\u0648\u0639)\n        Set targetRanges(i) = priceSheet.Cells(2, (i - 1) * 3 + 1)\n        priceSheet.Range(&quot;a1&quot;).Value = &quot;\u0646\u0631\u062e \u062f\u0644\u0627\u0631&quot;\n        priceSheet.Range(&quot;d1&quot;).Value = &quot;\u0646\u0631\u062e \u062f\u0631\u0647\u0645&quot;\n\n        ' \u0646\u0645\u0627\u064a\u0634 \u062c\u062f\u0648\u0644 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 \u0645\u0642\u0635\u062f\n        InsertTableIntoWorksheet table, targetRanges(i)\n    Next i\n\n    ' \u062a\u063a\u064a\u064a\u0631\u0627\u062a \u0641\u0631\u0645\u062a \u062f\u0647\u064a\n    ApplyFormattingToSheet priceSheet\nEnd Sub\n\nSub InsertTableIntoWorksheet(table As Object, targetRange As Range)\n    ' \u0645\u062a\u063a\u064a\u0631\u0647\u0627\n    Dim rowCounter As Long\n    Dim columnCounter As Integer\n    Dim tableRow As Object\n    Dim tableCell As Object\n\n    ' \u0634\u0631\u0648\u0639 \u0627\u0632 \u0633\u0644\u0648\u0644 \u0645\u0642\u0635\u062f\n    rowCounter = targetRange.Row\n    columnCounter = targetRange.Column\n\n    ' \u067e\u064a\u0645\u0627\u064a\u0634 \u0633\u0637\u0631\u0647\u0627 \u0648 \u0633\u062a\u0648\u0646\u0647\u0627\u064a \u062c\u062f\u0648\u0644\n    For Each tableRow In table.Rows\n        For Each tableCell In tableRow.Cells\n            ' \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0646 \u0645\u0642\u062f\u0627\u0631 \u062f\u0631 \u0648\u0631\u06a9\u0634\u064a\u062a\n            targetRange.Offset(rowCounter - targetRange.Row, columnCounter - targetRange.Column).Value = tableCell.innerText\n            columnCounter = columnCounter + 1\n        Next tableCell\n        ' \u0628\u0627\u0632\u0646\u0634\u0627\u0646\u064a \u0634\u0645\u0627\u0631\u0647 \u0633\u062a\u0648\u0646 \u0628\u0647 \u0633\u062a\u0648\u0646 \u0645\u0642\u0635\u062f \u0628\u0631\u0627\u064a \u0634\u0631\u0648\u0639 \u0633\u062a\u0648\u0646 \u062c\u062f\u064a\u062f\n        columnCounter = targetRange.Column\n        rowCounter = rowCounter + 1\n    Next tableRow\n\n    ' \u062a\u0646\u0638\u064a\u0645\u0627\u062a \u0646\u0645\u0627\u064a\u0634 \u0648\u0631\u06a9\u0634\u064a\u062a\n    With targetRange.Resize(1, 2).Interior\n        .Color = RGB(200, 200, 200) ' \u062a\u063a\u064a\u064a\u0631 \u0631\u0646\u06af \u0628\u06a9\u200c\u06af\u0631\u0627\u0646\u062f \u062f\u0648 \u0633\u062a\u0648\u0646 \u0627\u0648\u0644\n    End With\n    targetRange.Resize(, 2).EntireColumn.AutoFit ' \u0627\u0646\u062f\u0627\u0632\u0647\u200c\u06af\u064a\u0631\u064a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0639\u0631\u0636 \u062f\u0648 \u0633\u062a\u0648\u0646 \u0627\u0648\u0644\nEnd Sub\n\nSub ApplyFormattingToSheet(ws As Worksheet)\n    ' \u0645\u062d\u062f\u0648\u062f\u0647\u200c\u0647\u0627\u064a\u064a \u06a9\u0647 \u0628\u0627\u064a\u062f \u0641\u0631\u0645\u062a \u062f\u0647\u064a \u0634\u0648\u0646\u062f\n    Dim rangeToFormat As Range\n    Set rangeToFormat = Union(ws.Range(&quot;A2:B12&quot;), ws.Range(&quot;D2:E12&quot;))\n\n    ' \u062a\u063a\u064a\u064a\u0631 \u0641\u0648\u0646\u062a \u0628\u0647 VazirMatn FD\n    ws.Cells.Font.Name = &quot;VazirMatn FD&quot;\n\n    ActiveSheet.DisplayRightToLeft = True\n    ' \u063a\u064a\u0631\u0641\u0639\u0627\u0644 \u06a9\u0631\u062f\u0646 \u062e\u0637\u0648\u0637 \u0634\u0628\u06a9\u0647 (Gridlines)\n    ws.Activate\n    ActiveWindow.DisplayGridlines = False\n\n\n    rangeToFormat.Borders(xlDiagonalDown).LineStyle = xlNone\n    rangeToFormat.Borders(xlDiagonalUp).LineStyle = xlNone\n    With rangeToFormat.Borders(xlEdgeLeft)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    With rangeToFormat.Borders(xlEdgeTop)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    With rangeToFormat.Borders(xlEdgeBottom)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    With rangeToFormat.Borders(xlEdgeRight)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    With rangeToFormat.Borders(xlInsideVertical)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    With rangeToFormat.Borders(xlInsideHorizontal)\n        .LineStyle = xlContinuous\n        .ThemeColor = 1\n        .TintAndShade = -0.499984740745262\n        .Weight = xlThin\n    End With\n    Columns(&quot;A:A&quot;).EntireColumn.AutoFit\n    Columns(&quot;D:D&quot;).EntireColumn.AutoFit\n    Range(&quot;B:B,E:E&quot;).Select\n    Range(&quot;E1&quot;).Activate\n    With Selection\n        .HorizontalAlignment = xlCenter\n        .VerticalAlignment = xlBottom\n        .WrapText = False\n        .Orientation = 0\n        .AddIndent = False\n        .IndentLevel = 0\n        .ShrinkToFit = False\n        .ReadingOrder = xlContext\n        .MergeCells = False\n    End With\n    Range(&quot;A2&quot;).Select\nEnd Sub\n<\/pre><\/div>\n\n<\/div><\/details><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%B3%D8%A7%D8%AE%D8%AA_%D9%BE%D9%88%D8%B4%D9%87_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\"><\/span>\u0633\u0627\u062e\u062a \u067e\u0648\u0634\u0647 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-video\"><video controls poster=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/Folder-1.jpg\" src=\"https:\/\/www.dl.officebaz.ir\/free\/excelLearning\/CraeteFolder.mp4\"><\/video><\/figure>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647 A1:A10 \u0644\u06cc\u0633\u062a\u06cc \u0627\u0632 \u0646\u0627\u0645 \u067e\u0631\u0633\u0646\u0644 \u062f\u0627\u0631\u06cc\u062f \u0648 \u06cc\u0645\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0631\u0627\u06cc \u0647\u0631 \u06a9\u062f\u0627\u0645 \u0627\u0632 \u0622\u0646\u0647\u0627 \u06cc\u06a9 \u067e\u0648\u0634\u0647 \u0628\u0647 \u0646\u0627\u0645 \u0627\u06cc\u0634\u0627\u0646 \u0628\u0633\u0627\u0632\u06cc\u062f \u0648 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u0631\u0627 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u062f \u062e\u06cc\u0644\u06cc \u0633\u0631\u06cc\u0639 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f . \u0686\u0627\u0631\u0647 \u06a9\u0627\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u062f\u0633\u062a\u0648\u0631\u0627\u062a VBA \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0628\u0647 \u0622\u0646 \u062e\u0648\u0627\u0647\u06cc\u0645 \u067e\u0631\u062f\u0627\u062e\u062a.<\/p>\n<p>\u0627\u0644\u0628\u062a\u0647 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u0645 \u062c\u0632\u0626\u06cc \u0627\u0632 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u0646\u0638\u0631 \u0646\u06af\u06cc\u0631\u06cc\u0645 \u060c \u0642\u0628\u0644\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f <a href=\"https:\/\/officebaz.ir\/ex\/%d8%b3%d8%a7%d8%ae%d8%aa-%d9%be%d9%88%d8%b4%d9%87-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84-%d8%a8%d8%b1%d8%a7%db%8c-%d9%87%d8%b1-%d9%81%d8%b1%d8%af-%d8%a8%d8%a7-%db%8c%da%a9-%da%a9%d9%84%db%8c%da%a9\/\" target=\"_blank\" rel=\"noopener\">\u0633\u0627\u062e\u062a \u067e\u0648\u0634\u0647 \u062f\u0631 \u0627\u06a9\u0633\u0644<\/a> \u0627\u0644\u0628\u062a\u0647 \u0628\u0627 \u0631\u0648\u0634\u06cc \u062f\u06cc\u06af\u0631 \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u06a9\u0647 \u0628\u0631\u0631\u0633\u06cc \u0622\u0646 \u0622\u0645\u0648\u0632\u0634 \u0647\u0645 \u062e\u0627\u0644\u06cc \u0627\u0632 \u0644\u0637\u0641 \u0646\u06cc\u0633\u062a .<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0627\u06cc\u0646 \u06a9\u0627\u0631 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0645\u0631\u0627\u062d\u0644 \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f :<\/p>\n<ol>\n<li>\u06a9\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f\u00a0<\/li>\n<li>\u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0627 \u0632\u062f\u0646 Alt + F11 \u0628\u0647 \u06a9\u062f \u0646\u0648\u06cc\u0633\u06cc \u0628\u0631\u0648\u06cc\u062f.<\/li>\n<li>\u0645\u0627\u0698\u0648\u0644 Main \u0627\u0632 \u0641\u0627\u06cc\u0644 Personal Macro.xlsb \u0631\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u06cc\u062f .<\/li>\n<li>\u06a9\u062f\u0647\u0627\u06cc \u06a9\u067e\u06cc \u0634\u062f\u0647 \u0631\u0627 \u0622\u0646\u062c\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f .<\/li>\n<\/ol>\n<p>\u0627\u0644\u0628\u062a\u0647 \u0644\u0627\u0632\u0645 \u0628\u0647 \u0630\u06a9\u0631 \u0627\u0633\u062a \u06a9\u0647 \u062d\u062a\u0645\u0627 \u0648\u06cc\u062f\u06cc\u0648 \u0627\u0628\u062a\u062f\u0627\u06cc\u06cc \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u062f \u062a\u0627 \u062f\u0631 \u062c\u0631\u06cc\u0627\u0646 \u0642\u0631\u0627\u0631 \u0628\u06af\u06cc\u0631\u06cc\u062f \ud83d\ude0e \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062f\u0631 \u06a9\u0627\u0645\u067e\u06cc\u0648\u062a\u0631 \u062e\u0648\u062f \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n\n<div class=\"lightweight-accordion\"><details><summary class=\"lightweight-accordion-title\"><span>\u06a9\u062f\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u0633\u0627\u062e\u062a \u067e\u0648\u0634\u0647<\/span><\/summary><div class=\"lightweight-accordion-body\">\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vhdl&quot;,&quot;mime&quot;:&quot;text\/x-vhdl&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VHDL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vhdl&quot;}\">Sub CreateFoldersBasedOnSelection()\n    Dim selectedRange As Range\n    Dim cell As Range\n    Dim folderPath As String\n    \n    ' \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u0632 \u06a9\u0627\u0631\u0628\u0631\n    On Error Resume Next\n    Set selectedRange = Application.InputBox(&quot;\u0644\u0637\u0641\u0627\u064b \u064a\u06a9 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u064a\u062f:&quot;, Type:=8)\n    On Error GoTo 0\n    \n    ' \u0627\u06af\u0631 \u06a9\u0627\u0631\u0628\u0631 \u06a9\u0646\u0633\u0644 \u06a9\u0631\u062f \u064a\u0627 \u0645\u062d\u062f\u0648\u062f\u0647 \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0634\u062f\u060c \u0627\u0632 \u0627\u062c\u0631\u0627 \u062e\u0627\u0631\u062c \u0634\u0648\u064a\u062f\n    If selectedRange Is Nothing Then\n        Exit Sub\n    End If\n    \n    ' \u0627\u0646\u062a\u062e\u0627\u0628 \u0645\u0633\u064a\u0631 \u0628\u0631\u0627\u064a \u0627\u064a\u062c\u0627\u062f \u067e\u0648\u0634\u0647\u200c\u0647\u0627\n    With Application.FileDialog(msoFileDialogFolderPicker)\n        .Title = &quot;\u0644\u0637\u0641\u0627\u064b \u064a\u06a9 \u0645\u0633\u064a\u0631 \u0628\u0631\u0627\u064a \u0627\u064a\u062c\u0627\u062f \u067e\u0648\u0634\u0647\u200c\u0647\u0627 \u0627\u0646\u062a\u062e\u0627\u0628 \u06a9\u0646\u064a\u062f:&quot;\n        If .Show = -1 Then\n            folderPath = .SelectedItems(1) &amp; &quot;\\&quot;\n        Else\n            Exit Sub\n        End If\n    End With\n    \n    ' \u0627\u064a\u062c\u0627\u062f \u067e\u0648\u0634\u0647 \u0628\u0631\u0627\u064a \u0647\u0631 \u0633\u0644\u0648\u0644 \u062f\u0631 \u0645\u062d\u062f\u0648\u062f\u0647\n    For Each cell In selectedRange\n        Dim cellValue As String\n        cellValue = Trim(cell.Value)\n        \n        ' \u0627\u0637\u0645\u064a\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u064a\u062f \u06a9\u0647 \u0646\u0627\u0645 \u067e\u0648\u0634\u0647 \u062e\u0627\u0644\u064a \u0646\u064a\u0633\u062a\n        If cellValue &lt;&gt; &quot;&quot; Then\n            ' \u0627\u064a\u062c\u0627\u062f \u0645\u0633\u064a\u0631 \u06a9\u0627\u0645\u0644 \u0628\u0627 \u062a\u0631\u06a9\u064a\u0628 \u0645\u0633\u064a\u0631 \u0627\u0635\u0644\u064a \u0648 \u0646\u0627\u0645 \u0633\u0644\u0648\u0644\n            Dim fullPath As String\n            fullPath = folderPath &amp; cellValue\n            \n            ' \u0627\u06af\u0631 \u067e\u0648\u0634\u0647 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0622\u0646 \u0631\u0627 \u0627\u064a\u062c\u0627\u062f \u06a9\u0646\u064a\u062f\n            If Dir(fullPath, vbDirectory) = &quot;&quot; Then\n                MkDir fullPath\n            End If\n        End If\n    Next cell\n    \n    MsgBox &quot;\u067e\u0648\u0634\u0647\u200c\u0647\u0627 \u0628\u0627 \u0645\u0648\u0641\u0642\u064a\u062a \u0627\u064a\u062c\u0627\u062f \u0634\u062f\u0646\u062f!&quot;, vbInformation + vbMsgBoxRight, &quot;Officebaz.ir&quot;\nEnd Sub\n<\/pre><\/div>\n\n<\/div><\/details><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%BE%D8%B3%D9%88%D8%B1%D8%AF_%D9%82%D9%88%DB%8C_%D9%88_%D8%A7%D8%B3%D8%AA%D8%A7%D9%86%D8%AF%D8%A7%D8%B1%D8%AF\"><\/span>\u0627\u06cc\u062c\u0627\u062f \u067e\u0633\u0648\u0631\u062f \u0642\u0648\u06cc \u0648 \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0622\u0645\u0648\u0632\u0634\u06cc \u0642\u0628\u0644\u0627 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u067e\u0633\u0648\u0631\u062f\u0647\u0627\u06cc \u0627\u0633\u062a\u0627\u0646\u062f\u0627\u0631\u062f \u0648 \u0642\u0648\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u0645 \u0628\u0627 \u0686\u0646\u062f \u062e\u0637 \u06a9\u062f \u06a9\u0627\u0631\u06cc \u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 \u06cc\u06a9 \u067e\u0633\u0648\u0631\u062f 16 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631\u06cc \u0642\u0648\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u0648\u062f \u0648 \u0641\u0642\u0637 \u06a9\u0627\u0631\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n<ol>\n<li>\u0645\u0627\u0646\u0646\u062f \u0645\u0631\u0627\u062d\u0644 \u0642\u0628\u0644 \u067e\u06cc\u0634 \u0628\u0631\u0648\u06cc\u062f \u062a\u0627 PersonalMacro.xlsb \u0631\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0648\u06cc\u0631\u0627\u06cc\u0634 \u06a9\u0646\u06cc\u062f<\/li>\n<li>\u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0628\u0647 \u0627\u0646\u062a\u0647\u0627\u06cc \u0645\u0627\u0698\u0648\u0644 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f\u00a0<\/li>\n<li>\u0628\u0631\u0627\u06cc \u0627\u0641\u0632\u0648\u062f\u0646 \u0628\u0647 \u0631\u06cc\u0628\u0648\u0646 \u0647\u0645 \u0627\u0632 \u0647\u0645\u0627\u0646 \u0631\u0648\u0634 \u06a9\u0647 \u062f\u0631 \u0627\u0628\u062a\u062f\u0627\u06cc \u0645\u0637\u0644\u0628 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u06cc\u0645 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f<\/li>\n<\/ol>\n\n<div class=\"lightweight-accordion\"><details><summary class=\"lightweight-accordion-title\"><span>\u06a9\u062f\u0647\u0627\u06cc \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u067e\u0633\u0648\u0631\u062f<\/span><\/summary><div class=\"lightweight-accordion-body\">\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vhdl&quot;,&quot;mime&quot;:&quot;text\/x-vhdl&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VHDL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vhdl&quot;}\">Sub GeneratePassword()\n    Dim characters As String\n    Dim length As Integer\n    Dim i As Integer\n    Dim GeneratedPassword As String\n    ' \u0628\u0631\u0631\u0633\u064a \u0633\u0644\u0648\u0644 \u0641\u0639\u0627\u0644 \u0628\u0631\u0627\u064a \u0648\u062c\u0648\u062f \u062f\u0627\u062f\u0647\n    If ActiveCell.Value &lt;&gt; &quot;&quot; Then\n        MsgBox &quot;\u0633\u0644\u0648\u0644 \u062f\u0627\u0631\u0627\u064a \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0633\u062a&quot;, vbMsgBoxRight + vbInformation, &quot;Officebaz.ir&quot;\n        Exit Sub\n    End If\n\n    characters = &quot;!#$%&amp;'()*+,-.\/0123456789:;&lt;=&gt;?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\\]^_`abcdefghijklmnopqrstuvwxyz}~&quot;\n    length = 16\n    GeneratedPassword = &quot;&quot;\n\n    Randomize\n    For i = 1 To length\n        GeneratedPassword = GeneratedPassword &amp; Mid(characters, Int((Len(characters) * Rnd) + 1), 1)\n    Next i\n    ' \u0646\u0648\u0634\u062a\u0646 \u067e\u0633\u0648\u0631\u062f \u062a\u0648\u0644\u064a\u062f\u0634\u062f\u0647 \u062f\u0631 \u0633\u0644\u0648\u0644 \u0641\u0639\u0644\u064a\n    ActiveCell.Value = GeneratedPassword\nEnd Sub\n<\/pre><\/div>\n\n<\/div><\/details><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%AA%D9%87%DB%8C%D9%87_%D9%BE%D8%B4%D8%AA%DB%8C%D8%A8%D8%A7%D9%86_%D8%A7%D8%B2_%D9%81%D8%A7%DB%8C%D9%84_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u062a\u0647\u06cc\u0647 \u067e\u0634\u062a\u06cc\u0628\u0627\u0646 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0628\u0631\u0627\u06cc \u0627\u06cc\u0646\u06a9\u0647 \u06cc\u06a9 \u0646\u0633\u062e\u0647 \u0627\u0632 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644\u06cc \u06a9\u0647 \u062f\u0631 \u062d\u0627\u0644 \u06a9\u0627\u0631 \u0628\u0627 \u0622\u0646 \u0647\u0633\u062a\u06cc\u062f \u0631\u0627 \u0628\u0647 \u0631\u0627\u062d\u062a\u06cc \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f \u0648 \u0628\u0647 \u0627\u0646 \u062f\u0633\u062a\u0631\u0633\u06cc \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f .<\/p>\n<p>\u0645\u0631\u0627\u062d\u0644 \u0627\u0648\u0644\u06cc\u0647 \u06a9\u0627\u0631 \u0645\u0627\u0646\u0646\u062f \u0627\u0628\u062a\u062f\u0627\u06cc \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0647\u0633\u062a \u0648 \u0641\u0642\u0637 \u0628\u0627\u06cc\u062f \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u0647\u0645 \u0628\u0647 \u0641\u0627\u06cc\u0644 PersonalMacro.xlsb \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vhdl&quot;,&quot;mime&quot;:&quot;text\/x-vhdl&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VHDL&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vhdl&quot;}\">Sub officebazBackup()\n\n    Dim CurrentFileName As String\n    Dim BackupPath As String\n    Dim BackupFileName As String\n    Dim FileExtension As String\n    Dim fso As Object\n    \n    ' \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0646\u0627\u0645 \u0641\u0627\u064a\u0644 \u062c\u0627\u0631\u064a\n    CurrentFileName = ActiveWorkbook.FullName\n    \n    ' \u0645\u0634\u062e\u0635 \u06a9\u0631\u062f\u0646 \u0645\u0633\u064a\u0631 \u067e\u0648\u0634\u0647 backup\n    BackupPath = &quot;D:\\backup\\&quot;\n    \n    ' \u0628\u0631\u0631\u0633\u064a \u0648\u062c\u0648\u062f \u067e\u0648\u0634\u0647 backup \u0648 \u0627\u064a\u062c\u0627\u062f \u0622\u0646 \u0627\u06af\u0631 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\n    If Dir(BackupPath, vbDirectory) = &quot;&quot; Then\n        MkDir BackupPath\n    End If\n    \n    ' \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u067e\u0633\u0648\u0646\u062f \u0641\u0627\u064a\u0644 \u062c\u0627\u0631\u064a\n    FileExtension = Right(CurrentFileName, Len(CurrentFileName) - InStrRev(CurrentFileName, &quot;.&quot;))\n    \n    ' \u0627\u064a\u062c\u0627\u062f \u064a\u06a9 \u0634\u064a\u0621 FileSystemObject\n    Set fso = CreateObject(&quot;Scripting.FileSystemObject&quot;)\n    \n    ' \u062a\u0646\u0638\u064a\u0645 \u0646\u0627\u0645 \u0641\u0627\u064a\u0644 \u0628\u06a9 \u0622\u067e \u0628\u0627 \u0646\u0627\u0645 \u0641\u0627\u064a\u0644 \u062c\u0627\u0631\u064a\u060c \u062a\u0627\u0631\u064a\u062e \u0648 \u0632\u0645\u0627\u0646 \u0641\u0639\u0644\u064a \u0648 \u067e\u0633\u0648\u0646\u062f \u0645\u0648\u0631\u062f \u0646\u0638\u0631\n    BackupFileName = BackupPath &amp; fso.GetBaseName(CurrentFileName) &amp; &quot;_Backup_&quot; &amp; Format(Now, &quot;yyyy-mm-dd_hhmmss&quot;) &amp; &quot;.&quot; &amp; FileExtension\n    \n    ' \u0630\u062e\u064a\u0631\u0647 \u0641\u0627\u064a\u0644 \u062c\u0627\u0631\u064a \u0628\u0627 \u0646\u0627\u0645 \u062c\u062f\u064a\u062f\n    ActiveWorkbook.Save\n    ActiveWorkbook.SaveAs BackupFileName\n    \n    ' \u0628\u0633\u062a\u0646 \u0641\u0627\u064a\u0644 \u062c\u0627\u0631\u064a\n    '    ActiveWorkbook.Close SaveChanges:=False\n    \n    ' \u0646\u0645\u0627\u064a\u0634 \u067e\u064a\u0627\u0645 \u0628\u0647 \u06a9\u0627\u0631\u0628\u0631\n    MsgBox &quot;\u0641\u0627\u064a\u0644 \u0628\u0627 \u0645\u0648\u0641\u0642\u064a\u062a \u0630\u062e\u064a\u0631\u0647 \u0634\u062f\u0647 \u0648 \u064a\u06a9 \u0646\u0633\u062e\u0647 \u0647\u0645 \u062f\u0631 \u0645\u0633\u064a\u0631 &quot; &amp; vbCrLf &amp; vbCrLf &amp; BackupPath &amp; vbCrLf &amp; vbCrLf &amp; &quot; \u0642\u0631\u0627\u0631 \u06af\u0631\u0641\u062a &quot;, vbInformation + vbMsgBoxRight, &quot;Officebaz.ir&quot;\nEnd Sub<\/pre><\/div>\n\n\n<p>\u0641\u0642\u0637 \u062f\u0642\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u06a9\u062f\u0647\u0627 \u060c \u0645\u0633\u06cc\u0631 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0641\u0627\u06cc\u0644\u0647\u0627 D:\\Backup \u0645\u06cc \u0628\u0627\u0634\u062f \u06a9\u0647 \u062f\u0631 \u0635\u0648\u0631\u062a \u062a\u0645\u0627\u06cc\u0644 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0622\u0646 \u0631\u0627 \u062a\u063a\u06cc\u06cc\u0631 \u062f\u0647\u06cc\u062f .<\/p>\n<\/p>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D9%85%D8%AD%D8%AF%D9%88%D8%AF%D9%87_%D9%86%D8%A7%D9%85_%D8%A8%D8%B1%D8%A7%DB%8C_%D9%87%D8%B1_%D8%B4%DB%8C%D8%AA\"><\/span>\u0627\u06cc\u062c\u0627\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0634\u06cc\u062a<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u062f\u0627\u0631\u06cc\u062f \u062d\u0627\u0648\u06cc \u0628\u06cc\u0634 \u0627\u0632 10 \u0634\u06cc\u062a \u06a9\u0647 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0627\u06cc\u0646 \u0634\u06cc\u062a\u0647\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc \u0633\u0631\u06cc\u0639 \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u06cc\u062f \u060c \u06cc\u06a9 \u0631\u0627\u0647 \u0627\u06cc\u062c\u0627\u062f \u0645\u062d\u062f\u0648\u062f\u0647 \u0646\u0627\u0645 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0634\u06cc\u062a \u06cc\u0647 \u0646\u0627\u0645 \u0647\u0645\u0627\u0646 \u0634\u06cc\u062a \u0627\u0633\u062a.<\/p>\n<p>\u0628\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u060c \u0648\u0642\u062a\u06cc \u0627\u062c\u0631\u0627 \u0634\u0648\u0646\u062f \u0627\u0632 \u062a\u0645\u0627\u0645 \u0634\u06cc\u062a\u0647\u0627 \u06cc\u06a9 \u0646\u0627\u0645 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f\u00a0<\/p>\n<p>\u0628\u0631\u0627\u06cc \u062d\u0630\u0641 \u0648 \u0648\u06cc\u0631\u0627\u06cc\u0634 \u0646\u0627\u0645\u0647 \u0647\u0645 \u06a9\u0627\u0641\u06cc\u0633\u062a \u06a9\u0647 \u06a9\u0644\u06cc\u062f\u0647\u0627\u06cc ctrl + f3 \u0631\u0627 \u0628\u0632\u0646\u06cc\u062f .<\/p>\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre class=\"CodeMirror\" data-setting=\"{&quot;showPanel&quot;:false,&quot;languageLabel&quot;:&quot;file&quot;,&quot;fullScreenButton&quot;:true,&quot;copyButton&quot;:true,&quot;mode&quot;:&quot;vbscript&quot;,&quot;mime&quot;:&quot;text\/vbscript&quot;,&quot;theme&quot;:&quot;abcdef&quot;,&quot;lineNumbers&quot;:false,&quot;styleActiveLine&quot;:false,&quot;lineWrapping&quot;:true,&quot;readOnly&quot;:true,&quot;fileName&quot;:&quot;script.vbs&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">Sub creatNamebox()\n    Dim ws As Worksheet\n    Dim i As Integer\n    For Each ws In ActiveWorkbook.Worksheets\n        i = i + 1\n        ActiveWorkbook.Names.Add Name:=ws.Name, RefersTo:=ws.Range(&quot;A1&quot;)\n    Next ws\nEnd Sub<\/pre><\/div>\n\n\n<p>\u062a\u0627 \u0627\u06cc\u0646\u062c\u0627 6 \u0642\u0627\u0628\u0644\u06cc\u062a \u0631\u0627 \u062f\u0631 \u0642\u0627\u0644\u0628 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u0627\u06cc\u0646 \u0645\u0637\u0644\u0628 \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647 \u0627\u06cc\u0645 \u0648 \u062f\u0631 \u0642\u0633\u0645\u062a \u0646\u0638\u0631\u0627\u062a \u0645\u0646\u062a\u0638\u0631 \u0627\u06cc\u062f\u0647 \u0648 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f\u0627\u062a \u0634\u0645\u0627 \u0647\u0633\u062a\u0633\u0645 \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u0645 \u0627\u06cc\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u062a\u0648\u0633\u0639\u0647 \u062f\u0647\u06cc\u0645 . \u0627\u06af\u0631 \u062a\u0648\u0636\u06cc\u062d \u06a9\u062f\u0647\u0627 \u062f\u0631 \u0648\u06cc\u062f\u06cc\u0648\u0647\u0627 \u0628\u0631\u0627\u06cc \u0634\u0645\u0627 \u06af\u0646\u06af \u0627\u0633\u062a \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u0645\u06cc \u06a9\u0646\u0645 <a href=\"https:\/\/officebaz.ir\/product\/%D8%A2%D9%85%D9%88%D8%B2%D8%B4-vba-%D8%A7%DA%A9%D8%B3%D9%84\/\" target=\"_blank\" rel=\"noopener\">\u062f\u0648\u0631\u0647 VBA \u0627\u06a9\u0633\u0644<\/a> \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0646\u0645\u0627\u0626\u06cc\u062f.<\/p>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%B4%DB%8C%D8%AA_INDEX_%D8%B4%D8%A7%D9%85%D9%84_%D9%86%D8%A7%D9%85_%D8%AA%D9%85%D8%A7%D9%85_%D8%B4%DB%8C%D8%AA%D9%87%D8%A7\"><\/span>\u0627\u06cc\u062c\u0627\u062f \u0634\u06cc\u062a INDEX \u0634\u0627\u0645\u0644 \u0646\u0627\u0645 \u062a\u0645\u0627\u0645 \u0634\u06cc\u062a\u0647\u0627<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u062f\u0627\u0631\u06cc\u0645 \u06a9\u0647 \u062d\u0627\u0648\u06cc \u062a\u0639\u062f\u0627\u062f \u0632\u06cc\u0627\u062f\u06cc \u0634\u06cc\u062a \u0627\u0633\u062a \u0648 \u062c\u0627\u0628\u062c\u0627\u06cc\u06cc \u0628\u06cc\u0646 \u0634\u06cc\u062a\u0647\u0627 \u06a9\u0645\u06cc \u0632\u0645\u0627\u0646 \u0628\u0631 \u0645\u06cc \u0628\u0627\u0634\u062f \u0628\u0627 \u06a9\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0648 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0622\u0646 \u06cc\u06a9 \u062c\u062f\u06cc\u062f \u0628\u0647 \u0641\u06cc\u0627 \u0634\u0627 \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f \u0628\u0647 \u0646\u0627\u0645 INDEX \u06a9\u0647 \u062f\u0631 \u0633\u062a\u0648\u0646 B \u0622\u0646 \u0646\u0627\u0645 \u0634\u06cc\u062a\u0647\u0627 \u0642\u0631\u0627\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f.<\/p>\n<p>\u0628\u0627 \u06a9\u0644\u06cc\u06a9 \u0628\u0631 \u0631\u0648\u06cc \u0647\u0631 \u0646\u0627\u0645 \u0628\u0647 \u0647\u0645\u0627\u0646 \u0634\u06cc\u062a \u0645\u0646\u062a\u0642\u0644 \u062e\u0648\u0627\u0647\u06cc\u062f \u0634\u062f\u0647 \u0648 <a href=\"https:\/\/officebaz.ir\/ex\/hyperlink\/\" target=\"_blank\" rel=\"noopener\">HYPERLINK<\/a> \u0645\u06cc \u0634\u0648\u062f\u00a0 \u0648 \u0639\u0644\u0627\u0648\u0647 \u0628\u0631 \u0622\u0646 \u0627\u06af\u0631 \u0622\u062f\u0631\u0633 A1 \u0634\u06cc\u062a\u0647\u0627 \u062e\u0627\u0644\u06cc \u0628\u0627\u0634\u0646\u062f \u062f\u0631 \u0647\u0631 \u0634\u06cc\u062a \u0647\u0645 \u0646\u0648\u0634\u062a\u0647 Back \u062f\u0631 A1 \u0642\u0631\u0627\u0631 \u0645\u06cc\u06af\u0631\u062f \u06a9\u0647 \u0628\u0627 \u06a9\u0644\u06cc\u06a9 \u0631\u0648\u06cc \u0622\u0646 \u0628\u0647 \u0634\u06cc\u062a INDEX \u0645\u0646\u062a\u0642\u0644 \u0645\u06cc \u0634\u0648\u062f .<\/p>\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-center kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;center&quot;,&quot;id&quot;:&quot;8697&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;14&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;4.5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;4.5\\\/5 - (14 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 Personal Macro&quot;,&quot;width&quot;:&quot;124&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-left: 4px\">\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-left: 4px\">\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-left: 4px\">\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-left: 4px\">\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-left: 4px\">\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: 124px;\">\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-left: 4px\">\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            4.5\/5 - (14 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0628\u0631\u0627\u06cc \u062f\u0627\u0634\u062a\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632 \u0631\u0627 \u0628\u0627 \u062f\u0642\u062a \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0627\u0631\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 \u0633\u0631\u0639\u062a \u0628\u0627\u0644\u0627\u062a\u0631 \u0648 \u0628\u0647\u062a\u0631 \u067e\u06cc\u0634 \u0628\u0628\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u062f\u0631 \u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645. \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 Personal Macro \u0628\u0647 \u0627\u06a9\u0633\u0644 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9818,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uag_custom_page_level_css":"","advgb_blocks_editor_width":"","advgb_blocks_columns_visual_guide":"","footnotes":""},"categories":[88],"tags":[62,70],"class_list":["post-8697","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-88","tag-62","tag-70"],"acf":[],"author_meta":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"featured_img":"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD-300x169.webp","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD-150x150.webp",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD-300x169.webp",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD-768x432.webp",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD-1024x576.webp",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2024\/01\/ADD.webp",600,338,false]},"uagb_author_info":{"display_name":"\u0646\u0627\u062f\u0631 \u0628\u062d\u0631\u06cc","author_link":"https:\/\/officebaz.ir\/ex\/author\/administrator\/"},"uagb_comment_info":21,"uagb_excerpt":"\u0628\u0631\u0627\u06cc \u062f\u0627\u0634\u062a\u0646 \u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644 \u06a9\u0627\u0641\u06cc\u0633\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632 \u0631\u0627 \u0628\u0627 \u062f\u0642\u062a \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0627\u0631\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u0628\u0627 \u0633\u0631\u0639\u062a \u0628\u0627\u0644\u0627\u062a\u0631 \u0648 \u0628\u0647\u062a\u0631 \u067e\u06cc\u0634 \u0628\u0628\u0631\u06cc\u062f. \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u062f\u0631 \u0627\u0648\u0644\u06cc\u0646 \u0642\u062f\u0645 \u0645\u06cc\u062e\u0648\u0627\u0647\u06cc\u0645 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u0686\u06a9 \u0628\u0627\u06a9\u0633 \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0631\u0627 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u0645. \u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 Personal Macro \u0628\u0647 \u0627\u06a9\u0633\u0644 \u06cc\u06a9 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u0628\u0627\u0632 \u06a9\u0646\u06cc\u062f&hellip;","coauthors":[],"tax_additional":{"categories":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u0622\u0645\u0648\u0632\u0634 \u0627\u06a9\u0633\u0644<\/span>"]},"tags":{"linked":["<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">\u0641\u0627\u06cc\u0644\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/a>","<a href=\"https:\/\/officebaz.ir\/ex\/category\/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%a7%da%a9%d8%b3%d9%84\/\" class=\"advgb-post-tax-term\">\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/a>"],"unlinked":["<span class=\"advgb-post-tax-term\">\u0641\u0627\u06cc\u0644\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/span>","<span class=\"advgb-post-tax-term\">\u0646\u06a9\u0627\u062a \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u0627\u06a9\u0633\u0644<\/span>"]}},"comment_count":"21","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 3 \u0633\u0627\u0644 \u067e\u06cc\u0634","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 2 \u0633\u0627\u0644 \u067e\u06cc\u0634"},"absolute_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 11 \u062f\u06cc 1402","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 5 \u0645\u0647\u0631 1403"},"absolute_dates_time":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 11 \u062f\u06cc 1402 12:00 \u0642.\u0638","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 5 \u0645\u0647\u0631 1403 1:27 \u0628.\u0638"},"featured_img_caption":"\u0627\u0645\u06a9\u0627\u0646\u0627\u062a \u0648\u06cc\u0698\u0647 \u0627\u06a9\u0633\u0644","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/8697","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/comments?post=8697"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/8697\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/9818"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=8697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=8697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=8697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}