pwd

Can anyone tell me why this is not working correctly? I can protect all the sheets but when I go to unprotect the sheets I get the error message? Sub protectsheets() Dim wsheet As Worksheet Dim Pwd As String Pwd = InputBox("Password:", "Protect Sheets") For Each wsheet In...

Hello! I need to open a protected book reading a BAT file, in a silent way, without messages or alerts. Perhaps including the pwd as a parameter in the command line but I couldn't find how to do it. Thanks in advance.

Hello, I should make excel vba that queries 80 databases and writes the info in excel. Is this possible and how to connect to 80 databases? Here is example with the connction to one database: Sub ConnectTOOracle() Dim cn As New ADODB.Connection Dim RS As New ADODB.Recordset Dim Cmd As New...

Hi I want users to be able to click on a worksheet and then be prompted to enter a password before they can view it. I found this on another thread but a row of code is highlighted in red and it doesn't seem to work. I get Compile Error Syntax Error. Public PvSh As String Public Pwd As...

Dear experts. Please can you help me with this macro. The below code converts the excel sheet to pdf. and then password protects the pdf. using passwords i already have in sheet1. My problem is that, i already have hundreds of pdf. letters in a folder that i need to have it password protected...