View Single Post
  #1   Report Post  
Anthony
 
Posts: n/a
Default VB script/macro help - please !!

Hi,
Forgive me for my waffle but I'm new to this and will try and explain what I
want.

I have a workbook where I have my own personal toolbar. On here I have
placed a macro button which the user will 'click' on to create a new
worksheet.
I want this worksheet to be pre formatted with certain text and formula in
it, and the newly created worksheet to be automaticaly renamed after that
particulay days date, ie 10 July.
Once the workbook has been saved, I want the user to be able to repeat this
process every other day, ie create a new worksheet , which is renamed after
that day and which is already pre formatted.

Is this possible - do I want too much ??
Can anybody offer some script for this??
many thanks in advance