• 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.

Recent content by raef.qawasmi

  1. R

    Hide sheets based on the computer's date

    PS. I did the code for the macro auto run ----------------------------- private sub woorkbook_open run "myMacro" end sub ----------------------------- Again, Thank you Ra'ef
  2. R

    Hide sheets based on the computer's date

    Hello again the five hrs thing was not a good idia, i was trying the first one: ---------------------------------------------- Sub hide_sht() Dim sht As Worksheet For Each sht In Application.Worksheets If sht.Cells(1, 1).Value <> Date Then sht.Visible = msoFalse Else...
  3. R

    Hide sheets based on the computer's date

    Hello Hui Thank you so very much, it's exactly what I need, you're amazing. Raef
  4. R

    Hide sheets based on the computer's date

    Its working ,Thank You Very Much But i need run macro every 5 Hour to refresh visible sheet.
  5. R

    Hide sheets based on the computer's date

    Hello guys I have one workbook for each month, contains a worksheet for each day (31 sheets) Cell A1 of each sheet is a date cell. what i need to do is to hide the sheet IF the sheet's date (A1) is not equal the computer's date: If A1 <> today() then sheet.visible = xlSheetVeryHiden...
  6. R

    Need formula or VBA to lock cells based on value in other cells

See more
Back
Top