Hi,

I have a macro button which upon clicking creates a new sheet titled with the current date. I would like the sheet to be created with a specific formatting (the same formatting for every new sheet created). I suppose this may be linked to creating a template but I'm not sure how best to do this. Would it also be possible to maybe along with the code for creating a new sheet to add in specific formatting commands such as making column C a certain width etc or cell D3 the colour red (all for example). I am trying to design the workbook to be able to be accessible via the cloud so would going down the template route cause issues (in terms of searching for the template directory?).

Many Thanks,