Guide to Excel Advanced Features



Yüklə 59,04 Kb.
səhifə8/10
tarix03.01.2022
ölçüsü59,04 Kb.
#36038
növüGuide
1   2   3   4   5   6   7   8   9   10
Creating a New Macro

Y
ou can start a menu from scratch by selecting Macro from the Tools menu, and then choosing Macros.... If you enter a valid name in the Macro Name: field, the Create button will become enabled, and you can click it to start a new macro. If you want to create a macro that closes Excel, for example, simply enter application.quit as shown in the example below. You can then add a button in the usual way, and use the macro.

Note that if you've changed your spreadsheet, then running your macro will do the same as trying to close Excel using the menu, Alt F4 or the Close button - i.e. you will be asked if you want to save your file. If you want to have more control over the user interface and stop this happening, you can use the msgbox() and if commands.



Yüklə 59,04 Kb.

Dostları ilə paylaş:
1   2   3   4   5   6   7   8   9   10




Verilənlər bazası müəlliflik hüququ ilə müdafiə olunur ©muhaz.org 2023
rəhbərliyinə müraciət

    Ana səhifə