Ctrl+N > Ctrl + F6 > Right click the sheet name tab for the sheet to be cleaned of macros > Move or Copy
> To book: = Book1
> Create a copy = Yes
[OK]
Book1 > "Sheet1"
> Right click the sheet name tab for "Sheet1"
> Delete
> File > Save As > Enter a new file name, and save the new macro-free workbook.
To switch comments and indicators off
Office > Excel Options > Advanced > Display > For cells with comments, show: = No comments or indicators
To switch comments and indicators on
Office Button> Excel Options > Advanced > Display > For cells
with comments, show: = Indicators only, and comments on hover
Possible bugs
and problems
Multiple windows
To close excel do Office Button > Exit Excel (clicking the close X
only closes the active window)
Active X controls are only active in the window in which they were
created.
Conventions
Names
begin with a z in order to avoid being confused with row letter pairs.
E.g. z<word><word>…