password protected

Hi, I have a spreadsheet we are using for certification by a supervisor. I would like to setup the sheet such that the 'sign off' cells in column (E:E) is password protected. When the supervisor clicks on the 'sign off' cell for a specific project, and changes it to 'Yes'. A prompt box appears...

Hello, I have a data analysis project to roll up multiple individual, macro-enabled Excel workbooks with tables and formulas. Each workbook contains 31 individual sheets (one for each day of the month). The 31 individual day worksheets each contain nested Excel tables with formulas and are...

Hi All, I will be having around 85-90 password protected workbooks. They all will have different passwords. I shall collate them in 1 folder. I will have a list of the workbooks name and their passwords (preferably in sheet2). I need a macro or code which will open the workbook with the...

Hi Guys, I have an excel speradsheet with 22 coulunms and about 1000 rows and growing with lots of macros in it. There is an ADD command button on the main sheet that opens up a VBA scripted table that have drop downs to select data to add to the next row with another ADD DATA button in it. This...

Hello Everyone, I wrote some code to protect/unprotect all of the worksheets in my workbook, and when I run the code in the vba editor it works perfectly fine. However, I added some shapes to my excel file and then assign the macros to those shapes, so the macro could be run at the click of a...

Hi Guys, I'm using below codes to remove password and save excel files without password. Can you help me modify the codes so I can use this for word files? =================== Sub RemovePassword() Dim xlBook As Workbook Dim strFilename As String Const fPath As String = "C:\My Folder"...

Hi Guys, I'm trying to open and save the files without password using below codes. However after running the codes, I tried opening one file and the password is still there. Is there any way to: 1) After inputting the password, save the files without password 2) Can you help me modify below...

I am working with a password protected sheet that has hidden columns. I used to be able to select all (Ctrl + A) and then copy a whole sheet, then go to a blank sheet & paste and then be able to see all the columns, including the hidden ones. Recently I found that I'm not able to do that...

Dear group members, I am trying to write a VBA code for opening password protected multiple PDF files (password known to me) one by one and copy the data in excel. I am not able to do so. I tried to google out. I have the code from which you can open the normal pdf file. Can you please share...

I am trying to use a macro to consolidate data from protected workbooks. Note: It appears PowerQuery doesn't like password-protected files. Below is the vba I have used to open unprotected files in the past. How do I modify the script to provide the required password. [CODE]Workbooks.Open...

Hi everyone, I have userform and transferring some data to closed excel files. This data collecting in MS Access mdb database and I want to protect this. I found a string from the net and I connect unprotected my mdb file successful. These codes are below but I don't know how can I connect my...

Morning All, I am using Excel 2010 which I am experiencing a small problem with. I have a spreadsheet which is password protected, this spreadsheet contains a large number of formulae lifting data from another spreadsheet. When I make a selection from cell O2 I would like rows X5:Y11 to...

I need to copy data from a username/password protected "homegrown" database (that can be a little slow) and paste it into an Access Table. I wrote a macro in our "homegrown" database that I linked to `. I'm able to do the following in Access: Sub AutoExec() AppActivate "Session 1" delay...

Hi all! I have access to a website that contains data on companies with a download to excel option. You search an id number or the company name in the site and then you can choose the data points you want and export to excel. Now I have 10s of thousands of these id numbers and am looking to...

I have a working program but want to add a password to the external file I'm using to update my active spreadsheet file. I do not want to be prompted for the password when I initiate the "update" command from within code. I would like to automatically pass the password through scripting. Here is...

My company has an Excel workbook with a "Menu" worksheet with linked buttons to individual password protected worksheets for varying individuals. Management wants to be able to open this file without having to type in the 15 some odd individual passwords each time. I've been tasked with figuring...

I'm using VBA to pull a large amount of data from a closed workbook that's password protected. While the code that I've put in works smoothly, there are 2 annoying issues that remain that I'd like to get rid of, which I suspect may be related. 1) I have to enter the password twice - once when...

Hi there, I have an Excel file with a macro to unhide certain worksheets when the user clicks a button. I also have a "control table" worksheet hidden in the file that I do NOT want users to access. My dilemma is -- if I password-protect the structure of the workbook to prevent users from...

I have a macro that opens up a file of forms, makes customizations, and saves each worksheet in that file as it's own form in the new project. It works great (self pat on the back here), EXCEPT that I have users complain that they have to hit the Read-Only button. Obviously, having to wait the...

Hi All I have been trying various codes to open a selection of one Page workbooks (Graphs) from Both Access and other Workbooks. Access is being used mainly as login and navigation to reports. The below code is the best I have so far, but when opening form Access 2003 , I still get password...