When editing macros or when you are working with VBA code and creating forms in MS excel, you have to navigate to the Visual Basic Editor too often. Follow the simple steps below to add Visual Basic Editor as shortcut to quick access toolbar in MS excel.
è Click on office button.
è Click Excel options right at end of the menu on right side.
è Click on customize
è From choose commands drop down select developers tab
è Select Visual Basic and Click on add button.
è Finally press ok to close the options.
Note: Alternatively you can also use shortcut key as ALT+F11 to start Visual Basic Editor.
No comments:
Post a Comment