• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. E

    Changing Data in a cell after a certain date

    Just to add to this - I suppose all I am asking for is for the sheet to finish unprotected rather than protected!
  2. E

    Changing Data in a cell after a certain date

    Sir JB7 Many thanks for this. I really appreciate the time you have spent on this! Just quickly, this does everything I have asked but it does 'freeze' the cells - i was hoping to be able to edit them in order to hyperlink a document to them etc.... any chance of an edit to freeze the cells...
  3. E

    Changing Data in a cell after a certain date

    SirJB7, I have searched the forum however was finding it difficult as some previous codes would do aspects of what I wanted, but not the entire shebang! To answer your questions, I have used all available columns up to IV! Column A contains field headings and cells B1,C1,D1 are merged...
  4. E

    Changing Data in a cell after a certain date

    Hi I have a data set that is set out that each column is a day, reading from left to right. I need to find a VBA whereby on automatically opening the spreadsheet it will look at my data set, and every column that has a date less than today will be 'frozen'. The problem is that the data in...
Back
Top