In the Project Explorer (upper-left corner of the Editor), right-click on a module that you want to delete.Press Alt+F11 to display the VBA Editor.The second approach is to simply work with the existing workbook, and is a viable choice if you feel comfortable with macros in the first place. Your worksheets have now been moved to a new workbook-one that does not have any macros attached to it. Rehide any worksheets you unhid in step 1.Make sure the Create Copy check box is not selected.Using the To Book drop-down list, choose (new book).Excel displays the Move or Copy dialog box. Choose Move or Copy from the Context menu.Right click on one of the worksheet tabs. (Click on the first worksheet tab, then hold down Shift as you click on the last worksheet tab.)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |