When it comes to developing macros, there are a few different ways that you can go about doing it. One way is to develop your macros in their own workbook in Excel. This can be a great way to keep your macros organized and tidy, and also allows you to easily share them with others.
There are a few different ways that you can go about developing macros in their own workbook in Excel. One way is to use the Macro Recorder. The Macro Recorder is a great tool that allows you to record your actions in Excel, and then save them as a macro. This is a great way to create simple macros, but can also be used to create more complex ones. Another way to develop macros in their own workbook is to use VBA (Visual Basic for Applications). VBA is a programming language that allows you to create more complex macros. It can be a bit daunting at first, but there are plenty of resources out there to help you get started.
Once you've created your macros, you'll need to save them somewhere. One option is to save them in your Personal Macro Workbook. This is a special workbook that is always open whenever you open Excel, and contains any macros that you've saved to it. Another option is to save your macros in a regular workbook, and then use the Auto_Open macro to have them automatically loaded when the workbook is opened.
Once you've got your macros saved, you can then start using them! To run a macro, simply press the keys assigned to it (if it has any), or click on the button or link associated with it. You can also add macros to toolbar buttons or ribbon tabs for easy access.