Click the Office button, and then click Excel Options.
|
|
![Click the Office button, and then click Excel Options.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uKUa4pidR8GQcaUHLo-EZIQQOgt5e1GucGNqhBnoRdY1-jYvfE5teGKzrEZbfua8hf6LxsV0y5wV9n_cbcZapLs5s7omOjtaL6btcKg1xrLEORruimYxh6DdKO_eRuV5iXf5qr6EyWPdKk4Kg_-0DhQdsrJU1Ey1waGyzcB62G0StvYgv0nBc6BMSqgUksFEUEY7mLPjR2ueg0=s0-d) |
In the left pane, click Popular. Select the Show Developer tab in the Ribbon.
|
|
![In the left pane, click Popular. Select the Show Developer tab in the Ribbon.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uQh3KMaaUYJzAex23N3P43X4HVQBP-REnBHiFl3uD4OKvXgcyieW1lSMv_8Ag6qNEmcJ8Dq9M5lFYrUXSmIgt72iD62AUf-ftgmfUXgBbdjbBXTR2mOwErvMBugye28yaNjQMVhOAd809rAxBQcp0B-yvUyGNR8fKiiwMpmIkbjBS2Y-kVEZt3cH4KPp6gqpf1Im5JS7-e7Bs=s0-d) |
Click the Developer tab. Click the Macros button.
|
|
![Click the Developer tab. Click the Macros button.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vTU1_UBJBR99YtoMtR8Gm1fh8NTvpQPHDhHfbERy_TT450fu-KRE-9KAZwEpoQ7XSlHvS_Ce3haRHCl0fgyyRyYWKLkH1GuVhOl9570S6IaFiugj9rmV6ykhy7oMLWhgIxRuFly9Kai86cF7wSksRt8ONjBF5wOV5DGTGox6Drh6DHas4c2SRbRi0iMWskoNrXzktwtR75VFk=s0-d) |
Type a name for the macro.
|
|
![Type a name for the macro.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_trojwF4I7ouvJsOxoCXsUV7_HAOzku0db2g3oTCsGg3tQpTPIVK8PR2u_av3FgaAkiBowOdFh3RWWwUvS7aWNnvcBwTS16Bjfd3aFdG1C39KpKFW_Cw0NlJsx24t97UkRhkJnDDxvYxm1LSbJnxsAMjzXSCv2_0Q6N757lXjj3nhkmMdDO79qFnYg=s0-d) |
Click the Macros in list arrow, and then click All Open Workbooks.
|
|
![Click the Macros in list arrow, and then click All Open Workbooks.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s1fgcE5iQolHAi4h8A-_wsQxkrsMcxcMhzK5qClAenRX7g3e1JXD7dGCv9HjKWQTV13qtANThlZEL6wY3P0j1l09jNrmpGzsyVtzqvMlvmPdvkzXtF0KZeZWewmgiSPtcwnqGY6O2P1p2bbmlXKhtpE-tXYxY-5983T6YjvvSDqpyXj3XIM3Usor3msn7OY7iuIkb3wqkGO3Q=s0-d) |
|
![Click Create.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tIs-toYCS3NrzNWWe09S83Da3PlN3XAIXxNiv8hNfkyfOpqT5emH0rEeu--BR1fgNEsMGI7cLUEsnk4Fy-cQx53wtzWuz2P7VtrM3MjIlp88sJKn6jSUnFZEcpPR1bhLz6jgLx-gj6ygavfjiMgFIRkjUIAbg6zGGiVJHWBV5tq7RyQA=s0-d) |
The Microsoft Visual Basic window opens.
|
|
![The Microsoft Visual Basic window opens.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uFkVaOsrPD0F8b9S_rcjr3368NYAXJJaPVUo6u5J-6PWPMszNtgAxOAXfAFg9NciUHoVD9htI2hnf4S4VkEnZgP9tgeazYD9G5oIrATX8nSVgrPePB6hh4XMiGI-nwzweTTG4JUi7TzAhjzVZUTxeBYllTi20kjgzpDN_owGHuIqS4-ziQBVZaDY7vhr0HMRSN-dxL9cUxPJgn=s0-d) |
Click the Module window, and then type new Visual Basic commands.
|
|
![Click the Module window, and then type new Visual Basic commands.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_vRPbVhL0uuDyqD4GXU9ijZu19b1rj0KeFe6JJHndpvrFisB3P6HCU8wDPBl8tMHHKNO1HAsUzK7VMWrfC4xEGnZ4yTIEFYwSIP3sAhGdyXiia6NyVeJH3Ck7DHq2vOzYgQTrWgJM70TSoyd4SZaEMUAplHvGQYU3OEinu9x9vowcYhd_3WpBRLtl3YyKcY9GTIivY_njMyScWc=s0-d) |
No comments:
Post a Comment