Posts by h

    Sorry Roy, i did not make my self clear


    Is there a code to Disable the manue that appears when
    Placing mouse on a sheet Tag and then press mouse wright click ?
    I tried This one:......but


    PHP
    Application.CommandBars("sheet").Enabled = False



    My Second Problem:
    I have the comming code........is there a way to put the name of a closed WB insted of the active workbook wich its name is (oo.xls)
    i.e.insted of this opened WB.
    there might be a way to choose any closed WB.


    PHP
    Sheets("OrderForm").Copy After:=Workbooks("oo.xls").Sheets(3)



    Thank u

    Hi


    Is there a code to Disable the manue that appears when pressing mouse wright click on a sheet ?
    I tried This one:......but

    PHP
    Application.CommandBars("sheet").Enabled = False


    also, In this code........is there a way to put the name of a closed WB insted of the active workbook name(oo.xls) i.e.insted of the opened WB.
    there might be a way to choose any closed WB.


    PHP
    Sheets("OrderForm").Copy After:=Workbooks("oo.xls").Sheets(3)


    Thank u

    Hi


    I have an active WB1.......
    I can save sheet1(or any sheet) to a different WB (WB name:Carpet)........


    Now The active file is WB2....
    I want to save sheet1(or any sheet) to the WB(Carpet)


    I know how to save a sheet to a different WB, but the problem is saving another sheet(from the same active file or another file) to the same WB


    Could any u help me doing this job?



    yours
    h

    Hi


    I have a combobox that shows several names.....


    the point i want is when i select a name from drop-down combobox, so the chosen name should work as a hyperlink to other cell within the same sheet


    i.e. when choosing a name, it should take me to a preselected cell
    names in combobox shoul be hyperlinked to other cells within the same sheet.


    hope it is clear


    yours
    h

    Hi


    I have a WB1 that is linked(via lots of formulas) to WB2........


    I did unchek AskTo Update Links in the WB1 to avoid being asked to edit Links , I also within the Edit link dialoge box i checked Donot ask to update linke and update links..............


    my problem is: even did what i discribed above i still receive Edit Link dialoge box when opening WB1...i confirmed that all the links are correct.....


    i do not want to receive this dialoge box each time i open WB1


    Thank u 4 your help
    yours
    h

    after doing what Dave said, set Cancel property of the bottom to true...


    in this case Esc well work...i.e while u filling in a userform and suddenlly want to stop working with the userform..then press Esc botton



    it will work without any need to go to cancel bottom on your userform


    yours
    h

    Thank u all


    my problem has been solved


    here is the complete code


    yours
    h

    Welcome Ranto in this Fantastic Excel Web


    you can use this web search engine to find out your pice of information
    you can find almost all what you need here in the site


    it is one of the best to start with.............. using Excel


    I finally recommend u to use Excel 2003 as i used Excel 97,2000,XP and still using all of them due to my work nature (Chartered accountant moving to client bases)..........I have found that Excel2003 provide the dynamic help, specially you said that you are going to use it to trac stock movment, so 2003 version does provide such tool for this kind of job.......


    Finally i wish u all the best
    yours
    h

    Hi


    I have several Textboxs in a userform
    main Textbox shows the total of the values entered into textboxs


    my problem is : the total does not appear in the main Textbox untill i fill in
    all other Textboxs............somtimes i want to fill in only few textboxes, so
    the total does not appear in the Textbox that shows the total......


    here is the codes i used in the userform:


    I highly appreciate any help
    yours
    h

    Thank u all


    My problem is solved and here is the code that has worked well:


    hi


    my problem is with bal.value, a message box appears tilling me object variable or with block variable not set............the rest of hte code works fine


    could u pls tell me why is this..........Thank u



    all helps r appreciated
    yours
    h

    sorry i did not make my self clear


    what i mean: i want the target to be A cell that sum the integer in B and integer in C, so when i enter 20 in B1 and 20 in C1 then A1 changes to 0, so i want the A1 is target ...........and so on with A2 A3

    Hi
    A1 B1 C1
    0 20 20


    A1:=sum(B1-C1)


    i want the code to recognise A1 as the Target, so if the Target <> 0 then procced the rest


    Quote

    [/code]


    could someone pls help........any help is appreciated


    yours
    h