{"id":57,"date":"2011-10-04T14:25:21","date_gmt":"2011-10-04T12:25:21","guid":{"rendered":"http:\/\/excelvbatips.co.il\/?page_id=57"},"modified":"2018-07-01T18:33:46","modified_gmt":"2018-07-01T15:33:46","slug":"%d7%a4%d7%aa%d7%99%d7%97%d7%aa-%d7%94%d7%a7%d7%95%d7%91%d7%a5-%d7%91%d7%92%d7%99%d7%9c%d7%99%d7%95%d7%9f-%d7%a8%d7%a6%d7%95%d7%99-%d7%91%d7%aa%d7%90-%d7%a8%d7%a6%d7%95%d7%99","status":"publish","type":"page","link":"https:\/\/excelvbatips.co.il\/?page_id=57","title":{"rendered":"\u05e4\u05ea\u05d9\u05d7\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05e8\u05e6\u05d5\u05d9 \u05d1\u05ea\u05d0 \u05e8\u05e6\u05d5\u05d9"},"content":{"rendered":"<h1>\u05e4\u05ea\u05d9\u05d7\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05e8\u05e6\u05d5\u05d9 \u05d1\u05ea\u05d0 \u05e8\u05e6\u05d5\u05d9<\/h1>\n<p>\u05d1\u05e4\u05ea\u05d9\u05d7\u05ea \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc , \u05d4\u05d5\u05d0 \u05e0\u05e4\u05ea\u05d7 \u05d1\u05de\u05e7\u05d5\u05dd \u05d1\u05d5 \u05d4\u05d9\u05d9\u05e0\u05d5 \u05db\u05d0\u05e9\u05e8 \u05e1\u05d2\u05e8\u05e0\u05d5 \u05d0\u05d5\u05ea\u05d5.<\/p>\n<p><b><u>\u05d4\u05d1\u05e2\u05d9\u05d4<\/u><\/b>: \u05d9\u05e9 \u05e7\u05d1\u05e6\u05d9\u05dd \u05d1\u05d4\u05dd \u05ea\u05de\u05d9\u05d3 \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e6\u05e8\u05d9\u05db\u05d9\u05dd \u05dc\u05d4\u05ea\u05d7\u05d9\u05dc \u05de\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05de\u05e1\u05d5\u05d9\u05dd \u05d1\u05ea\u05d0 \u05de\u05e1\u05d5\u05d9\u05dd.<\/p>\n<p>\u05dc\u05d3\u05d5\u05d2\u05de\u05d0 : \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df &quot; \u05e9\u05e2\u05e8\u05d9 \u05de\u05d8\u05d1\u05e2\u05d5\u05ea&quot; \u05d1\u05ea\u05d0 A1<\/p>\n<p><b><u>\u05d4\u05e4\u05ea\u05e8\u05d5\u05df<\/u><\/b> :<\/p>\n<p>\u05e2\u05d5\u05d1\u05e8\u05d9\u05dd \u05dc\u05e2\u05d5\u05e8\u05da \u05d4-VBA \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea <b>ALT + F11<\/b> \u05d0\u05d5 \u05db\u05dc \u05d3\u05e8\u05da \u05d0\u05d7\u05e8\u05ea \u05e9\u05de\u05db\u05d9\u05e8\u05d9\u05dd.<\/p>\n<p>\u05d1\u05d5\u05d7\u05e8\u05d9\u05dd \u05d1<b>\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d5 \u05e0\u05de\u05e6\u05d0\u05d9\u05dd<\/b> \u05d0\u05ea <b>\u05d4\u05de\u05d5\u05d3\u05d5\u05dc<\/b> \u05e9\u05dc <b>ThisWorkbook<\/b> \u05d1\u05d0\u05de\u05e6\u05e2\u05d5\u05ea \u05e7\u05dc\u05d9\u05e7 \u05db\u05e4\u05d5\u05dc \u05e2\u05dc\u05d9\u05d5.<\/p>\n<p><a href=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image0021.jpg\"><img decoding=\"async\" loading=\"lazy\" style=\"display: inline; border: 0px;\" title=\"clip_image002\" src=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image002_thumb1.jpg\" alt=\"clip_image002\" width=\"261\" height=\"160\" border=\"0\" \/><\/a><\/p>\n<p>\u05d1\u05e6\u05d3 \u05e9\u05de\u05d0\u05dc \u05e4\u05d5\u05ea\u05d7\u05d9\u05dd \u05d0\u05ea \u05d4\u05d7\u05e5 \u05d5\u05d1\u05d5\u05d7\u05e8\u05d9\u05dd Workbook \u05d1\u05de\u05e7\u05d5\u05dd General<\/p>\n<p><a href=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image0041.jpg\"><img decoding=\"async\" loading=\"lazy\" style=\"display: inline; border: 0px;\" title=\"clip_image004\" src=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image004_thumb1.jpg\" alt=\"clip_image004\" width=\"539\" height=\"62\" border=\"0\" \/><\/a><\/p>\n<p>\u05d0\u05d5\u05d8\u05d5\u05de\u05d8\u05d9\u05ea \u05e0\u05d5\u05e6\u05e8 \u05dc\u05e0\u05d5 :<\/p>\n<p><a href=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image0061.jpg\"><img decoding=\"async\" loading=\"lazy\" style=\"display: inline; border: 0px;\" title=\"clip_image006\" src=\"http:\/\/excelvbatips.co.il\/wp-content\/uploads\/2011\/10\/clip_image006_thumb1.jpg\" alt=\"clip_image006\" width=\"534\" height=\"95\" border=\"0\" \/><\/a><\/p>\n<p>\u05de\u05d0\u05e7\u05e8\u05d5 \u05d6\u05d4 \u05d9\u05e4\u05e2\u05dc \u05d0\u05d5\u05d8\u05d5\u05de\u05d8\u05d9\u05ea \u05d1\u05db\u05dc \u05e4\u05e2\u05dd \u05e9\u05e0\u05e4\u05ea\u05d7 \u05d0\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5.<\/p>\n<p><b>\u05e0\u05db\u05ea\u05d5\u05d1 \u05d0\u05ea \u05d4\u05e7\u05d5\u05d3 \u05d4\u05d1\u05d0:<\/b><\/p>\n<p dir=\"ltr\"><b>Private Sub Workbook_Open()<\/b><\/p>\n<p dir=\"ltr\">Worksheets(&quot;\u05e9\u05e2\u05e8\u05d9 \u05de\u05d8\u05d1\u05e2\u05d5\u05ea&quot;).Select<\/p>\n<p dir=\"ltr\">Range(&quot;A1&quot;).Select<\/p>\n<p dir=\"ltr\"><b>End Sub<\/b><\/p>\n<p><b>\u05d5\u05e0\u05e9\u05de\u05d5\u05e8!<\/b><\/p>\n<h3>\u05de\u05e2\u05ea\u05d4 \u05d1\u05db\u05dc \u05e4\u05e2\u05dd \u05e9\u05e0\u05e4\u05ea\u05d7 \u05d0\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d4\u05d5\u05d0 \u05d9\u05e4\u05ea\u05d7 \u05d4\u05d9\u05db\u05df \u05e9\u05d4\u05d2\u05d3\u05e8\u05e0\u05d5 \u05dc\u05d5.<\/h3>\n<h2>\u05d1 \u05d4 \u05e6 \u05dc \u05d7 \u05d4!<\/h2>\n","protected":false},"excerpt":{"rendered":"<p>\u05e4\u05ea\u05d9\u05d7\u05ea \u05d4\u05e7\u05d5\u05d1\u05e5 \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05e8\u05e6\u05d5\u05d9 \u05d1\u05ea\u05d0 \u05e8\u05e6\u05d5\u05d9 \u05d1\u05e4\u05ea\u05d9\u05d7\u05ea \u05e7\u05d5\u05d1\u05e5 \u05d0\u05e7\u05e1\u05dc , \u05d4\u05d5\u05d0 \u05e0\u05e4\u05ea\u05d7 \u05d1\u05de\u05e7\u05d5\u05dd \u05d1\u05d5 \u05d4\u05d9\u05d9\u05e0\u05d5 \u05db\u05d0\u05e9\u05e8 \u05e1\u05d2\u05e8\u05e0\u05d5 \u05d0\u05d5\u05ea\u05d5. \u05d4\u05d1\u05e2\u05d9\u05d4: \u05d9\u05e9 \u05e7\u05d1\u05e6\u05d9\u05dd \u05d1\u05d4\u05dd \u05ea\u05de\u05d9\u05d3 \u05d0\u05e0\u05d7\u05e0\u05d5 \u05e6\u05e8\u05d9\u05db\u05d9\u05dd \u05dc\u05d4\u05ea\u05d7\u05d9\u05dc \u05de\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05de\u05e1\u05d5\u05d9\u05dd \u05d1\u05ea\u05d0 \u05de\u05e1\u05d5\u05d9\u05dd. \u05dc\u05d3\u05d5\u05d2\u05de\u05d0 : \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df &quot; \u05e9\u05e2\u05e8\u05d9 \u05de\u05d8\u05d1\u05e2\u05d5\u05ea&quot; \u05d1\u05ea\u05d0 A1 \u05d4\u05e4\u05ea\u05e8\u05d5\u05df : <span class=\"excerpt-dots\">&hellip;<\/span> <a class=\"more-link\" href=\"https:\/\/excelvbatips.co.il\/?page_id=57\"><span class=\"more-msg\">\u05d4\u05de\u05e9\u05da \u05e7\u05e8\u05d9\u05d0\u05d4 &larr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/57"}],"collection":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=57"}],"version-history":[{"count":3,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/57\/revisions"}],"predecessor-version":[{"id":358,"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=\/wp\/v2\/pages\/57\/revisions\/358"}],"wp:attachment":[{"href":"https:\/\/excelvbatips.co.il\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=57"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}