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

    lock the workbook

    hi dear professors i have a question i apologize because my english is not good and i try to explane my need. for example you think : i made a workbook excel for my company and i guess there will be my manager after i make this report file and done my work and give it to him this file he will...
  2. hoomantt

    Ask A Question Before Run A Macro

    please help me to write a code that if some one clicks on trash icon in my excel attached file that clear some ranges in some worksheets , first open a window to ask from user that are you really want to delete all these data? then if user click on "yes" button then run macro and if user click...
  3. hoomantt

    Ask yes Or No before do a macro

    please help me to write a code that if some one clicks on trash icon in my excel attached file that clear some ranges in some worksheets , first open a window to ask from user that are you really want to delete all these data? then if user click on "yes" button then run macro and if user click...
  4. hoomantt

    macro code for delete range of cells in several Pages

    Hi Dear Professors i need a help in my example attached file(TEST), i need a macro that when i click on recycle bin image in "MENU" Page: then clear just data in cells in some of ranges in several pages like this: page USA , Range A3:C5 Page Italy , Range A2:B4 Page china , Range A5:C9 Please...
  5. hoomantt

    macro for open another excel workbook

    Hi dear professors i want a vb code for open another excel file in my workbook folder. i have a workbook (named : "All.xlsx") in a folder (Named : "Check"). there is another excel file in this workbook (named : "K.xlsb"). i want make a command button in (All.xlsx") in a user form that with a...
  6. hoomantt

    Help for draw dashboard

    Hi dear professors, in attached picture i have a table that first column is name of some goods and the second column is the share of every one in my company sales. and want to draw the left chart that shows share of every goods in my sales. please,Please,Help me thanks
  7. hoomantt

    vba for print a page with a list of data in pivot table

    Hi dear professors, Please Please Please, i need a vba code for print my sheet2(A1:E22) in my attached example. in sheet1 we have database in sheet4 i made a pivot table from sheet1 in sheet2 i want print(A1:E22) that when i choose slicers A then B then C for this select of slicers. for example...
  8. hoomantt

    Mouseover shape

    Hi Professors, i want make a menu for my workbook. a menu with for example 5 square(shapes). i want use them in my 5 worksheets. such as a website menu! the squares have hyperlinks to the sheets and user can click them and go to that sheet. now i want : when user mouseover on a square the basic...
  9. hoomantt

    hide every things

    Hi Dear Professors, i have a question please help me thanks thanks thanks i wana a workbook that has a vb code for: 1- hide every things such as sheet tabs,formula bar,menu bar,Horizontal and vertical Scroll bars,and full screen the work book 2- hide resize icon on top 3-no one cant resize the...
  10. hoomantt

    Hide/Unhide sheets based on change a cell value

    Hi Drear professors; i have a question and hope to help me i have a workbook with several worksheets like attached example i want when open this workbook , all sheets except of "menu" be hidden in page "Menu" cell "B2" i have a list of all pages except of page "menu" i want when i change value...
  11. hoomantt

    Make Pattern Password

    Hi Dear Professors, Dear Friends is there any way to make pattern password in an userform or in a sheet for input pattern and when it is true we can see the data in that excel workbook ?! Like Pattern Password in Android Mobile To Get in Our Mobile.
  12. hoomantt

    receive username and password

    Hi Dear Professors is there any way that we make a file(excel workbook) and send to others in my office to get their windows username and password? for example when they open the file or use this file , we get an outlook mail or gmail or ... or in an address in google doc his/her username and...
  13. hoomantt

    filter a column in pivot table with data in a column of other sheet!

    Hi Dear Professors Is there any way to filter a pivot table with all of data in a column? Foe ex. In the attached file I have a macro that filter a column and set all data after filtering in the (“main”) Sheet. Now I want to filter the pivot table column A in (“sheet1”) with the data there...
  14. hoomantt

    Remove Error Message

    Hi Dear Professors, i have a macro enable file. when i want to open it , before open that file , shows the error that i attached here. i should send it to other co-workers is there any way(vb code or ...) to hide this error before open the file ? Thanks a lot
  15. hoomantt

    put a picture like background in a listbox

    Hi Dear Professors; Is Thare any way to make a picture as a watermark background in a listbox in a userform ? such as put the logo of a company as a background in a list box in a user form ? i am a beginner in excel and vb . if you can please help me with a sample file. thanks a lot .
  16. hoomantt

    Print a listbox in a userform

    Hi Dear Professors, i have a listbox(listbox1) in a userform(userform1) in my workbook . i want a command button in my userform to print( print preview)data that shows in listbox1 . can you please help me with a sample file ? i am a beginner in vb and can not use only codes . i need a sample...
  17. hoomantt

    Go To a Special Page

    Hi Dear Professors i need a macro for assign to a shape that when user run this code , user go to page that named in cell g1 in sheet H . that cell ( cell G1 in sheet H) connect to a combobox . there for i want when use that combobox with a shape near it i can go to that page .(in combo box...
  18. hoomantt

    mail merging with dynamic pictures

    Hi Dear Friends Dear Professors Is There any way that we can use dynamic pictures in mail merging? For Example, I have a workbook that Contains personal Data. I want To mail merge pictures of persons . there is not important for me that the pictures be in that workbook or in a folder in my pc ...
  19. hoomantt

    mail merge with Pictures

    Hi Dear Friends Dear Professors Is There any way that we can use dynamic pictures in mail merging? For Example, I have a workbook that Contains personal Data. I want To mail merge pictures of persons . there is not important for me that the pictures be in that workbook or in a folder in my...
  20. hoomantt

    countif sum of several data

    Hi Dear Professors ; I have a excel sheet that in every row are sale of companies. in every columns are month names. then in every cell we have the sale of a month of a company! I want in every column know that how many companies make approximately 80% of sale of that month.
  21. hoomantt

    Circular Graph

    Hi Dear Professors; Yesterday I saw a picture that shows a circular Calendar that i attached it Here. is there any way to make this calendar with graphs in excel just like that picture(very cute and cool)??? if it can;please help me . . . . Best Regards.
  22. hoomantt

    format body of message that will send with vb

    Hi Dear Friends, I have a vb that will send active workbook such an attachment with outlook. that is it : ---------------------------------------------------------------------------------- Sub EmailFile() Dim OutMail As Object Set OutApp = CreateObject("Outlook.Application") Set...
  23. hoomantt

    make a list of hidden sheets names in a userform

    hi Dear professors; i have a workbook that there are some sheets in there these sheets are different conditions some of them are visible some of them are hidden and some are very hidden i want a macro that when user click on a button to run this macro; that user see a user form that contains a...
  24. hoomantt

    merge cells with a short key

    Hi Dear Professors; 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...
  25. hoomantt

    current date and time

    hi dear professors; i have a vb code in my file that when a user click on a shape that code runs. i need a vb code or a formula that when that user click on that shape and run that code , input current date in a cell and input current time in an other cell . please help me!!! Thanks a lot
Back
Top