I am trying to unlock a password protected excel sheet programatically, by providing the password in code, using code found here
I am successfully able to unlock the excel file, but I do not want the user to see any windows. I tried setting this setting: xlAp.Visible = False But I still see the Project Properties window. I am new to VBA programming. Can any one tell me how to hide all the windows in this process?
Also posted herePlease Login or Register to view this content.
Bookmarks