View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default Is it Possible Q

right click the excel icon in the upper left near fileview codeleft window
select workbookright window select OPENtype in

sheets("sheet1").range("a1")=date
SAVE

--
Don Guillett
SalesAid Software

"John" wrote in message
...
Is it possible to Time stamp a sheet to indicate everytime a worksheet has
been opened?

I have a file which users should be using daily, but I suspect they are

not
(although they tell me they are!) so I was wondering if I could build a
database within that file that would timestamp an area of a worksheet

every
time the file was actually opened (as opposed to everytime it was saved,

as
they might not have to save it everytime), say A1 in Sheet1, so the second
time they access/open the file in would stamp A2 in Sheet1 etc etc

Hope someone can help