That's about it. I was wondering if VBE Microsoft Excel Objects (Worksheets), Forms and Modules have a "last modified" date and time stamp somewhere that I can view.
Thank-you!
That's about it. I was wondering if VBE Microsoft Excel Objects (Worksheets), Forms and Modules have a "last modified" date and time stamp somewhere that I can view.
Thank-you!
Not AFAIK. Any change would be reflected in the date and time last modified for the workbook.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Agreed with TMS; don't know of any built-in last modified property for those objects. You could sort of make one for a sheet using the Worksheet_Change event and store the current date-time.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
As I have several versions of one project, I had been keeping them synchronized and all up to date by creating a little schedule of that which I modified then periodically copying/exporting/importing, but I'm afraid I sometimes skip a groove (that is talk from an old fashioned thing called a "record player"...) at which point I just take my best educated guess at that which I was tweaking. As that method recently has failed me, I find myself now just giving up and copying EVERYTHING over. Dang.
The code, btw, recognizes a value in a hidden name and changes behavior depending on the version, but since material on the actual worksheets can be significantly different, I find I have made this my own little bit of fun. Date and time stamps would have been nice...
Thank-you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks