{"id":10571,"date":"2022-07-31T11:42:22","date_gmt":"2022-07-31T02:42:22","guid":{"rendered":"https:\/\/www.stuffy.site\/computers\/?p=10571"},"modified":"2022-07-31T11:43:23","modified_gmt":"2022-07-31T02:43:23","slug":"%e3%82%b3%e3%83%9e%e3%83%b3%e3%83%89%e3%82%81%e3%82%82excel-vba-visible%e3%83%97%e3%83%ad%e3%83%91%e3%83%86%e3%82%a3","status":"publish","type":"post","link":"https:\/\/www.stuffy.site\/computers\/archives\/10571","title":{"rendered":"\u30b3\u30de\u30f3\u30c9\u3081\u3082@Excel VBA Visible\u30d7\u30ed\u30d1\u30c6\u30a3"},"content":{"rendered":"\n

\u524d\u56de\u30a8\u30f3\u30c8\u30ea\u30fc \u3077\u3061\u30b9\u30bf\u30c7\u30a3@Excel \u958b\u767a\u30bf\u30d6<\/a> \u3067Excel VBA\u306e\u958b\u767a\u30bf\u30d6\u3092\u30ea\u30dc\u30f3\u306b\u8868\u793a\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u306e\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u306e\u8868\u793a\u3001\u975e\u8868\u793a\u3092\u5207\u308a\u66ff\u3048\u308bVisible\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u3081\u3082\u3067\u3059\u3002<\/p>\n\n\n\n\n\n\n\n

\u30de\u30af\u30ed\u3092\u8a18\u9332\u3059\u308b\u3068\u5206\u304b\u308a\u307e\u3059\u304c\u3001Excel \u306e\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306f\u3072\u3068\u3064\u3072\u3068\u3064\u306b\u540d\u524d\u304c\u3064\u3044\u3066\u3044\u3066[Alt]+[F11] \u3067\u958b\u304fVBA\u30a8\u30c7\u30a3\u30bf\u30fc\u3067\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u8a18\u8ff0\u3059\u308b\u3053\u3068\u306b\u3088\u308a\u4e8b\u7d30\u304b\u304f\u64cd\u4f5c\u53ef\u80fd\u3067\u3059\u3002\u8a66\u307f\u306b\u958b\u767a\u30bf\u30d6\u306e [\u30c7\u30b6\u30a4\u30f3\u30e2\u30fc\u30c9] \u3092\u30af\u30ea\u30c3\u30af\u3057\u3066[ActiveX \u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3] \u3092\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u633f\u5165\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n

[\u30c7\u30b6\u30a4\u30f3\u30e2\u30fc\u30c9] \u3092\u7d42\u4e86\u3059\u308b\u3068VBA\u30a8\u30c7\u30a3\u30bf\u30fc\u304b\u3089\u3082\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u304c\u64cd\u4f5c\u53ef\u80fd\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n

\u305f\u3081\u3057\u306b\u3001[\u30a4\u30df\u30c7\u30a3\u30a8\u30a4\u30c8 \u30a6\u30a3\u30f3\u30c9\u30a6]\uff08\u306a\u3051\u308c\u3070 [Ctrl]+[G]\u3067\u8868\u793a\uff09\u304b\u3089<\/p>\n\n\n

ActiveSheet.CommandButton1.Visible = False<\/span><\/pre>\n\n\n
\u3068\u5165\u529b\u3001[Enter] \u30ad\u30fc\u3092\u5165\u529b\u3059\u308b\u3068\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u304c\u975e\u8868\u793a\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u518d\u8868\u793a\u3059\u308b\u306b\u306f\u30fb\u30fb\u30fb\u304a\u5206\u304b\u308a\u3067\u3059\u306d\u3002<\/p>\n\n\n
ActiveSheet.CommandButton1.Visible = True<\/span><\/pre>\n\n\n
\u3059\u308b\u3068\u518d\u3073\u3001\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u304c\u73fe\u308c\u307e\u3057\u305f\u3002<\/p>\n\n\n
\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n
\u5b9f\u969b\u306b\u3053\u306e\u30dc\u30bf\u30f3\u306bVBA\u306e\u30b3\u30fc\u30c9\u3092\u8a18\u8ff0\u3059\u308b\u3068\u3001\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u3068\u304d\u306b\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u3092\u5b9f\u884c\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002<\/p>\n\n\n
Private Sub CommandButton1_Click()\n\nEnd Sub<\/span><\/pre>\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u524d\u56de\u30a8\u30f3\u30c8\u30ea\u30fc \u3077\u3061\u30b9\u30bf\u30c7\u30a3@Excel \u958b\u767a\u30bf\u30d6 \u3067Excel VBA\u306e\u958b\u767a\u30bf\u30d6\u3092\u30ea\u30dc\u30f3\u306b\u8868\u793a\u3057\u307e\u3057\u305f\u3002\u4eca\u56de\u306f\u3001\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u4e0a\u306e\u30b3\u30de\u30f3\u30c9\u30dc\u30bf\u30f3\u306e\u8868\u793a\u3001\u975e\u8868\u793a\u3092\u5207\u308a\u66ff\u3048\u308bVisible\u30d7\u30ed\u30d1\u30c6\u30a3\u3092\u3081\u3082\u3067\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72],"tags":[],"class_list":["post-10571","post","type-post","status-publish","format-standard","hentry","category-excel"],"_links":{"self":[{"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/posts\/10571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/comments?post=10571"}],"version-history":[{"count":2,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/posts\/10571\/revisions"}],"predecessor-version":[{"id":10576,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/posts\/10571\/revisions\/10576"}],"wp:attachment":[{"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/media?parent=10571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/categories?post=10571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stuffy.site\/computers\/wp-json\/wp\/v2\/tags?post=10571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}