Prevent Spreadsheet From Opening When Being Updated

    Hi


    I currently have a spreadsheet that my deparment use at work. Its just a full time equivallent sheet, nothing fancy. However I added code onto it to prevent users opening it as I was updating it.


    However I went to open it and It wouldnt open. It wouldn't recognise me as being the exception. Its just a code on the workbook open that says if user is "slb090" (which is me) then do nothing, else msgbox and just a quickie sayign come back later".


    I have attached the spreadsheet, in the hope someone can open this for me and remove the message so I can open it!


    Thanks very much in advance


    :redface: :redface:
    jamie


    JUST REALISED FILE IS TOO BIG (ZIPPED) SO CANT UPLOAD IT! ANY IDEAS??

    Re: Prevent Spreadsheet From Opening When Being Updated


    Quote from jamierodgers

    JUST REALISED FILE IS TOO BIG (ZIPPED) SO CANT UPLOAD IT! ANY IDEAS??


    Take out all irrelevant things, like formatting, charts, long rows of data, many formulas, ...

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

    Re: Prevent Spreadsheet From Opening When Being Updated


    Hi


    Can't you just choose to Disable the macros on opening so that you can amend/delete the code? If you don't have that option then maybe you need to change your security settings via Tools>Macro>Security.


    Richard

    Re: Prevent Spreadsheet From Opening When Being Updated


    Once you got into the file... would password protection for write access do what you need to do? People without the password would open in read only mode.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login