password protection - Programmatically unprotect MS Excel VBA project in Windows 8 -
i'm having trouble unprotecting workbook's vba project via code. sendkeys
method used work pretty well, in windows 8 64-bit doesn't work anymore. reason? know different method environment?
i had same issue module password. , know sounds little twisted way work out how unprotect module locally store copy of module unprotected, use code remove exiting module , export in unprotected version, make changes required using vba vise verse again. utilizing export , import function on module. you'll need store protected , unprotected versions locally in separate folders.
hope helps!
Comments
Post a Comment