Steps to make a macro applicable to any cell that I choose

Hi Digestive,

Please would you amend your thread title to something a little more descriptive? Perhaps, "How to show the developer tab on the ribbon?".

It's called the developer tab and to show it follow these instructions:
http://msdn.microsoft.com/en-us/library/bb608625.aspx


To make the macro applicable to any cell you choose, the actions it performs will have to refer to the ActiveCell or the Selection. The way the VBA is recorded means that the code will probably be quite close to what you need. Once you've recorded it, see if it meets your needs and, if not, post it on here (using the CODE tags) and we'll have a look at it for you?