Thread
:
Is it Possible Q
View Single Post
#
11
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]