microsoft excel has stopped working.

[Jefferson2512]

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

 

[Michael M]

You can't attach files in this forum.
I'd suggest looking at available options here
https://www.mrexcel.com/forum/about-board/508133-attachments.html
OR
Upload your file to a sharing site, Dropbox for instance, and then post the link back here, as mentioned by @NimishK

 

[Jefferson2512]

You can't attach files in this forum.
I'd suggest looking at available options here
https://www.mrexcel.com/forum/about-board/508133-attachments.html
OR
Upload your file to a sharing site, Dropbox for instance, and then post the link back here, as mentioned by @NimishK

here it is man ..
https://www.dropbox.com/home?preview=Audit+Team+Performance++Scorecard.xlsm

 

[Michael M]

There are no files on the link you have provided....I'm out of this thread !!...

 

[Jefferson2512]

There are no files on the link you have provided....I'm out of this thread !!...

https://www.dropbox.com/home?preview=Audit+Team+Performance++Scorecard.xlsm

 

[NimishK]

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

 

[Jefferson2512]

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

here it is man .. canyou help me pls
https://www.dropbox.com/s/7fug39z9wg7q6b9/Audit Team Performance Scorecard.xlsm?dl=0

 

[Jefferson2512]

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

 

[NimishK]

Will revert back. Please be patient. Something urgently has croped up.

 

[Jefferson2512]

Will revert back. Please be patient. Something urgently has croped up.

okay .. i'm waiting for your help sir hope you come back .. i really need your help

 

[NimishK]

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

'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