+ Reply to Thread
Results 1 to 3 of 3

This Action will Reset your Project

  1. #1
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Wink This Action will Reset your Project

    Hi to you all,

    Its been a long time! I have a Excel 2003 workbook running just fine in compatibility mode in Excel 2007 but, as soon as I save that same project as a 2007 workbook, vba goes crazy! Everytime I open the Workbook it pops me 3 messages that "This action will reset your Project" Continue Anyway. Why does this happen in 2007 and not with 2003. Why cant VBA stop on the "error" or whatever or wherever it encounters the problem?

    I find it funny that 2007 handles it flawlessly in compatibility mode, just as 2003 would, but oh boy!, don't you dare and save it as a 2007.

    Would any of you experts have an answer fro me, Please?

    Thank you!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,457

    Re: This Action will Reset your Project

    I'm guessing, from the lack of response, that the "experts" are feeling there may be some information missing in your OP.

    I would suggest that you upload the 2003 version of the workbook, or a sample with some typical data, and the 2007 version of the workbook (same rules) so that a comparison can be made and the question investigated.


    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: This Action will Reset your Project

    In 2007, in the VBE, Tools > Options > General tab, untick Notify Before State Loss
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1