password

Hi everyone :), Is it possible to save my workbook on to the organizations network so that anyone may access it for viewing purposes only? But i want to be the only one who can go in and make changes. All help is greatly appreciated, I am going into excel right now with very little to no...

I have a workbook that will sit in a folder that anyone in the company can access and which needs to be modified by supervisors, let's call it ProductionWB. Management is able to pull a report from our timecard system that has everyone's raw data in it, let's call it TimecardWB. I need to have...

I have a hard coded password in my macro, but I don't want it to be visible if someone chooses to go look at my code. Is there a way to have it hard coded and hidden from view?

Hi all, I Have recently written this piece of code so I just thought I would post it here for future reference should anyone be looking for vba code to lock\unlock a vbaproject programmatically without needing to use the unreliable SendKeys method. workbook example This code requires that the...

I enjoy writing Code for Excel files. Is there any way I can ever sell an Excel file and protect it so that it can't just be copied and distributed freely to anyone who wants it?

I have a piece of VBA code that opens a workbook that is password encrypted, but could be one of three different passwords: Workbooks.Open Filename:="\\Drive1\Folder1\test.xlsx", Password:="Test1" Workbooks.Open Filename:="\\Drive1\Folder1\test.xlsx", Password:="Test2" Workbooks.Open...

Hi Experts, I have a number of workbooks (20+) that are being used by multiple users, and the code is password protected in order to hide sensitive information. Currently, I'm working on implementing a UserForm, that will be the same for all workbooks. The form is be imported on open, and that...

I have the below code, which I will use to open a file. I will then gather data about the file and report back in a master workbook. My issue comes when I am trying to open a file which has a password: The first Workbooks.Open method presents me with a pop-up window, which I expect, although I...

Morning. I have some zipped files that I need to keep for future reference. I wish to keep them in a folder on my pc & this is for my web site. I don’t wish to use google drive etc. Can the folder be password protected ?

I have 10 excel files that contain a table with many columns and many rows and that need to be updated frequently with new data. In order to have a faster record of some data from these files, I created a separate excel file that centralizes them all 10 files by external pivot table data and...

i kept getting this message whenever i try to unprotect one of the sheets i was working in excel today. it said this "the password you supplied is not correct. verify that the caps lock key is off and be sure to use the correct capitalization"....but the password i encrypted on are NUMBERS! does...

Hello again - I have several individual password protected workbooks - one for each employee, each with a unique password - that collect that employees timekeeping data. I'm trying to make a master sheet that will pull data from each of these individual files into one master file for me (the...

Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...

My old computer had a macro, I unsuccessfully tried to re-create it on my new computer. My Excel worksheets are protected with a long password, I want to unprotect it with a simple macro that contains the password. When I record the macro, it doesn't capture the password. What am I doing...

Hi all, I have a file that my users are not permitted to save, but I want my staff to be able to modify and save. I have an old macro from mikerikson which works if my team or I wants to save this master file and enters the appropriate password, thus: Private Sub Workbook_BeforeSave(ByVal...

Hi, I have created a macro that will autoprotect and sutosave a sheet when closing with a specific password. How I need to allow people who do not know the password to filter on the sheet. what code do I need to add to allow filtering without being able to unprotect the sheet? Code I...

Hi, I'm a bit of a novice when VBA and have tried a macro that removes a password from a locked excel sheet, does an action and locks the sheet again with the password. I seem to be unable to enable filtering and sorting, getting the error message "expected named parameter". Is anyone able to...

I want to do a macro (hopefully record macro) and need to extract data from a website that requires a password. However, my colleagues have their own login ID and password, and i do not want to share my login ID and password with them. What should I do such that i can retrieve data from the...

I know how to protect a worksheet in a macro and also protect a workbook in a macro. But I don't know if it is possible to protect a workbook in windows. Let me explain. When I open up say drive F:\... on my flashcard, I see my workbook which I will call book1.xlsm. I want to be the only...

Good Afternoon Mates! I want to make an excel sheet which will not allow the user to take print until the the latest changes are saved. Actually I have created a file which requires "password to modify". Without entering the password, one can access the file with "Read Only" mode. But, in read...