Results 1 to 32 of 32

Ever annoying VBA password prompt at close of excel.

Threaded View

  1. #1
    Registered User
    Join Date
    06-17-2009
    Location
    Canada
    MS-Off Ver
    Office 2010
    Posts
    84

    Ever annoying VBA password prompt at close of excel.

    As many users have listed on the Internet. I am also getting the pop-up asking for VBA password when closing excel.

    I have my code deployed on approximately 50 laptops. Various manufacturers of laptops and versions of Windows ranging from Windows XP to Windows 10. All running Office 2010 or 2013. Only 4 machines have the popup error. I thought the problem was related to the last Microsoft update but does not appear to be the case. Has anyone come up with a solution or is it just trial an error? Seems to be related to forms. I can open a file have it load a file and then auto open a form, close it and save the file and the error will appear. Very repeatable on 4 machines but not on any other.

    The following are a couple well written links relating to problem
    http://www.excelforum.com/excel-prog...to-appear.html

    http://www.mrexcel.com/forum/excel-q...ing-excel.html

    Below is what I have for add-ins. They are all inactive or do they need to be totally removed from computer?
    Add-Ins.jpg

    Anyone with ideas?

    I have attached sample file. Password for VBA is test
    Very repeatable error on my computer. Open the file it auto opens a splash screen and then checks to see if pivot-table is loaded or not and then selects Order tab.
    Then click X and then when requested save document.
    Attached Files Attached Files
    Last edited by Epscan; 08-25-2015 at 04:35 PM. Reason: Added sample file

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Prompt to close PDF so file can be overwrtitten or close automatically
    By bdouglas1011 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-21-2014, 12:31 PM
  2. How to close annoying popup windows with Excel macro?
    By KB7 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2012, 10:35 AM
  3. vba-password prompt on close
    By kikde in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2005, 09:40 AM
  4. How Close Excel from CMD prompt?
    By Al Franz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-20-2005, 04:14 PM
  5. Getting Rid of Annoying Prompt
    By Chaplain Doug in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-17-2005, 04:06 PM
  6. PLEASE HELP - Annoying beep noise when I close Excel
    By korinyoshida in forum Excel General
    Replies: 0
    Last Post: 02-21-2005, 04:49 PM
  7. [SOLVED] Re: Annoying prompt: ActiveX and app initialization
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2005, 10:06 PM

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