Excel 2000 Question

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a workbook with 4 sheets and I need the date to
copy or duplicate everytime I open it up on all 4 pages
in one cell how do i do this??




Thanks
John
 
Hi
you may give some more details what you're trying to achieve:
- what date should be copied
- Do you want to put this in a specific cell on each worksheet

Maybe the following will do what you want. Put the code in your
workbook module

Private Sub Workbook_Open()
worksheets("Sheet1").range("A1").value = now
worksheets("Sheet2").range("A1").value = now
worksheets("Sheet3").range("A1").value = now
worksheets("Sheet4").range("A1").value = now
End Sub
 
Back
Top