Macro in Excel 2016 2013 2010 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.