microsoft excel has stopped working.

Jefferson2512

Board Regular
Joined
Sep 16, 2019
Messages
53


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

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
There are no files on the link you have provided....I'm out of this thread !!...:oops:
 
Upvote 0
Yes File does not exist. Be patient

you need to upload the file at dropbox as suggested previously

after uploading click on share and dont click the dropdown after share
then go below
click on Create link
Options of share link instead click on copy link Just copy by ctrl+C
and paste it on your MrExcel post

HTH
NimishK 555
 
Last edited:
Upvote 0
Upvote 0
my problem with my system is that when i open the VBE and click run it goes well but when i closed the excel and try to reopened the excel again it went error when i clicked the assigned macro .. help me man pls

i think the main problem is my Userform_initialize in VBE because im using call and i think arranged it bad ..
 
Last edited:
Upvote 0
Hi I've checked and it runs smoothly. indeed a beautiful Template with good color combinations
Am using Excel-2013 as asked you which version r u suing.

The file which you have uploaded contains No Data in except all the sheets with Headers Rows 1 2 and 3 as required

I opened your template by clicking on Scorecard Audit Team UF was loaded and showed perfectly. Also with VBE Run on userform too it worked perfectly
When closed it asked me whether to Save so i did not save. But When closing it took few seconds more with proper closure.

Also userform Terminate you have put Rem Marks for not executing

I tried the below only thing it did not ask for saving options
Code:
'Private Sub UserForm_Terminate()

'ThisWorkbook.Save
'ActiveWorkbook.Close SaveChanges:=False

'End Sub

Is this the same file which you have uploaded and got Error or you have removed the Data and sent the file.
Because it is running smoothly here.

https://docs.microsoft.com/en-us/office/troubleshoot/excel/crashing-issues-with-excel For below

[h=3]Method 3: Investigate Excel file details and contents[/h][FONT=&quot]Excel files can exist on the computer for a long time. They are upgraded from version to version and frequently travel from one user to another user. Frequently, a user inherits an Excel file but doesn't know what is included in the file. The following areas can cause performance or crashing issues:[/FONT]

  • Formulas referencing entire columns.
  • Array formulas referencing an uneven number of elements in the arguments.
  • Hundreds, or perhaps thousands, of hidden or size 0 height and width objects.
  • Too many styles caused by frequent copying and pasting between workbooks.
  • Too many (as well as invalidly defined) names.
[FONT=&quot]Inspect and simplify your files if possible.[/FONT]
[FONT=&quot]If these steps do not resolve your issue, continue to method 4.[/FONT]


NimishK
 
Last edited:
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,315
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top