{"id":5246,"date":"2015-01-28T11:16:58","date_gmt":"2015-01-28T02:16:58","guid":{"rendered":"http:\/\/www.ka-net.org\/blog\/?p=5246"},"modified":"2015-01-28T11:16:58","modified_gmt":"2015-01-28T02:16:58","slug":"%e3%80%8c%e5%9b%b3%e3%81%ae%e3%83%aa%e3%82%bb%e3%83%83%e3%83%88%e3%80%8d%e3%82%92%e5%ae%9f%e8%a1%8c%e3%81%99%e3%82%8bexcel%e3%83%9e%e3%82%af%e3%83%ad","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=5246","title":{"rendered":"\u300c\u56f3\u306e\u30ea\u30bb\u30c3\u30c8\u300d\u3092\u5b9f\u884c\u3059\u308bExcel\u30de\u30af\u30ed"},"content":{"rendered":"<p><a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/ja-JP\/home?forum=vbajp\" title=\"Msdn \u30d5\u30a9\u30fc\u30e9\u30e0 - Visual Basic for Application(VBA)\" target=\"_blank\">Msdn \u30d5\u30a9\u30fc\u30e9\u30e0<\/a>\u306b\u300c<a href=\"https:\/\/social.msdn.microsoft.com\/Forums\/ja-JP\/vbajp\/thread\/8cbfd087-b256-4136-849c-4a62e3fe8226\" title=\"Excel2010-VBA \u753b\u50cf\u300c\u56f3\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u306e\u30ea\u30bb\u30c3\u30c8\" target=\"_blank\">Excel2010-VBA \u753b\u50cf\u300c\u56f3\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u306e\u30ea\u30bb\u30c3\u30c8<\/a>\u300d\u3068\u3044\u3046\u8cea\u554f\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u30ea\u30dc\u30f3\u306e\u66f8\u5f0f\u30bf\u30d6 \u2192 \u8abf\u6574\u30b0\u30eb\u30fc\u30d7 \u2192 \u56f3\u306e\u30ea\u30bb\u30c3\u30c8(\u30b9\u30d7\u30ea\u30c3\u30c8\u30dc\u30bf\u30f3) \u2192 \u300c<span style=\"color: #ff0000; font-weight: bold;\">\u56f3\u306e\u30ea\u30bb\u30c3\u30c8<\/span>\u300d\u3092\u5b9f\u884c\u3057\u305f\u3044\u3001\u3068\u3044\u3046\u8cea\u554f\u3067\u3001\u30de\u30af\u30ed\u306e\u8a18\u9332\u6a5f\u80fd\u3067\u306f\u30b3\u30fc\u30c9\u304c\u8a18\u9332\u3055\u308c\u306a\u3044\u3088\u3046\u3067\u3057\u305f\u3002<\/p>\n<p>Excel\u306b\u9650\u3089\u305aOffice\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u6a5f\u80fd\u3092\u30de\u30af\u30ed\u3067\u5b9f\u884c\u3059\u308b\u65b9\u6cd5\u306f\u8272\u3005\u3068\u3042\u308a\u307e\u3059\u304c\u3001\u3053\u3093\u306a\u3068\u304d\u306fCommandBars\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u300c<a href=\"https:\/\/msdn.microsoft.com\/ja-jp\/library\/ff862419.aspx\" title=\"CommandBars.ExecuteMso \u30e1\u30bd\u30c3\u30c9 (Office)\" target=\"_blank\">ExecuteMso<\/a>\u300d\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u306e\u304c\u4fbf\u5229\u3067\u3059\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Sub ResetPicture()\r\n  '&#x5B;\u56f3\u306e\u30ea\u30bb\u30c3\u30c8]\u304c\u6709\u52b9\u306a\u5834\u5408\u306e\u307f\u5b9f\u884c\r\n  With Application.CommandBars\r\n    If .GetEnabledMso(&quot;PictureReset&quot;) = True Then .ExecuteMso &quot;PictureReset&quot;\r\n  End With\r\nEnd Sub<\/pre>\n<p><a href=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ResetPicture_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ResetPicture_01.jpg\" alt=\"ResetPicture_01\" width=\"523\" height=\"389\" class=\"alignnone size-full wp-image-5247\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ResetPicture_01.jpg 523w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ResetPicture_01-300x223.jpg 300w\" sizes=\"auto, (max-width: 523px) 100vw, 523px\" \/><\/a><\/p>\n<p>ExecuteMso\u30e1\u30bd\u30c3\u30c9\u306f\u3001\u5f15\u6570\u3068\u3057\u3066\u6a5f\u80fd(\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb)\u306eID\u3092\u6e21\u3059\u3053\u3068\u3067\u3001\u305d\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u5b9f\u884c\u3059\u308b\u30e1\u30bd\u30c3\u30c9\u3067\u3001\u4e0a\u8a18\u30b3\u30fc\u30c9\u3067\u306f\u300c<a href=\"https:\/\/msdn.microsoft.com\/ja-jp\/library\/ff862202.aspx\" title=\"CommandBars.GetEnabledMso \u30e1\u30bd\u30c3\u30c9 (Office)\" target=\"_blank\">GetEnabledMso<\/a>\u300d\u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3063\u3066\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u304c\u6709\u52b9\u306a\u72b6\u614b\u304b\u7121\u52b9\u306a\u72b6\u614b\u304b\u3092\u5224\u65ad\u3057\u3001\u6709\u52b9\u306a\u5834\u5408\u306e\u307f\u51e6\u7406\u3092\u5b9f\u884c\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<p>\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306eID\u306f\u3001\u4e0b\u8a18Web\u30da\u30fc\u30b8\u3067\u7d39\u4ecb\u3057\u3066\u3044\u308b\u30b3\u30f3\u30c8\u30ed\u30fc\u30ebID\u30ea\u30b9\u30c8\u304b\u3089\u63a2\u3057\u3066\u3082\u826f\u3044\u3057\u3001<\/p>\n<p><strong>\u30fbOffice\u88fd\u54c1\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb ID\u30ea\u30b9\u30c8 &#8211; Curah!<\/strong><br \/>\n<a href=\"http:\/\/curah.microsoft.com\/33208\/office%E8%A3%BD%E5%93%81%E3%81%AE%E3%82%B3%E3%83%B3%E3%83%88%E3%83%AD%E3%83%BC%E3%83%AB-id%E3%83%AA%E3%82%B9%E3%83%88\" title=\"Office\u88fd\u54c1\u306e\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb ID\u30ea\u30b9\u30c8 - Curah!\" target=\"_blank\">http:\/\/curah.microsoft.com\/33208\/office%E8%A3%BD%E5%93%81%E3%81%AE%E3%82%B3%E3%83%B3%E3%83%88%E3%83%AD%E3%83%BC%E3%83%AB-id%E3%83%AA%E3%82%B9%E3%83%88<\/a><\/p>\n<p>\u4e0b\u8a18Web\u30da\u30fc\u30b8\u3067\u7d39\u4ecb\u3057\u3066\u3044\u308b\u3088\u3046\u306b\u3001\u30af\u30a4\u30c3\u30af \u30a2\u30af\u30bb\u30b9 \u30c4\u30fc\u30eb \u30d0\u30fc\u304b\u3089\u8abf\u3079\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/p>\n<p><strong>\u30fb\u30de\u30af\u30ed\u3067\u5b9f\u884c\u3057\u305f\u3044\u30b3\u30de\u30f3\u30c9\u306eID\u3092\u8abf\u3079\u308b\u7c21\u5358\u306a\u65b9\u6cd5<\/strong><br \/>\n<a href=\"\/\/www.ka-net.org\/blog\/?p=4438\" title=\"\u30de\u30af\u30ed\u3067\u5b9f\u884c\u3057\u305f\u3044\u30b3\u30de\u30f3\u30c9\u306eID\u3092\u8abf\u3079\u308b\u7c21\u5358\u306a\u65b9\u6cd5 | \u521d\u5fc3\u8005\u5099\u5fd8\u9332\" target=\"_blank\">\/\/www.ka-net.org\/blog\/?p=4438<\/a><\/p>\n<p>\u3061\u306a\u307f\u306b\u300c<span style=\"color: #ff0000; font-weight: bold;\">\u56f3\u3068\u30b5\u30a4\u30ba\u306e\u30ea\u30bb\u30c3\u30c8<\/span>\u300d\u306e\u5834\u5408\u306f\u3001\u4e0b\u8a18\u30b3\u30fc\u30c9\u306e\u3088\u3046\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Sub ResetAndSizePicture()\r\n  '&#x5B;\u56f3\u3068\u30b5\u30a4\u30ba\u306e\u30ea\u30bb\u30c3\u30c8]\u304c\u6709\u52b9\u306a\u5834\u5408\u306e\u307f\u5b9f\u884c\r\n  With Application.CommandBars\r\n    If .GetEnabledMso(&quot;PictureResetAndSize&quot;) = True Then .ExecuteMso &quot;PictureResetAndSize&quot;\r\n  End With\r\nEnd Sub<\/pre>\n","protected":false},"excerpt":{"rendered":"Msdn \u30d5\u30a9\u30fc\u30e9\u30e0\u306b\u300cExcel2010-VBA \u753b\u50cf\u300c\u56f3\u306e\u66f8\u5f0f\u8a2d\u5b9a\u300d\u306e\u30ea\u30bb\u30c3\u30c8\u300d\u3068\u3044\u3046\u8cea\u554f\u304c\u3042\u308a\u307e\u3057\u305f\u3002 \u30ea\u30dc\u30f3\u306e\u66f8\u5f0f\u30bf\u30d6 \u2192 \u8abf\u6574\u30b0\u30eb\u30fc\u30d7 \u2192 \u56f3\u306e\u30ea\u30bb\u30c3\u30c8(\u30b9\u30d7\u30ea\u30c3\u30c8\u30dc\u30bf\u30f3) \u2192 \u300c\u56f3\u306e\u30ea\u30bb\u30c3\u30c8\u300d\u3092\u5b9f\u884c\u3057\u305f\u3044\u3001\u3068 [&hellip;]","protected":false},"author":1,"featured_media":7111,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"ExecuteMso\u30e1\u30bd\u30c3\u30c9\u306e\u4e00\u4f8b\u3067\u3059\u3002 [\u300c\u56f3\u306e\u30ea\u30bb\u30c3\u30c8\u300d\u3092\u5b9f\u884c\u3059\u308bExcel\u30de\u30af\u30ed]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,48],"tags":[],"class_list":["post-5246","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-excel-office"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-Excel.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-1mC","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5246"}],"version-history":[{"count":1,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5246\/revisions"}],"predecessor-version":[{"id":5248,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/5246\/revisions\/5248"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7111"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}