Recent content by Sushil

Thanks! Hui. That is exactly what I was looking for. Thanks again for your help.

Hi, I am trying to plot a combo graph for data that includes division name, cost of quality in dollars and scrap as% of sales for yr 2013 to 2017. for example , lets say division name is Apple, Mango, Pineapple,grape, pear. I want to show cost of quality for each division for yr 2013 to...

Hi Narayan, the code is the same as you loaded on Oct 9th and it has the same problems. Thanks Sushil

Hi Narayan, did you get a chance to look into it. Thanks Sushil

Hi Narayan, user updates the values in column A to E and the results are sumarised in Pivot table. users are not familar with pivotables hence i want pivot table to be refreshed on its own before work book is closed . This file is emailed after it is updated and whosoever...

Hi Narayan, Thanks for spending so much time on this problem. the thing i want to do with this macro is.... when the user opens the file .....all the sheets except the sheet named Macros should be hidden . "Macros" sheet should be open showing the arrow to the user that the...

Hi Narayan, it is the same .. when i first open the file from the website it takes me to the "MACROS" tab and force me to enable the macros. But when i do save as to my computer, it gives me run time error and shows "Call Sheet1.Update" in yellow color. when i says end...

Hi Narayan/ Jeff sorry .. it is not working in both the cases. Jeff, if i try "save as" with your file it gives me an run time error. Narayan, i want that when user open the file, MACROS sheet should open up only and force the user to enable Macros as explained by...

Hi Narayan, i tried taking out the line Close savechanges:=False. it does not crash but then next time i open the file , MACROS tab does not open up automatically and ask user to enable the macros. this file is to be used reapeatedly every week and has to show same message...

Help Please!!! ..SOS...2

Hi Lohith, in regards to macros , i am in junior kindergarten. i just got few macros from internet doing google and combined them to suit my needs. iam not trying to force close the workbook with the line of code .Close savechanges:=False . it was in the macro which i...

Hi Narayan, it still crashes and also now it doesnt hide all the sheets except" Macros" sheet when the file is opened. Thanks Sushil

can I have the solution please... Thanks Sushil

sorry, i am lost here....

Hi Narayan Thanks for your reply. the file still crashes . did you make the changes in the attached file. i did not see " Application.EnableEvents = True, .Close (False). in the code . Maybe i am looking at wrong place i am not too sure but the file still crashes