Recent content by hoomantt

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.

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

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

Thanks a lot

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

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

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

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

Dear Hui Thanks again That was so helpful Thanks

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

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

Please Answer my question,please!!!!

I Love you , Dear Excel professors

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

thanks alot i have time really really thanks Narayan