{"published":"2014-07-03 13:36:13","url":"https://sironekotoro.hateblo.jp/entry/2014/07/03/133613","provider_name":"Hatena Blog","blog_title":"sironekotoro\u306e\u65e5\u8a18","categories":[],"title":"Excel VBA\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9 \u516c\u5f0f\u30c6\u30ad\u30b9\u30c8 \uff15\u7ae0 \u30a4\u30d9\u30f3\u30c8","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fsironekotoro.hateblo.jp%2Fentry%2F2014%2F07%2F03%2F133613\" title=\"Excel VBA\u30b9\u30bf\u30f3\u30c0\u30fc\u30c9 \u516c\u5f0f\u30c6\u30ad\u30b9\u30c8 \uff15\u7ae0 \u30a4\u30d9\u30f3\u30c8 - sironekotoro\u306e\u65e5\u8a18\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","provider_url":"https://hatena.blog","blog_url":"https://sironekotoro.hateblo.jp/","description":"5-1.\u30a4\u30d9\u30f3\u30c8\u3068\u306f Excel\u4e0a\u3067\u7279\u5b9a\u306e\u64cd\u4f5c\u304c\u884c\u308f\u308c\u305f\u3068\u304d\u3001\u305d\u306e\u64cd\u4f5c\u304c\u884c\u308f\u308c\u305f\u4e8b\u3092Excel\u304b\u3089VBA\u306b\u901a\u77e5\u3059\u308b\u4ed5\u7d44\u307f \u30a4\u30d9\u30f3\u30c8\u306e\u9023\u7d9a\u5b9f\u884c\u3092\u9632\u3050\u306b\u306fApplication.EnableEvents\u3092False\u3067\u5bfe\u51e6\u3059\u308b \u2019False\u2019\u306e\u307e\u307e\u3060\u3068\u3001Excel\u4e0a\u3067\u306e\u3044\u3063\u3055\u3044\u306e\u30a4\u30d9\u30f3\u30c8\u304c\u6291\u6b62\u3055\u308c\u308b\u306e\u3067\u3001\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u306e\u6700\u5f8c\u3067'True'\u306b\u3082\u3069\u3059\u3053\u3068 5-2.\u30d6\u30c3\u30af\u306e\u30a4\u30d9\u30f3\u30c8 VBE\u306e\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u30a8\u30af\u30b9\u30d7\u30ed\u30fc\u30e9\u3067[ThisWorkbook]\u3092\u53f3\u30af\u30ea\u30c3\u30af\u3057\u3066\u3001[\u30b3\u30fc\u30c9\u306e\u8868\u793a]\u3092\u5b9f\u884c\u3059\u308b Workbook_BeforeClose Workbook_BeforePrint Workbook_BeforeSa\u2026","height":"190","type":"rich","image_url":null,"version":"1.0","author_url":"https://blog.hatena.ne.jp/sironekotoro/","author_name":"sironekotoro"}