Search results

I want a Macro For Merge Cellsthat select with mouse drag with a short key(e.g Ctrl+Q),That they Are In A Column(Such as column A) these cells just countains data in first cell. for example i want to merge cells A5:A12 with Short Key (Ctrl + Q) that just there is one data in just first cell(A5)...

Hi every professionals; i want a macro with a short key (such as Ctrl+Q) to merge selected cells with mouse drag . my cells are in a column(e.g column A) and there is a data in first cell that i want to merge. for example i want to merge cells with short key (Ctrl+Q) A5:A12 and just data only...

Hi professors; how can i use a custom format cell that when i have a data in my cell that it is a text and a percent , it shows with the format of percent not a text cell . for example there is a data like ( hooman 21.45%) in cell A1 when i click the Enter Key on my Keyboard it converts to (...

Hi Professors I have a question. Is there any way(a macro) that when users want to unhide the hidden sheets , they see a window to input password(password has been made by admin)? basically i want a macro to hide several sheets that i determine the sheets name.(i think there is better that i...

dear Sirjb7 hi and have a nice day when i want print a special image or shape in my workbook that there is in (for example in worksheet1) and that name is (for example shape1 or chart1 or ... )what should i do? would you please give me that macro? there might be several shapes in a page ...

thanks alot my dear friens SirJB7. you are the best,the one and the kindest man in the world. you are a hero . my hero and thanks a lot.......

mr Hui,'i want to print just the shape or image , not around it.aroun this shape are text and numbers and formulas.like a page of newspaper.you said true but that isnot usefull for me. thanks alot about you help and read my question . thanks....

oh thanks , that is very good and usefull dear professor SirJB7. you are the one.the best.the biggest man in the world. thanks aot.and if you want please go on and help me. thanks thanks and thanks....

Thanks my dear friend, my friend Sir SirJB7,thanks...

hi dear Hui; my image is a map of a country and it is not so big that there should be some data around it,and when we want to print it,just want to print that map with best and biggest size on A4.therefore please help me if you want,please....

i have an image in my workbook and want a macro to print it.just print it on A4 paper.and how much it can, print it full screen.(with maximum height and maximum width)

please help me dear sirjb7....

hi dear sirjb7 i am so stupid in this events and dont understand your teach to me, you are a good teacher but i am stupid,and i will ask you please please please help me with a good uploaded file and i research on it and understand, my knowledge about vb is very little and i am a bad student...

hi Smallman; if i want to use a gif image in an userform without exist a folder like you make,how can i do? is there any way. is there any way to attach the gif file to this workbook instead of a folder? thanks

hello every body, help me please

hi, when i insert a microsoft web browser in a worksheet an erroe shows: that error is : can not insert object. what should i do ? please!!!

sir hui can you please upload an example for insert animated images in an userform and i learn from it? please,please.... thanks alot.

Hi Professors; i have a question: how can i insert a gif image(an animated image) into a sheet of a workbook? please help me,please. thanks alot.

Sir Sirjb7 And bobhc; thank you from your help. how much that was easy,and how much i am fool. thanks , thanks , thanks....

hi professors, may you help me please. i need a full vba code for format cells , like font color of font size color of cell bold & un-bold italic and non-italic underline theme color of cell heigh cell width cell left or middle or right the text in cell and every things that you...

Thanks alot SirJB7 and jeffreyweir SirJB7 , you Are A really proffessor .you are a nice teacher.you are the best..... really really thank you so much. i love you man.

hi every professors; i have an excel file.for example the sheets name are: MENU sale store stock visitors ali john kati hooman and.....(some Seller names) first - i need a macro to make a list name of these sheets names(the list name be in the sheet("menu") in column "D").(a list of...

thank you very much . that is usefull. NARAYANK991

hello i have a question and it is necessary for me to solve it. i have 18 workbooks that manage salary of 128 persons . in every workbook , there is a sheet that in column(A) there is personal names. in every work book there are variable sheets.for example in one workbook there is 30 sheets...

i have a file and i want a macro (vb) code that dont let any user that have not the password to unhide the hide sheets. when they want to unhide the sheets excel wants a password for it . . . thanks dear proffessors.