Macro in Excel 2007
Making a spreadsheet very hidden
Using the Hide command you can hide the data and formulas from "inquisitive minds". But some of them
still can use Unhide command. Nevertheless you can completely hide Excel spreadsheet so that it will
be needed some VBA programming to unhide it.
Create a toolbar button or menu item to run a Macro
If you assigned a key combination to a macro when you recorded it, you can run the macro by pressing that
key combination. If not, you can subsequently assign the macro to the menu item.
Record a Macro using the Macro Recorder
The easiest way to create a macro in Excel is to use Office's built-in Macro Recorder tool.