Search results

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

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

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

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

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

dear luke m , thanks a lot thanks a lot thanks a lot Thank You...

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.

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

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

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

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