password protected

Hi, Is it possible to have an Excel file which will list Folders and Excel files within those folders and have VBA assign passwords to those files? Folder C:\Data\Test File Name Test.xlsx "Password" Test1.xlsx "Password1" Folder C:\Data\Test1 File Name Test.xlsx "Password" Test1.xlsx...

Hi, I have a workbook where each individual worksheet is password protected. Many of the codes involved are hiding row and columns and I want the code to be able to run, but I don't want the individual to be able to unhide columns/rows without the password. Is there a way to do this.

Hi guys, So my workbook is protected. I need a macro which prompts a InputBox saying "Please Enter Password." If the password is incorrect, it says, "Incorrect password. Please try again." and loops to the first input box. However... if they hit cancel, I want it to shut off the document...

Hi all, I have a looping code to open workbooks and copy then paste data to another workbook. Each workbook I open has a password. They are all the same password, how do I get it to enter automatically? Here is my code so far Sub OpenAndClearContentsInColumnAA() Dim strF As String...

Hi All, I have an application on MsAccess2003, generate all sort of reports on Excel I've got one of the code to change the excel file to read only using the following code its working file Case "XLS" bEvent = CreateXLSReport(RunningTask) If...

Windows XP Excel 2010 I have eight password protected, multi-tabbed, Excel 2010 worksheets which I would like to automatically refresh each morning before I come into work. How can I go about completing this? I am a beginner with VBA. Thanks in advance for the help!