Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 30

Thread: microsoft excel has stopped working.

  1. #11
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,805
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: microsoft excel has stopped working.

    You can't attach files in this forum.
    I'd suggest looking at available options here
    https://www.mrexcel.com/forum/about-...tachments.html
    OR
    Upload your file to a sharing site, Dropbox for instance, and then post the link back here, as mentioned by @NimishK
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  2. #12
    Board Regular
    Join Date
    Sep 2019
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post Re: microsoft excel has stopped working.

    Quote Originally Posted by Michael M View Post
    You can't attach files in this forum.
    I'd suggest looking at available options here
    https://www.mrexcel.com/forum/about-...tachments.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...Scorecard.xlsm

  3. #13
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,805
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: microsoft excel has stopped working.

    There are no files on the link you have provided....I'm out of this thread !!...
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  4. #14
    Board Regular
    Join Date
    Sep 2019
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    Quote Originally Posted by Michael M View Post
    There are no files on the link you have provided....I'm out of this thread !!...
    https://www.dropbox.com/home?preview...Scorecard.xlsm

  5. #15
    Board Regular
    Join Date
    Sep 2015
    Posts
    562
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    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 by NimishK; Sep 17th, 2019 at 08:18 AM.

  6. #16
    Board Regular
    Join Date
    Sep 2019
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    Quote Originally Posted by NimishK View Post
    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/7fug39z9wg...card.xlsm?dl=0

  7. #17
    Board Regular
    Join Date
    Sep 2019
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    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 by Jefferson2512; Sep 17th, 2019 at 09:40 PM.

  8. #18
    Board Regular
    Join Date
    Sep 2015
    Posts
    562
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

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

  9. #19
    Board Regular
    Join Date
    Sep 2019
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    Quote Originally Posted by NimishK View Post
    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

  10. #20
    Board Regular
    Join Date
    Sep 2015
    Posts
    562
    Post Thanks / Like
    Mentioned
    3 Post(s)
    Tagged
    0 Thread(s)

    Default Re: microsoft excel has stopped working.

    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/off...ues-with-excel For below

    Method 3: Investigate Excel file details and contents

    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:

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

    Inspect and simplify your files if possible.
    If these steps do not resolve your issue, continue to method 4.

    NimishK
    Last edited by NimishK; Sep 18th, 2019 at 05:04 AM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •