#Visual basic in excell code#
This action opens a Print dialog box with the Current Module option button selected in the Range section and the Code check box selected in If you want to obtain a printout of the lines of code in your macro before you begin making changes, choose File → Print or pressĬtrl+P.
You then need to click OK in the alert dialog box, pressĮsc to close the Macro dialog box, and then unhide the Personal Macro Workbook before you repeat these first two macro editing steps.Īfter you have the lines of code for the macro displayed in the Code window in Visual Basic Editor, you can edit any of its statements as In that case, Excel displays an alert dialog box telling you that you can't editĪ hidden macro and informing you that you need to use the Window → Unhide command. The Personal Macro Workbook and this workbook is still hidden.