microsoft excel has stopped working.

[Jefferson2512]

It always happen when I closed the excel and open it again by clicking the assigned macro

 

[Jefferson2512]

it wont work well to me .. but i tried to open it in office 365 it work well but in my excel 2013 it goes error .. you have any idea why it happened ?

well, thank you for your help

 

[NimishK]

it wont work well to me .. but i tried to open it in office 365 it work well but in my excel 2013 it goes error .. you have any idea why it happened ?
well, thank you for your help

This is too technical because i have windows 10. Would request to check data in each sheets though i;ve recieved as is without data

A suggestion to export all modules, ,userform and import them separetly and save the project in different name.
sheets to be copied in new file
I've done this many times and achieved without error XL has stopped working

 

[Jefferson2512]

This is too technical because i have windows 10. Would request to check data in each sheets though i;ve recieved as is without data

A suggestion to export all modules and import them separetly and save the project in different name. I've don this many times

okay. thanks to you man .. more powers and a good health ..

 

[NimishK]

Let me know if you have succeeded. Wish you Good Luck. Also request you to check threads on this forum with same subject. am sure you will have some idea

 

[Jefferson2512]

This is too technical because i have windows 10. Would request to check data in each sheets though i;ve recieved as is without data

A suggestion to export all modules, ,userform and import them separetly and save the project in different name.
sheets to be copied in new file
I've done this many times and achieved without error XL has stopped working

man can you open my file again and click the saved button when you close it.. and open it again then the error will come

 

[NimishK]

I clicked on Saved button when closing it. Closed it smooth and Reopened it without any errors

 

[Jefferson2512]

I clicked on Saved button when closing it. Closed it smooth and Reopened it without any errors

when you reopened it and clicked the assigned macro . did your excel crashed ?

because when i reopened the excel and click the assigned macro it will make my excel crashed

 

[NimishK]

No Crash Dear everything ran smoothly. More than 10 times i executed as per your instructions
As this is technical having different versions of Excel and Windows . It runs smoothly at my end and you face crash.

Would suggest to work as per my post #22

 

[NimishK]

One observations i made

Dim wks As Worksheet
 Set wks = Sheet9

[COLOR=#ff0000][I][B]you need to change and incorporate everywhere with below two statements respectively with sheet names in your sub routines datas, awp etc.
[/B][/I][/COLOR]Dim wks As Worksheet
 Set wks = Worksheets("Sheet9")

 

[Jefferson2512]

One observations i made

Dim wks As Worksheet
 Set wks = Sheet9

[COLOR=#ff0000][I][B]you need to change and incorporate everywhere with below two statements respectively with sheet names in your sub routines datas, awp etc.
[/B][/I][/COLOR]Dim wks As Worksheet
 Set wks = Worksheets("Sheet9")

okay man ill do what you've said