+ Reply to Thread
Results 1 to 4 of 4

Change Content Created date

  1. #1
    Registered User
    Join Date
    11-20-2011
    Location
    ireland
    MS-Off Ver
    Excel 2010
    Posts
    53

    Change Content Created date

    Hi All

    Is there a way to change the content created date, i have used a old sheet i use to use but want it to show a different date, i know you can copy all the sheets to a new book and save but doing this the 87 sheets withing the workbook loose some of there shape

    I have attached you a picture of what i mean as its not the created date in the general tab its the one in the details tab

    Thanks
    Attached Images Attached Images

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Change Content Created date

    I am a little cautious about providing any input here, as (depending on your reason for wanting to do this) it might violate Rule 11. To remind you:

    11. Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords.

    I can imagine many scenarios whereby changing the original creation data could be used to perpetrate a fraud.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    11-20-2011
    Location
    ireland
    MS-Off Ver
    Excel 2010
    Posts
    53

    Re: Change Content Created date

    Hi

    Its only because ive used a old document i had to create something new, 99% of the content changed but i totally forgot to copy it over to a new workbook before i started. its more of a ocd issue lol

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Change Content Created date

    To create an exact replica of your workbook and be done in just few seconds.

    1. Right-click on first sheet and select from the menu Select all Sheets
    2. Right-click again and choose Move or Copy..
    3. from the drop-down window choose (new book) and check box for Create a Copy.
    That's all.
    Last edited by AlKey; 06-09-2017 at 09:10 AM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Modify code instead equal content change to specified content
    By elmnas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2015, 07:55 AM
  2. [SOLVED] Calling content of dynamically created textboxes
    By dudebird47 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2014, 07:12 AM
  3. Change content of one cell based on content of another
    By stlellen in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-18-2014, 03:26 PM
  4. Change the content of a cell based on change the current date
    By aimanraya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-14-2014, 07:07 AM
  5. error Content created date format
    By Kaak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-25-2010, 06:23 AM
  6. Hyperlink created from cell content
    By Endorphin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-21-2008, 04:06 AM
  7. [SOLVED] Change File DATE created & modified
    By Don Guillett in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-26-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1