If you know how to write VBA, then you should be able to create a macro
which contains all the logic and rules you have described.

what kind of advice were you looking for.

Perhaps if you post (in your post, not as an attachment) what you have
written so far and indicate where you are having problems, someone will have
specific advice for you.

--
Regards,
Tom Ogilvy

"Jako" wrote in message
...

Could anyone please suggest a way to do this

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

Eg.

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

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

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

Any advice appreciated.


--
Jako
------------------------------------------------------------------------
Jako's Profile:
http://www.excelforum.com/member.php...fo&userid=8710
View this thread: http://www.excelforum.com/showthread...hreadid=277597