Hello,

I am still in the early stages of VBA coding. Doing mostly comparisons thru
forum examples and support from a few people locally.

Big picture overview: I have a weekly report for which I have created a
blank template.

My intent is to create a copy of the blank worksheet and have two things
happen at that time; 1. run macro OpenCalendar() & 2. rename the worksheet
just created to "WE 101505". (WE for week ending and the date will come from
cell value in $O$2).