Is it possible to determine the creation date of a worksheet within a workbook?
Is it possible to determine the creation date of a worksheet within a workbook?
I'm not sure what you mean by "within a workbook", but I know that, if you right-click the Excel file (without opening it) and go to Properties, you will see the date on which the file was created, modified and last accessed.
Neville Bailey - Sage Pastel Accounting Consultant
www.accountingsoftwaresupport.co.za
neville@accountingsoftwaresupport.co.za
IronTree Online Solutions
"Give every person more in use value than you take from them in cash value."
WALLACE WATTLES (1860-1911)
In Excell usually under properties of the document under the 'Help" or "File" depending on the version will show the history of the file
Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
Solar pumping, Solar Geyser & Solar Security lighting solutions - www.microsolve.co.za
Hi Neville
Thanks for the input.
I have a workbook that consists of 3 worksheets.
The workbook was created on 13/03/2014, and last edited on 27/05/2014
I know that worksheet 1 was created on 13/03/2014, but I am trying to determine when worksheets 2 and 3 were created, as opposed to edited.
I can't see that Excel would store that date. The worksheet is simply another object that lives in the workbook like a graph or a macro.
Thank you. I thought as much but I harboured a desperate hope!
Did you like this article? Share it with your favourite social network.