{"id":3196,"date":"2021-05-30T00:51:06","date_gmt":"2021-05-29T20:21:06","guid":{"rendered":"https:\/\/officebaz.ir\/ex\/?p=3196"},"modified":"2023-08-15T21:57:58","modified_gmt":"2023-08-15T18:27:58","slug":"%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84","status":"publish","type":"post","link":"https:\/\/officebaz.ir\/ex\/%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84\/","title":{"rendered":"\u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0648 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644"},"content":{"rendered":"\n<p id=\"block-ae7a153f-8e84-4856-a6ec-e826ec838229\">\u0647\u062f\u0631 \u0641\u0648\u062a\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0634\u0627\u0628\u0647 \u0648\u0631\u062f \u0646\u06cc\u0633\u062a \u0648 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f \u0648 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0627\u0632 \u0622\u0646 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f \u0648 \u0627\u0632 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0646\u0645\u0627\u0626\u06cc\u062f.<\/p>\n\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/headers-and-footers-in-a-worksheet-cae2a88c-64a7-42ab-96a4-28d2fc16ad31#:~:text=On%20the%20Insert%20tab%2C%20in,new%20header%20or%20footer%20text.\" data-type=\"link\" data-id=\"https:\/\/support.microsoft.com\/en-us\/office\/headers-and-footers-in-a-worksheet-cae2a88c-64a7-42ab-96a4-28d2fc16ad31#:~:text=On%20the%20Insert%20tab%2C%20in,new%20header%20or%20footer%20text.\" target=\"_blank\" rel=\"noopener\">\u0633\u0631\u0628\u0631\u06af \u0648 \u067e\u0627\u0648\u0631\u0642\u06cc<\/a> \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u0631\u0628\u0631\u06af \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n\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%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84\/#%D9%88%DB%8C%D8%AF%DB%8C%D9%88_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%87%D8%AF%D8%B1_%D9%88_%D9%81%D9%88%D8%AA%D8%B1_%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B5%DB%8C_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0648\u06cc\u062f\u06cc\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \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-2\" href=\"https:\/\/officebaz.ir\/ex\/%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%AD%D8%B0%D9%81_%D9%BE%D8%A7%D9%88%D8%B1%D9%82%DB%8C_%D9%88_%D8%B3%D8%B1%D8%A8%D8%B1%DA%AF_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\" >\u062d\u0630\u0641 \u067e\u0627\u0648\u0631\u0642\u06cc \u0648 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \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-3\" href=\"https:\/\/officebaz.ir\/ex\/%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%d8%a7%da%a9%d8%b3%d9%84\/#%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%D8%AA%D8%B5%D9%88%DB%8C%D8%B1_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%D8%B3%D8%B1%D8%A8%D8%B1%DA%AF_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\" >\u0627\u0641\u0632\u0648\u062f\u0646 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0631\u0628\u0631\u06af \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-4\" href=\"https:\/\/officebaz.ir\/ex\/%d8%b3%d8%b1%d8%a8%d8%b1%da%af-%d8%af%d8%b1-%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_%D9%BE%D8%A7%D9%88%D8%B1%D9%82%DB%8C_%D8%A7%DA%A9%D8%B3%D9%84_%D9%81%D9%82%D8%B7_%D8%A8%D9%87_%D8%B5%D9%81%D8%AD%D9%87_%D8%A2%D8%AE%D8%B1\" >\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u067e\u0627\u0648\u0631\u0642\u06cc \u0627\u06a9\u0633\u0644 \u0641\u0642\u0637 \u0628\u0647 \u0635\u0641\u062d\u0647 \u0622\u062e\u0631<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading advgb-dyn-41704d8d\"><span class=\"ez-toc-section\" id=\"%D9%88%DB%8C%D8%AF%DB%8C%D9%88_%D8%A7%D8%B3%D8%AA%D9%81%D8%A7%D8%AF%D9%87_%D8%A7%D8%B2_%D9%87%D8%AF%D8%B1_%D9%88_%D9%81%D9%88%D8%AA%D8%B1_%D8%A7%D8%AE%D8%AA%D8%B5%D8%A7%D8%B5%DB%8C_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0648\u06cc\u062f\u06cc\u0648 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u062f\u0631 \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p id=\"block-ae7a153f-8e84-4856-a6ec-e826ec838229\">\u0648\u06cc\u062f\u06cc\u0648 \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0631\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \u062f\u0631 \u0627\u0628\u062a\u062f\u0627\u06cc \u0645\u0637\u0644\u0628 \u0642\u0631\u0627\u0631 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0627\u06af\u0631 \u0646\u06cc\u0627\u0632 \u0628\u0648\u062f \u062a\u0627 \u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u062f\u06cc\u06af\u0631\u06cc \u062f\u0627\u062f\u0647 \u0634\u0648\u062f \u060c \u0644\u0637\u0641\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\n<h2 class=\"wp-block-heading advgb-dyn-a2a50581\" id=\"block-35e1a860-1f9a-4ae0-b05a-5cb1df85ddc5\"><span class=\"ez-toc-section\" id=\"%D8%AD%D8%B0%D9%81_%D9%BE%D8%A7%D9%88%D8%B1%D9%82%DB%8C_%D9%88_%D8%B3%D8%B1%D8%A8%D8%B1%DA%AF_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84_%D8%A8%D8%A7_%DB%8C%DA%A9_%DA%A9%D9%84%DB%8C%DA%A9\"><\/span>\u062d\u0630\u0641 \u067e\u0627\u0648\u0631\u0642\u06cc \u0648 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0628\u0627 \u06cc\u06a9 \u06a9\u0644\u06cc\u06a9<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0641\u0631\u0636 \u0645\u06cc\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0628\u0627 \u06a9\u062f\u0647\u0627\u06cc\u06cc \u06a9\u0647 \u062f\u0631 \u0627\u062f\u0627\u0645\u0647 \u06af\u0641\u062a\u0647 \u0634\u062f\u0647 \u067e\u0627\u0648\u0631\u0642\u06cc <a class=\"rank-math-link\" href=\"https:\/\/officebaz.ir\/ex\/\" target=\"_blank\" rel=\"noreferrer noopener\">\u0627\u06a9\u0633\u0644 <\/a>\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f \u0648 \u062d\u0627\u0644\u0627 \u0645\u06cc \u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0632 \u0647\u0631 6 \u0645\u06a9\u0627\u0646\u06cc \u0627\u0645\u06a9\u0627\u0646 \u0648\u062c\u0648\u062f \u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0647\u0633\u062a \u0622\u0646\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f .<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0631 \u0641\u06cc\u0627\u0644 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>\u062f\u0631 \u0641\u0627\u06cc\u0644 \u062e\u0648\u062f \u06cc\u06a9 Shape \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f \u0648 \u06a9\u062f\u0647\u0627 \u0631\u0627 \u0627\u062c\u0631\u0627 \u0646\u0645\u0627\u0626\u06cc\u062f.<\/li>\n<\/ol>\n\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">Sub removeHeaderFooter()\n\n    With ActiveSheet.PageSetup\n        .RightHeader = Null\n        .RightFooter = Null\n        .CenterHeader = Null\n        .CenterFooter = Null\n        .LeftHeader = Null\n        .LeftFooter = Null\n    End With\n    \nEnd Sub<\/pre><\/div>\n\n\n\n<h2 class=\"wp-block-heading advgb-dyn-979747c4\" id=\"block-cc0973d3-ef84-466f-b241-1b0519fa81c5\"><span class=\"ez-toc-section\" id=\"%D8%A7%D9%81%D8%B2%D9%88%D8%AF%D9%86_%D8%AA%D8%B5%D9%88%DB%8C%D8%B1_%D8%A8%D9%87_%D8%B9%D9%86%D9%88%D8%A7%D9%86_%D8%B3%D8%B1%D8%A8%D8%B1%DA%AF_%D8%AF%D8%B1_%D8%A7%DA%A9%D8%B3%D9%84\"><\/span>\u0627\u0641\u0632\u0648\u062f\u0646 \u062a\u0635\u0648\u06cc\u0631 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u0627\u0644\u0628\u062a\u0647 \u0628\u0627 \u0627\u06cc\u0646 \u06a9\u062f \u0648 \u06a9\u0645\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u06a9\u0647 \u062f\u0631 \u0648\u06cc\u062f\u06cc\u0648 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0628\u0631\u0627\u06cc \u0647\u0631 6 \u0642\u0633\u0645\u062a \u0645\u0645\u06a9\u0646 \u067e\u0627\u0648\u0631\u0642\u06cc \u0648 \u062a\u06cc\u062a\u0631 \u0635\u0641\u062d\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u0635\u0648\u06cc\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f \u060c \u0628\u0631\u0627\u06cc \u0647\u062f\u0631 \u0631\u0627\u0633\u062a \u0648 \u0647\u062f\u0631 \u0648\u0633\u0637 \u0648 \u0647\u062f\u0631 \u0686\u067e \u0648 \u0641\u0648\u062a\u0631 \u0631\u0627\u0633\u062a \u0648 \u0641\u0648\u062a\u0631 \u0648\u0633\u0637 \u0648 \u0641\u0648\u062a\u0631 \u0686\u067e.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u062f\u0631 \u0642\u0633\u0645\u062a \u06a9\u062f\u0646\u0648\u06cc\u0633\u06cc \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f&nbsp;<\/li>\n\n\n\n<li>\u06a9\u062f\u0647\u0627 \u0631\u0627 \u0628\u0647 \u06cc\u06a9 Shape \u0648 \u06cc\u0627 \u062f\u06a9\u0645\u0647 \u0627\u062e\u062a\u0635\u0627\u0635 \u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>\u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u06a9\u062f \u0638\u0627\u0647\u0631\u0627 \u0627\u062a\u0641\u0627\u0642\u06cc \u0646\u0645\u06cc \u0627\u0641\u062a\u062f \u0648\u0644\u06cc \u0627\u06af\u0631 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0631\u0627 \u062f\u0631 \u0646\u0645\u0627\u06cc \u0686\u0627\u067e\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u06a9\u0646\u06cc\u062f \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0631\u0627 \u062e\u0648\u0627\u0647\u06cc\u062f \u062f\u06cc\u062f.<\/li>\n<\/ol>\n\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">Public Sub AddFooterHeaderImage()\nDim sht As Worksheet\nDim ImagePath As String\nDim Validation As String\n  ImagePath = &quot;C:\\Users\\nader\\Desktop\\Footer3.png&quot;\n  ImagePath1 = &quot;C:\\Users\\nader\\Desktop\\OfficebazLogo1.png&quot;\n  On Error Resume Next\n    Validation = Dir(ImagePath)\n  On Error GoTo 0\n  If Validation = &quot;&quot; Then\n    MsgBox &quot;\u0641\u0627\u064a\u0644 \u067e\u064a\u062f\u0627 \u0646\u0634\u062f: &quot; &amp; ImagePath\n    Exit Sub\n  End If\n  For Each sht In ActiveWorkbook.Windows(1).SelectedSheets\n      sht.PageSetup.CenterFooter = &quot;&amp;G&quot;\n      sht.PageSetup.CenterFooterPicture.Filename = ImagePath\n          sht.PageSetup.RightHeader = &quot;&amp;G&quot;\n      sht.PageSetup.RightHeaderPicture.Filename = ImagePath1\n      sht.DisplayPageBreaks = False\n  Next sht\n\nEnd Sub<\/pre><\/div>\n\n\n\n<p>\u062a\u0648\u0636\u06cc\u062d\u0627\u062a \u062f\u0631 \u0645\u0648\u0631\u062f \u06a9\u062f \u0628\u0627\u0644\u0627 :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0628\u0627\u06cc\u062f \u0645\u0642\u062f\u0627\u0631 imagePath1 \u0648 ImagePath \u0631\u0627 \u0628\u0627 \u0622\u062f\u0631\u0633 \u062a\u0635\u0627\u0648\u06cc\u0631 \u062e\u0648\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading advgb-dyn-72c29a26\" id=\"block-4a02fd37-16f2-47a4-bf3a-365afd5176ac\"><span class=\"ez-toc-section\" id=\"%D8%A7%D8%B6%D8%A7%D9%81%D9%87_%DA%A9%D8%B1%D8%AF%D9%86_%D9%BE%D8%A7%D9%88%D8%B1%D9%82%DB%8C_%D8%A7%DA%A9%D8%B3%D9%84_%D9%81%D9%82%D8%B7_%D8%A8%D9%87_%D8%B5%D9%81%D8%AD%D9%87_%D8%A2%D8%AE%D8%B1\"><\/span>\u0627\u0636\u0627\u0641\u0647 \u06a9\u0631\u062f\u0646 \u067e\u0627\u0648\u0631\u0642\u06cc \u0627\u06a9\u0633\u0644 \u0641\u0642\u0637 \u0628\u0647 \u0635\u0641\u062d\u0647 \u0622\u062e\u0631<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u0642\u0633\u0645\u062a \u0647\u0645 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u062f\u0647\u0627 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0648\u06cc\u062f\u06cc\u0648 \u0622\u0645\u0648\u0632\u0634\u06cc \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u06a9\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0641\u0642\u0637 \u062f\u0631 \u0635\u0641\u062d\u0647 \u0622\u062e\u0631 \u0686\u0627\u067e \u0634\u0648\u062f \u060c \u062f\u0631 \u0648\u0627\u0642\u0639 \u0628\u0627 \u0627\u062c\u0631\u0627\u06cc \u0627\u06cc\u0646 \u06a9\u062f \u0639\u0645\u0644\u06cc\u0627\u062a \u0686\u0627\u067e \u062f\u0648\u0628\u0627\u0631 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f \u060c \u062f\u0642\u0639\u0647 \u0627\u0648\u0644 \u0647\u0645\u0647 \u0635\u0641\u062d\u0627\u062a \u0628\u0647 \u063a\u06cc\u0631 \u0627\u0632 \u0635\u0641\u062d\u0647 \u0622\u062e\u0631 \u0648 \u0627\u0644\u0628\u062a\u0647 \u0628\u062f\u0648\u0646 \u0647\u062f\u0631 \u0648 \u062f\u0641\u0639\u0647 \u062f\u0648\u0645 \u060c \u0641\u0642\u0637 \u0635\u0641\u062d\u0647 \u0622\u062e\u0631 \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u06a9\u062f\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u06a9\u067e\u06cc \u06a9\u0631\u062f\u0647 \u0648 \u062f\u0631 \u0641\u0627\u06cc\u0644 \u0627\u06a9\u0633\u0644 \u062e\u0648\u062f \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.<\/li>\n\n\n\n<li>\u062f\u0631 \u0645\u062d\u0644 \u0648 \u0631\u0648\u06cc\u062f\u0627\u062f \u062f\u0644\u062e\u0648\u0627\u0647 \u06a9\u062f\u0647\u0627 \u0631\u0627 \u0641\u0631\u0627\u062e\u0648\u0627\u0646\u06cc \u06a9\u0646\u06cc\u062f.<\/li>\n\n\n\n<li>\u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u062e\u0631\u0648\u062c\u06cc PDF \u0628\u06af\u06cc\u0631\u06cc\u062f \u0627\u06cc\u0646 \u062a\u0632\u0641\u0646\u062f \u0645\u0646\u0627\u0633\u0628 \u0646\u062e\u0648\u0627\u0647\u062f \u0628\u0648\u062f.<\/li>\n\n\n\n<li>\u0686\u0648\u0646 \u062f\u0648 \u0641\u06cc\u0627\u0644 \u0645\u062c\u0632\u0627 \u062a\u0648\u0644\u06cc\u062f \u062e\u0648\u0627\u0647\u062f \u06a9\u0631\u062f.<\/li>\n<\/ol>\n\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;&quot;,&quot;advgbBlockControls&quot;:[],&quot;language&quot;:&quot;VBScript&quot;,&quot;maxHeight&quot;:&quot;400px&quot;,&quot;modeName&quot;:&quot;vb&quot;}\">Sub onlyLastPage()\n    Dim TotPages As Long\n    Dim sht As Worksheet\n    Dim ImagePath As String\n    Dim Validation As String\n    TotPages = Application.ExecuteExcel4Macro(&quot;GET.DOCUMENT(50)&quot;)\n    With ActiveSheet.PageSetup\n        .RightHeader = Null\n        .RightFooter = Null\n        .CenterHeader = Null\n        .CenterFooter = Null\n        .LeftHeader = Null\n        .LeftFooter = Null\n        ActiveSheet.PrintOut From:=1, To:=TotPages - 1\n        ImagePath = &quot;C:\\Users\\nader\\Desktop\\OfficebazLogo1.png&quot;\n        ImagePath1 = &quot;C:\\Users\\nader\\Desktop\\Footer3.png&quot;\n        On Error Resume Next\n        Validation = Dir(ImagePath)\n        On Error GoTo 0\n\n        If Validation = &quot;&quot; Then\n            MsgBox &quot;\u0641\u0627\u064a\u0644 \u067e\u064a\u062f\u0627 \u0646\u0634\u062f: &quot; &amp; ImagePath\n            Exit Sub\n        End If\n      \n        For Each sht In ActiveWorkbook.Windows(1).SelectedSheets\n    \n            sht.PageSetup.CenterFooter = &quot;&amp;G&quot;\n            sht.PageSetup.CenterFooterPicture.Filename = ImagePath1\n            sht.PageSetup.RightHeader = &quot;&amp;G&quot;\n            sht.PageSetup.RightHeaderPicture.Filename = ImagePath\n            sht.DisplayPageBreaks = False\n  \n        Next sht\n        ActiveSheet.PrintOut From:=TotPages, To:=TotPages\n    End With\nEnd Sub<\/pre><\/div>\n\n\n\n<figure class=\"wp-block-image aligncenter advgb-dyn-5decd161\" id=\"block-78cc209b-6817-43b0-9a5f-61d9750e650c\"><img decoding=\"async\" src=\"https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/04\/Header.png\" alt=\"\u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644\"\/><figcaption class=\"wp-element-caption\">\u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644<\/figcaption><\/figure>\n\n\n<p>\u0627\u06af\u0631 \u067e\u06cc\u0634\u0646\u0647\u0627\u062f \u06cc\u0627 \u0627\u0646\u062a\u0642\u0627\u062f\u06cc \u062f\u0631 \u0645\u0648\u0631\u062f \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u0631\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631 \u0642\u0633\u0645\u062a \u0646\u0638\u0631\u0627\u062a \u0645\u0637\u0631\u062d \u0646\u0645\u0627\u0626\u06cc\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;3196&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;2&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;4&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (2 \u0627\u0645\u062a\u06cc\u0627\u0632)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;\u0647\u062f\u0631 \u0648 \u0641\u0648\u062a\u0631 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0648 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644&quot;,&quot;width&quot;:&quot;138&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: 138px;\">\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            5\/5 - (2 \u0627\u0645\u062a\u06cc\u0627\u0632)    <\/div>\n    <\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0647\u062f\u0631 \u0641\u0648\u062a\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0634\u0627\u0628\u0647 \u0648\u0631\u062f \u0646\u06cc\u0633\u062a \u0648 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f \u0648 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0627\u0632 \u0622\u0646 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f \u0648 \u0627\u0632 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0646\u0645\u0627\u0626\u06cc\u062f. \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0633\u0631\u0628\u0631\u06af \u0648 \u067e\u0627\u0648\u0631\u0642\u06cc \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u0631\u0628\u0631\u06af \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7959,"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":[138,70],"class_list":["post-3196","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-88","tag-vba","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\/2021\/05\/Header-300x169.jpg","uagb_featured_image_src":{"full":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",1280,720,false],"thumbnail":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header-150x150.jpg",150,150,true],"medium":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header-300x169.jpg",300,169,true],"medium_large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header-768x432.jpg",768,432,true],"large":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header-1024x576.jpg",800,450,true],"1536x1536":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",1280,720,false],"2048x2048":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",1280,720,false],"gform-image-choice-sm":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",300,169,false],"gform-image-choice-md":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",400,225,false],"gform-image-choice-lg":["https:\/\/officebaz.ir\/ex\/wp-content\/uploads\/2021\/05\/Header.jpg",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":4,"uagb_excerpt":"\u0647\u062f\u0631 \u0641\u0648\u062a\u0631 \u0627\u06a9\u0633\u0644 \u0645\u0634\u0627\u0628\u0647 \u0648\u0631\u062f \u0646\u06cc\u0633\u062a \u0648 \u062a\u0641\u0627\u0648\u062a\u0647\u0627\u06cc\u06cc \u062f\u0627\u0631\u062f \u0648 \u0627\u06af\u0631 \u0628\u062e\u0648\u0627\u0647\u06cc\u062f \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0627\u0632 \u0622\u0646 \u0628\u0647\u0631\u0647 \u0628\u0628\u0631\u06cc\u062f \u0648 \u0627\u0632 \u0633\u0631\u0628\u0631\u06af \u062f\u0631 \u0627\u06a9\u0633\u0644 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u062f\u0627\u0645\u0647 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0631\u0627 \u0645\u0634\u0627\u0647\u062f\u0647 \u0646\u0645\u0627\u0626\u06cc\u062f. \u0627\u0644\u0628\u062a\u0647 \u062f\u0631 \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u0628\u0647 \u0633\u0631\u0628\u0631\u06af \u0648 \u067e\u0627\u0648\u0631\u0642\u06cc \u067e\u0631\u062f\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0648 \u0628\u0647\u062a\u0631\u06cc\u0646 \u0631\u0648\u0634 \u0628\u0631\u0627\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u0631\u0628\u0631\u06af \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0622\u0645\u0648\u0632\u0634 \u062f\u0627\u062f\u0647&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\">VBA<\/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\">VBA<\/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":"4","relative_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 5 \u0633\u0627\u0644 \u067e\u06cc\u0634","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 3 \u0633\u0627\u0644 \u067e\u06cc\u0634"},"absolute_dates":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 9 \u062e\u0631\u062f\u0627\u062f 1400","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 24 \u0645\u0631\u062f\u0627\u062f 1402"},"absolute_dates_time":{"created":"\u0645\u0646\u062a\u0634\u0631 \u0634\u062f\u0647 \u062f\u0631 9 \u062e\u0631\u062f\u0627\u062f 1400 12:51 \u0642.\u0638","modified":"\u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0634\u062f\u0647 \u062f\u0631 24 \u0645\u0631\u062f\u0627\u062f 1402 9:57 \u0628.\u0638"},"featured_img_caption":"\u0647\u062f\u0631 \u0641\u0648\u062a\u0631 \u0627\u06a9\u0633\u0644","series_order":"","_links":{"self":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/3196","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=3196"}],"version-history":[{"count":0,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/posts\/3196\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media\/7959"}],"wp:attachment":[{"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/media?parent=3196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/categories?post=3196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officebaz.ir\/ex\/wp-json\/wp\/v2\/tags?post=3196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}