{"id":1634,"date":"2021-03-15T06:22:57","date_gmt":"2021-03-14T22:22:57","guid":{"rendered":"http:\/\/cnliutz.uicp.io\/?p=1634"},"modified":"2021-03-15T06:23:33","modified_gmt":"2021-03-14T22:23:33","slug":"excel%e5%b7%a5%e4%bd%9c%e8%a1%a8%e6%94%b9%e5%90%8d%e3%80%81%e5%8a%a0%e5%af%86%e7%a0%81","status":"publish","type":"post","link":"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=1634","title":{"rendered":"Excel\u5de5\u4f5c\u8868\u6539\u540d\u3001\u52a0\u5bc6\u7801"},"content":{"rendered":"\n<p>\u6253\u5f00Excel\uff0c\u6309alt+F11\uff0c\u8fdb\u5165\u4ee3\u7801\u7f16\u8f91\u9875\uff0c\u5de6\u4fa7\u5de5\u7a0b\u7a97\u53e3\uff0c\u70b9\u51fb\u9f20\u6807\u90ae\u4ef6\uff0c\u63d2\u5165\u6a21\u5757\uff0c\u53f3\u4fa7\u4ee3\u7801\u7a97\u53e3\u8f93\u5165\u5982\u4e0b\u4ee3\u7801\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Sub \u5de5\u4f5c\u8868\u52a0\u5bc6\u7801\u4fdd\u62a4()\nDim i As Long\nFor i = 1 To Sheets.Count\n    Sheets(i).Protect \"123\"\nNext\nEnd Sub\n\nSub \u53d6\u6d88\u5de5\u4f5c\u8868\u5bc6\u7801\u4fdd\u62a4()\nDim i As Long\nFor i = 1 To Sheets.Count\n    Sheets(i).Unprotect \"123\"\nNext\nEnd Sub\nSub \u66f4\u6539\u5de5\u4f5c\u8868\u540d\u79f0()\nDim i As Long\nFor i = 1 To Sheets.Count\n    Sheets(i).Name = Sheets(i).Range(\"c2\")\nNext\nEnd Sub<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6253\u5f00Excel\uff0c\u6309alt+F11\uff0c\u8fdb\u5165\u4ee3\u7801\u7f16\u8f91\u9875\uff0c\u5de6\u4fa7\u5de5\u7a0b\u7a97\u53e3\uff0c\u70b9\u51fb\u9f20\u6807\u90ae\u4ef6\uff0c\u63d2 <span class=\"readmore\"><a href=\"http:\/\/g1n29wqq.ipyingshe.net:5347\/?p=1634\">Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1,6],"tags":[],"class_list":["post-1634","post","type-post","status-publish","format-standard","hentry","category-uncategorized","category-6"],"_links":{"self":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1634","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1634"}],"version-history":[{"count":1,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1634\/revisions"}],"predecessor-version":[{"id":1635,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=\/wp\/v2\/posts\/1634\/revisions\/1635"}],"wp:attachment":[{"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1634"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1634"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/g1n29wqq.ipyingshe.net:5347\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1634"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}