+ Reply to Thread
Results 1 to 3 of 3

Help me please !!!!! file closing as soon as it opens due to wrong coading

  1. #1
    Registered User
    Join Date
    11-05-2012
    Location
    Pune
    MS-Off Ver
    Excel 2007
    Posts
    5

    Help me please !!!!! file closing as soon as it opens due to wrong coading

    I have created a project with many linked Userforms & sheets.
    After completion I thought that " As soon as application starts 1st userform should be visible so i created the module like that . Then I thought as soon as userform opens worksheet should close & user should see User form only.
    For that, in Userform _initialized function by mistake I inserted application.workbook.close.

    Now"BIG" problem is that as soon as I open the workbook it closes immediately.
    I am not able to assess Developer tab to make any changes.

    This file has become open-shut file...!!!!!!!!!!!

    (I tried to recover the earlier version of the file but I could not get as it is overwritten)

    Please help me in above issue..!!!!

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Help me please !!!!! file closing as soon as it opens due to wrong coading

    sabhay,

    Open a new Excel file and change your macro settings so that they don't automatically run. Then open the file that you need to alter.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    11-05-2012
    Location
    Pune
    MS-Off Ver
    Excel 2007
    Posts
    5

    [SOLVED ] Help me please !!!!! file closing as soon as it opens due to wrong coading

    Problem Solved Thanks !!!!!!

+ 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