Could anyone please suggest a way to do this

If today's day is a monday then i want to add a worksheet named wit
fridays date and prefixed with "WE".

Eg.

If the workbook is opened on Monday 15th November 2004 then i want t
add a worksheet named "WE 19.11.04".

If the Monday is the last monday in the month i also want to add
worksheet named "November 2004" or whatever the month is ie. If
opened the workbook on the last monday in June then i want to create
Worksheet named "June 2004".

Also if the Monday is the second Monday in the month i then want t
hide all worksheets named from the month before.
Eg. If it is the second monday in November then i want to hide al
worksheets with the 10th month in their name.
So for example a worksheet "WE 22.10.04" would be hidden as would
worksheet "WE 29.10.04" but a worksheet named "WE 05.11.04" would no
be hidden. I do want to keep all worksheets with the month and yea
visible though.
So using the above, the worksheet "October 2004" would stay visible.

Any advice appreciated

--
Jak
-----------------------------------------------------------------------
Jako's Profile: http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread.php?threadid=27759