VBA Project Password Dialogue Box Shown after Closing Excel when Acrobat PDFMaker COM Addin is Enabl

vba project password dialogue box shown after closing excel when acrobat pdfmaker com addin enabled

 

i have developed many applications last 20 years in different environments (asp, sql, vba, vb, etc) . have had reports bug believe derives com add-in called “acrobat pdfmaker office com addin” (pdfmaker.officeaddin) developed adobe.

 

the application generates problem built in excel. has custom userform listbox in it. position of listbox different depending on number of parameters , programmatically changed. however, whenever userform has been shown , user closing file vba project password dialogue box pops up. password pop-up has cancelled 2-5 times before disappears.

 

the problem of course annoying , difficult explain clients have paid me solution. have spent lot time trying resolve problem, little success.

 

recently read in forum caused acrobat pdfmaker com addin. not believe this, when disabled add-in works fine. also, in machines not have add-in installed there no problems reported.

http://www.excelguru.ca/forums/showthread.php?1009-quot-vba-project-password-quot-window-o pens-after-closing-the-excel-workbook

 

how reproduce bug (5mins) (courtesy randall):

to reproduce bug can simple create new macroenabled workbook, 1) add userform close button, 2) protect vbproject code (this critical), 3) add code load or .show userform in wb open or activate procedure, 4) add userform property changing code (e.g. .top=, .left=, .caption=) in userform init procedure (this critical), 5) save & close workbook. 6) relaunch workbook ensuring userform opens , close via button provided on userform. 7) exit wb via menu option file-exit (this critical). wait it, wait (about 5 secs) :-) vbproject password prompt appear, repeatable.

 

as workaround have tried disable add-in on start-up line application.comaddins("pdfmaker.officeaddin").connect = false

will throw error “this add-in installed users on computer , can connected or disconnected administrator.”

 

i have read in forum problem occurs if activex dll not release reference workbook contains password-protected vba project (http://support.microsoft.com/kb/280454)

 

any resolve problem or find workaround appreciated.

 

niklas

hi niklas,

 

the above mentioned issue logged bug , has been fixed in acrobat 11.0.1 update.

More discussions in Acrobat SDK

adobe