Posts by h

    Hi All


    I opened Two WB(Workbook) Source and distenation


    In the source WB i named A1:A15 as List


    Using Data>Validation In Distenation WB Cell A1 i want to refere to the named rang in the Source WB, so i can choose from the drop down list that exists in the source WB................


    I tried using the help, but..................


    any help is appreciated in advance


    yours
    h

    Hi


    Why when i name a range cannot a space between tow words if i want to name the range using two words
    I can only use this dash ( _ )..........


    why not, spaces
    yours
    h

    Still problem with MsgBox title


    ok................


    if the MsgBox is like this,
    Response = MsgBox(Msg, Style, Title, Help, Ctxt)
    then no problem writing the title i prefere


    but if the MsgBox is like this
    MsgBox c.address
    then i cannot write the title i want for this MsgBox, only the defulte title of Excel Application..............

    Re: Thank u David


    Hello David


    I red the web page u suggested and solved my macro problem
    and it worked well......I recognosed my misstake................


    Thank very much David


    yours
    h

    Hello all


    I have this problem.......
    when tring to unprotect sheet3, an error appears......i know becasue i used
    the unprotection wrongly......


    what i want is to unprotect the sheet3 only as an interfaceonly to make the
    macro works and still keeps the protection of the sheet3 with the password "wer".
    becasue when i protect sheet3 using only the interfaceonly:=true, the user can go to
    the sheet3 from Excel mode and unprotect sheet3 just by pressing unprotect..so i want
    to keep a protection even if the macro is interrupted so the the protection is still on...
    hope i made it clear


    private workbook_open()


    Sheet3.Protect _
    Password:="wer", _
    Contents:=True, _
    UserInterfaceOnly:=True


    End sub



    Sub Test()
    Sheet3.UnProtect Password:="wer", UserInterfaceOnly:=True


    my macro.......


    Sheet3.Protect Password:="wer", UserInterfaceOnly:=True


    End sub


    yours
    h

    ok David, i red your suggestion


    Thank you
    i red your suggetions, but


    i want the macro to cancel the whole word that contains a number not just to take the number or letter out of it..............


    hope u got me


    any idea, thank u in advance
    yours
    h

    ok David


    ok David i mean this


    vInput = Application.InputBox("Please Write Your Item", "Add New Item", _ Type:=2)


    Type:=2 means (Text)string got it from help (InputBox)

    Re to IsNumeric does not work


    ok, i did use your code , so it accepts only a number


    i want it only to accept letters no numbers not even a word that contains numbers (pp80)...........


    i tried to set type:=2.........(text) , but...........



    any idea thank u in advance

    Hi


    my problem is when placing a number begining wiht a letter (p80) this code does recognise it as a number so the macro take it as it is, but this couses a problem to me becasue i do want the macro to discard the number if it contains some numbers and some letters.
    however, the code works fins when i put only a number (Ex: 800)


    sub test()
    Dim vInput As String
    Dim myRow As Range


    vInput = InputBox("Please Write Your Item", "Add New Item")
    If IsNumeric(vInput) Then
    MsgBox ("Please Enter An Item")
    vInput = InputBox("Please Write Your Item", "Add New Item")
    End If
    End sub


    yours hesham

    HI all


    i have several items (List) in column c........
    I defined the items as names through the name dialoge box ..........
    NB: i defined the items giving them the same names as they appera in the list.


    when i wnat to delete an item, i do this through inputbox....
    see macro below...................
    the chosen item is successfully deleted from the list (column c), but i have a problem deleting the chosen name from the name dialoge box...


    i tried, but...........pls see macro below


    any ideas are appreciated in advanced


    yours............hesham



    As you see, when i specify the name the code works fine, but when i use the vInput2 (that carry the chosen name) to delete it from the name dialoge box, does not work.....................................

    Hi all


    I put Excel Files on CD,
    I do not want any body to cope these files from the CD.......


    Is there a way to prevent coping the XLS files from the CD?


    thank u in advance for your ideas.......


    yours hesham

    Thank you David


    Thank u David
    It works fine,but


    when i recorded a macro to do this, it does not show this code, even i pressed the right bottom of the recording bar



    yours
    hesham