excel-宏(英文)(編輯修改稿)
2024-08-31 09:37 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 cel\XLStart folder. Workbooks in the XLStart folder are opened automatically whenever Excel starts. If you want a macro in the personal macro workbook to be run automatically in another workbook, you must also save that workbook in the XLStart folder so that both workbooks are opened when Excel starts.7. In the Description box, type a description of the macro.8. Click OK to start recording.9. Perform the actions that you want to record.10. On the Developer tab, in the Code group, click Stop Recording . TIP You can also click Stop Recording on the left side of the status bar.TOP OF PAGECreate a macro by using Microsoft Visual Basic1. If the Developer tab is not available, do the following to display it:1. Click the Microsoft Office Button , and then click Excel Options.2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.2. To set the security level temporarily to enable all macros, do the following: 1. On the Developer tab, in the Code group, click Macro Security.2. Under Macro Settings, click Enable all macros (not remended, potentially dangerous code can run), and then click OK. NOTE To help prevent potentially dangerous code from running, we remend that you return to any one of the settings that disable all macros after you finish working with macros.3. On the Developer tab, in the Code group, click Visual Basic.4. If needed, in the Visual Basic Editor, on the Insert menu, click Module. NOTE Modules are automatically created for all sheets in the workbook.5. In the code window of the module, type o
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1