田中様エクセルのファイルで開いた時に指定運動サイズにて固定して常に前面表示したいのですがイメージとしてツールアプリみたいな感じで表示したいのですが可能ですか？現在やりたいことはエクセルでただ単に元の金額を入力したら手数料が加算されて表示するといったただの計算機なのですが毎回ウインドウを調節したり背面に消えるので余計面倒な感じを使いやすくしたい次第です。この方法がわかれば他にも応用できると期待しておりまして… お知恵をお貸し下さいませ！よろしくお願いします！

ECマスターズの田中です。 Excel自体の機能としてはありませんが、 Excelファイルを開いた直後に動作するマクロを作成していただくことで、可能となります。 Excelにて「開発」リボンが表示されていない場合は、ファイル＞オプション＞リボンのユーザー設定より、「開発」にチェックを入れていただき、表示された「開発」リボンより「Visual Basic」をクリックしてください。 VBAのウィンドウが開きましたら、 http://d.hatena.ne.jp/sumihira1989/20140704/1404476489 上記URLの「１．ブックを開いた時にマクロを自動実行する（workbook_open）」の方法に沿って Workbook_Open プロシージャの作成をお願いします。 Workbook_Open プロシージャの中身を、 MsgBoxの代わりに http://www.vba-ie.net/operation/windowstate.html 上記「Excelウィンドウの幅・高さサイズを設定するマクロ」の通りにご記載ください。最後に、Excelファイルを保存される際に、マクロ機能の保存されない「Excel ブック (*.xlsx)」形式ではなく「Excel マクロ有効ブック (*.xlsm)」もしくは「Excel バイナリブック (*.xlsb)」形式で保存していただくことで、毎回起動の度に、同マクロが動作し、ウィンドウのサイズが自動で設定されるようになります。

田中様いつもありがとうございます！解決いたしました！

エクセルのウインドウサイズ指定固定について

Warning (2) : Undefined array key "agtlogin" [in /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 141]

Code


        $showDrafts = ($auth['alogin'] || $auth['agtlogin']);
        $post = $this->ForumPosts->get($id, contain: [

Cake\Error\ErrorTrap->handleError() /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 141
App\Controller\ForumController->view() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/Controller.php, line 503
Cake\Controller\Controller->invokeAction() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 166
Cake\Controller\ControllerFactory->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 141
Cake\Controller\ControllerFactory->invoke() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/BaseApplication.php, line 362
Cake\Http\BaseApplication->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 86
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php, line 159
Cake\Http\Middleware\CsrfProtectionMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Middleware\BodyParserMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php, line 118
Cake\Routing\Middleware\RoutingMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php, line 71
Cake\Routing\Middleware\AssetMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/src/Middleware/HostHeaderMiddleware.php, line 35
App\Middleware\HostHeaderMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php, line 115
Cake\Error\Middleware\ErrorHandlerMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 60
Cake\Http\Runner->run() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 98
Cake\Http\Server->run() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (2) : Undefined array key "agtlogin" [in /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 250]

Code

        $dispatchStaff = [];
        if ($auth['alogin'] || $auth['agtlogin']) {
            $conn = ConnectionManager::get('default');

Cake\Error\ErrorTrap->handleError() /home/ec-masters/forum-cakephp/src/Controller/ForumController.php, line 250
App\Controller\ForumController->view() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/Controller.php, line 503
Cake\Controller\Controller->invokeAction() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 166
Cake\Controller\ControllerFactory->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Controller/ControllerFactory.php, line 141
Cake\Controller\ControllerFactory->invoke() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/BaseApplication.php, line 362
Cake\Http\BaseApplication->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 86
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/CsrfProtectionMiddleware.php, line 159
Cake\Http\Middleware\CsrfProtectionMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Middleware/BodyParserMiddleware.php, line 157
Cake\Http\Middleware\BodyParserMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/RoutingMiddleware.php, line 118
Cake\Routing\Middleware\RoutingMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Routing/Middleware/AssetMiddleware.php, line 71
Cake\Routing\Middleware\AssetMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/src/Middleware/HostHeaderMiddleware.php, line 35
App\Middleware\HostHeaderMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Middleware/ErrorHandlerMiddleware.php, line 115
Cake\Error\Middleware\ErrorHandlerMiddleware->process() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 82
Cake\Http\Runner->handle() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Runner.php, line 60
Cake\Http\Runner->run() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 98
Cake\Http\Server->run() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (512) : Unable to emit headers. Headers sent in file=/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php line=37 [in /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65]

Code

            $message = "Unable to emit headers. Headers sent in file={$file} line={$line}";
            trigger_error($message, E_USER_WARNING);
        }

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 65
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Warning (2) : Cannot modify header information - headers already sent by (output started at /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Error/Renderer/HtmlErrorRenderer.php:37) [in /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 158]

Code

        $reasonPhrase = $response->getReasonPhrase();
        header(sprintf(
            'HTTP/%s %d%s',

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 158
Cake\Http\ResponseEmitter->emitStatusLine() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 68
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Code

            foreach ($values as $value) {
                header(sprintf(
                    '%s: %s',

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 191
Cake\Http\ResponseEmitter->emitHeaders() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 69
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]

Code


        return setcookie($cookie->getName(), $cookie->getScalarValue(), $cookie->getOptions());
    }

Cake\Error\ErrorTrap->handleError() [internal], line ??
/home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 228
Cake\Http\ResponseEmitter->setCookie() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 212
Cake\Http\ResponseEmitter->emitCookies() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 200
Cake\Http\ResponseEmitter->emitHeaders() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/ResponseEmitter.php, line 69
Cake\Http\ResponseEmitter->emit() /home/ec-masters/forum-cakephp/vendor/cakephp/cakephp/src/Http/Server.php, line 142
Cake\Http\Server->emit() /home/ec-masters/forum-cakephp/webroot/index.php, line 37
[main]