![]() We are going to ask Excel to apply the protection to each sheet in a workbook. To declare a variable you enter Dim (Dimension), the name of the variable and the type of variable. A variable is a container that stores information. Select the Module you want to use and then in the Code window start to type your macro. To create a new Module right-click on the Personal Macro Workbook and select Insert > Module You can either store your macro in an existing module within the Personal Macro Workbook or create a new one. If this workbook isn’t listed here it has not been created – you will need to save a recorded macro to the Personal Macro Workbook within Excel first – just something simple. You will see this workbook listed as PERSONAL.XLSB in the Project Window. We are going to save our Macros in the Personal Macro Workbook – any macros saved here are made available to all workbooks. On the Developer tab click the Visual Basic button to open the Visual Basic Editor or use the shortcut ALT F11. ![]() Now make sure the Develop option is ticked in the Excel Options dialog – see below. Right-click on any Ribbon tab and select Customize the Ribbon. To start with you need to display the Developers tab on the Ribbon. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |