Hi,

I've got a few macros that i have saved to my ribbon under "My Tools" and i use all the time. My workbook is here for anyone who is interested in them (http://dropcanvas.com/nxay0).

These macros are available every time i open a workbook and are particularly useful for auditing workbooks i didn't create. If you are unsure on how to set this up then read this http://office.microsoft.com/en-gb/ex...001087296.aspx.

Including:

* Unhide all sheets in a workbook
* Unhide/Hide the Sheet Name Tabs (toggle)
* Calculation mode Toggle
* Format Workbook to find formulas, constants etc...

I've had these set-up for a while and the formatting ones came from a blog post i found a couple of years ago. I think the name of the guy was Tom Oligarvy but i can't find the link now. So if you are out there Tom. Thank you for those.

Was wondering what other macros other people had set-up and how useful the find them? And, if they were willing to share them so we can all turn our personal.xls into a vba powerhouse of excel-awsomeness!

Cheers,

J