"Shane Devenshire" wrote:

Hi,

The manual command is Ctrl+H, ...

You can turn on the recorder and record the steps and then look at the code.
If you need help modifying the code that is recorded post it back here.

The problem is code is very specific and you have given us very little
detail. How are you spelling the month names Jan, J09, January, Jan-08...
How do you want to trigger the macro, when the workbook opens, manually via a
shortcut key, or a toolbar button. What happens when going from Dec -- Jan?
Are there formulas with links on all sheets, do you have chart sheets and
spreadsheet? Are there links in charts, in the defined names? What do you
want to do if someone tries to run the macro twice, how will the code know if
it is a new month or not.
Cheers,
Shane Devenshire

The month is always spelled out as a part of the file name such as June
Sale.xls. I would like it to do this when you open the worksheet. From Dec it
should roll over to Jan since years are not listed. It is not charts just
numbers. The code should check for a month in the formulas then check if that
month is current month if so then nothing if not the current month then
replace with current month. With that last part if the macro was ran twice
nothing would happen.