Hi Santaviga,

Try to copy / paste the code from the
Thisworkbook module.



---
Regards.
Norman


"santaviga" wrote in message
...
This has been done but still error.

"Norman Jones" wrote:

Hi Santaviga,

Change:

"Other Shifts " _
& Format(Now, "dd-mmm-yy") '<<==== CHANGE

to
Format(Now, "dd-mmm-yy")


---
Regards.
Norman