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

    HOW TO COUNT RED COLOR BACKGROUND GENERATED FROM CONDITIONAL FORMATTING

    I HAVE A SHEET WHICH HAVE MANY CONDITIONAL FORMATTING IN DIFFERENT COLUMN WITH DIFFERENT CONDITIONAL FORMATTING I WANT FORMULA TO COUNT IF ANY CELL BACKGROUND COLOR FORM RED IN A ROW PLEASE HELP ME HOW TO COUNT ONLY RED COLOR BACKGROUND WAITING FOR REPLY THANKS REGARDS VIPUL
  2. V

    one column have text than other should have numeric

    if in any cell of column A i wrote text "FOC" then active cell of column B should have only numeric value and if in any cell of column A i wrote any numeric value then active cell of column B should have "FOC" ... how this can be happen please help
  3. V

    open worksheet only if not already open

    but the answer does not solve my problem...now also i always get the same msg "that the other worksheet already open. do u want to reopen again. Yes no" please help me
  4. V

    please help me to run this code

    Private Sub Worksheet_Change(ByVal Target As Range) Const Prod_PWD = "123" Dim i As Long If Target.Column = 20 And Target.Row > 5 And Not Updating Then If MsgBox("Add new row?", vbYesNo, "Change Sheet") = vbYes Then Updating = True ActiveSheet.Unprotect...
  5. V

    open worksheet only if not already open

    i have made two worksheet where one worksheet is linked with other whenever i open 1 worksheet the other worksheet open ...so i want that if the other worksheet open already than dont open again and dont show me the msg " that the other worksheet already open. do u want to reopen again. Yes no"...
  6. V

    if excel file already open then dont open again

    hi luke i tried a lot but the message always came that u "u have already open the file .do u want to reopen again"yes or not" ..please help me out so that the file can open once only and the message does not appear please reply me as soon as possible thanks
  7. V

    if excel file already open then dont open again

    the linked file is open in an invisible mode and always show this msg "u have already open the said file. do u want to reopen again. reopen will cause some changes...." so please help me out of this so that the file open only once and the above msg doesnt appear please help me out of this...
  8. V

    if excel file already open then dont open again

    hi hui i have linked two excel file. if u open one file then automatically second file open and i want that if the second file already open then dont open again. i always get a message "u have already open the said file. do u want to reopen again. reopen will cause some changes....". i dont...
  9. V

    run excel file only on designated computer

    HI HUI AS GIVEN BY YOU TO USE HARD DISK SERIAL NUMBER TO OPEN ON DESIGNATED COMPUTER BUT WHEN I TYPE MY HARD DISK SERIAL I.E WD-WX31A80P3675 SOME COMPILE ERROR COMES IT DOESNT WORK BUT WHEN I TYPE ANYOTHER NUMBER SUCH AS 1234 THEN THE FILE AUTOMATICALLY DISAPPEARS. AS I WANT TO RUN MY FILE ON...
  10. V

    run excel file only on designated computer

    i have made an excel file which is private one. so i want that the file won't open in another computer. i want exactly that the file should run only on designated computer something like run only in designated machine id. so that my employee if they copied that file also they cant access on...
  11. V

    if excel file already open then dont open again

    i have linked two excel file. if u open one file then automatically second file open and i want that if the second file already open then dont open again. please send me the answer as soon as possible
Back
Top