• 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

    thank you this is best answer if i fire and dont be in company to change this date monthly, this file be kill itself. thanks alot.
  2. hoomantt

    lock the workbook

    No! i want my made files dont work if i my boss tell me i should not go to work from a day. i want a code for example if i were not in office and made one cell value from 1 to 0 , my workbooks distribute and expose! if they want my work and my files, they should pay me and dont fire me! thanks
  3. 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...
  4. hoomantt

    Ask A Question Before Run A Macro

    Thanks a lot
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. hoomantt

    Help for draw dashboard

    Dear Hui Thanks again That was so helpful Thanks
  10. hoomantt

    Help for draw dashboard

    Dear Hui Thanks a lot for your help. I dont know what i say for thank you thanks a lot i have anothar problem. the name of my goods are long and they will go togeather and user can not undersatnd the chart. is there any way to wrap these names or rotate 90 degree ?! hanks alot
  11. 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
  12. hoomantt

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

    Please Answer my question,please!!!!
  13. hoomantt

    I Love you , Dear Excel professors

    I Love you , Dear Excel professors
  14. 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...
  15. hoomantt

    Mouseover shape

    thanks alot i have time really really thanks Narayan
  16. hoomantt

    Mouseover shape

    Dear Narayanak i live in iran and these sites are filter. i have not enough knowladge about vba can you please make it for me and share it hear?! Thank you
  17. 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...
  18. 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...
  19. 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...
  20. hoomantt

    Make Pattern Password

    dear luke m , thanks a lot thanks a lot thanks a lot Thank You...
  21. 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.
  22. hoomantt

    receive username and password

    Thanks a lot dear friends i know that knowing of passwords is not fair but one of my friend in it center of my office asked me about this he forgot personal passwords and dont want to ask from 1200 co-workers that tell him their password. his boss will punish him!!! therefore asked me about this...
  23. 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...
  24. 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...
  25. 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
Back
Top