Datasheet

The Unhide dialog box appears.

3 Click the workbook you want to unhide.

4 Click OK.

Excel unhides the workbook.

You are now in the workbook you

selected to unhide.

Unhide a Workbook

1 Click the View tab.

2 Click Unhide.

Delete a Macro

ou can delete macros you no longer need by

clicking the Delete button in the Macro dialog

box. Because the Macro dialog box only displays

macros in open workbooks, the workbook that contains

the macro must be open before you can delete the macro.

The Personal Macro Workbook stores macros you want to

make available to all workbooks. Excel creates the Personal

Macro Workbook when you choose to store your first macro

in it. After Excel creates the Personal Macro Workbook, the

workbook opens as a hidden file every time you open Excel.

To learn more about storing macros in the Personal Macro

Workbook, see the section “Record a Macro.”

If your macro is in a hidden workbook such as the

Personal Macro Workbook, you must unhide the

workbook before you can delete the macro. If you try to

delete a macro from the Personal Macro Workbook prior

to unhiding it, Excel displays the following message:

“Cannot edit a macro on a hidden workbook. Unhide the

workbook using the Unhide command.” You unhide the

Personal Macro Workbook and other hidden workbooks

by executing the Unhide command on the View tab.

If you unhide the Personal Macro Workbook, make sure

you hide it again using the Hide command on the View

tab after you delete the macros. Hiding the workbook

prevents you from making inadvertent changes to it.

You cannot undo the deletion process. If you delete a

macro by mistake, you can close the workbook without

saving. Of course, if you close without saving, you will

lose all the work you have done since saving. Your only

other alternative is to re-create the macro.

Delete

a Macro

03_591598-ch01.indd 1803_591598-ch01.indd 18 6/11/10 1:41 PM6/11/10 1:41 PM