password protect

Hi All, I have a spreadsheet that I need to split out a each unit and then password protect it. my spreadsheet will contain formatting and protected areas. I need to Retain all functionality in the split out files as well as update a master cell with the budget for that unit. I have some...

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 everybody, I am currently managing an order form in Excel, where people download it and then they go in every day, fill out the details and submit the order through a macro. They will just need to download it once and then do this whenever they have an order. However, is there any way in...

To start, I have no idea how to write or run macros. I know that I want to have 37 of the 39 sheets in a file I made to be VeryHidden so they are as protected as possible when the workbook is opened, with a prompt to enter a password to reveal the sheets. I've seen macros that I guess have...

Hi All, I use some code which I found here to unhide and unhide tabs which also requires a password, however I was wondering is there any way that when I enter the password it just shows up as ********** as it would in normal scenarios where you have a password as the below allows the letters...

Hi all I'm having a problem, and after many hours searching for a solution, i desidet to ask in here. What im looking for is a macro which does: When i close my workbook it should password protect some specific sheets, the workbook structure and then hide some of the sheets. I simply can't...

I am working on a spreadsheet of a staff schedule and I want to add macros so that each staff can only see their shifts and have a RESET button to see the entire schedule. However, I do not want all the staff to see all the schedule. Is is possible to put a password on the RESET button so that...

Hi! I have a cell (J2) and I only want people with a password to be able to unhide and edit this cell. I can't seem to figure out a way without having to "protect", "unprotect" (to make edits) and "re-protect" again. Does anyone have any recommendations or advice on how to best achieve this...

Hi, I have looked into this for quite sometime but I haven't been able to get anything to work. Can someone help me please? I currently have a check box which when ticked, returns the date in the same cell (Q7). However, I want to restrict who can check/uncheck this box with a password...

Hi! I want to know if it is possible to password protect a pdf after converting from Excel based on the output of a cell. For example, cell B3 (with formula) is equal to Bar732, this value would be the password of the converted pdf. Right now i have the code below: Sub PDFActiveSheet()...

Hey there, I'm hoping for some help with my VBA code in Excel 2016. First, I know that this is not fool-proof security, but that's fine for what I'm working with. I have an excel workbook, with many hidden sheets (one for each employee), and a menu tab with buttons linking to each sheet. I have...

Hi, I have a workbook that acts as a sort of questionaire. Each day, employees fill in the data for the day (batch numbers, dates, times of work, ect) Most cells are locked and protected apart from the answer cells. This is all on 3 sheets (all protected). I want to run a macro that can be...

Hi, I Need help in to protecting sheets in multiple workbooks in a particular folder. With a particular password 1st i would like to protect sheets from editing in multiple work books in a folder. I also need to provide a different password to open that work book. It's like with a password...

Hi all, I'm new to the forum although have been helped by it on many occasions. I have come across a problem while trying to use VBA to protect my worksheet and was wondering if anyone else has had a similar issue. Essentially I am adding two levels of protection; one level for the end user of...

Hi all! I have a question regarding Macros. I have a spreadsheet that I am working on for work and want to insert a button, "Lock" and another, "Unlock" When pressing the Lock button, I want for the entire spreadsheet to be protected. When pressing the Unlock button, I want for a window to...

Good afternoon All, My first post to MrExcel B) I want a macro that password protects all sheets in the workbook called 'Potato' when the workbook is closed. For some reason it doesn't work and I can't figure our why :s Can anyone help me? This is what I've written: Option Explicit Sub...

Hello, I have about over 200 xls files and was asked to protect all the worksheets with password from being able to edit and print. Is there a macro available to protect them by batch? In need of help. Thank You.

Hi All . I previously used the following macro to put a password on all excel files within the specified network directory. Now that I have moved over to excel 2010 this macro no longer works on either xls or xlsm files. Any help would be appreciated. I previously use the following macro to...

Hi All I allway write all my code in lowercase, so that when it capitalises I know I have spelt it correctly. However I have been looking for a better way to protect my workbook to avoid the endless looping. And found the UserInterfaceOnly property which seems to state it will allow VBA even...

Folks, I have a spreadsheet with lots of parts and quantities that I'd like to discuss with two different parties (A and B), however I have two different pricing with both parties. I'd like to be able to chat with both of them at the same time to work toward the right quantities, but I'd...