protection

Thanks for the veiw. I have a Workbook named "Master Archive" that contain data from 9 workbooks. This is all done with a macro upon opening each workbook and using a command button to send the data to it. Question is I want everyone to be able to view the Master Archive Workbook in a readonly...

Is there any way to unprotect a sheet which I have protected and then forgotten the password ?

First of all I want to thank you guys for this forum. Helped me to many times! But now I'm pretty stuck on one problem. My workbook use protection. Special cells are locked if not empty. I use WorkSheet_Change(), when some cell is changed, every locked cell will be protected and need to...

I have a workbook with a sheet set up as the user interface to a table of raw data on a hidden sheet. The user interface sheet has buttons to perform various actions on the selected "record" and to navigate back and forth within the records. The look of the standard MSForms and ActiveX Command...

Hi, I have a user form that the users are supposed to use to enter data to a sheet. the form them inserts data into certain cells in the next available row, while leaving other cells blank for the user to enter the data directly into or the other cells in the row contain formulas. I would like...

I have a workbook with a one sheet front end that has user forms and buttons that launch VBA code, and I want the user to only be able to use these tools, not change anything else in the workbook. However, the macros and VBA do sorting and filtering, change charts etc. When I protect all sheets...

Hello! I have a sheet that contains various columns that I would like to protect or hide from the standard editing/ viewing. There are multiple user groups who access this sheet, and I finally got all the information correct in a column, so I don't want any changes to it being made. I've...

I have a workbook without any VBA code, where I want to allow the user to clear the contents of the Data sheet, but I would like to prevent them from Deleting cell (right-click delete) which will break my dynamic formulas pointing to the range where new data will be pasted. If the user presses...

Hello All, Background info: I am working on Excel 2010 and running Windows 7 (64 bit). I have a worksheet that contains a macro to create data validation combo boxes (which is pretty neat since it gives the users the autofill function). I did not write this macro, but rather obtained it...

Is there some code to protect and unprotect a sheet were it will lock all the cells? I currently have this. ActiveSheet.Unprotect ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Hi, I'm trying to enable outlining in VBA so I can group rows together, but also have the sheet protected so functions are proctected from deletion. The kicker is that the sheet also needs to be a "shared workbook", which inhibits protecting the sheet. I have the code below that works until...

I have a sheet that I have password protected and I really want to keep it this way but it won't let anyone hide or unhide rows or columns. It completely freezes up for a couple minutes if you try. This only happens in excel 2010; it doesn't happen if someone opens in 2003. I found keyboard...

I have a 2003 worksheet that is protected by a password which also protects the VBA code associated with the workbook. This is to prevent users modifying the macro's and code logic. However, I know this is not the most secure form of protection. Is there a better way?

I am trying to loosely "secure" a workbook and I feel like there ought to be a better way. I have a main interaction tab (let's call it sheet Main) where end-users make selections on various drop-downs. However, the drop-down selection/changes drive VBA code that manipulate other sheets...

Hello you wise VBA sages! I have a little piece of VBA that runs on select files to lock it down in order to keep users from entering data or altering formatting. It works great! (Thank you!) I've noticed, though, that is also locks any other files you may already have open. It has a...

Hello I am trying to unlock a certain range of cells based on a value in another cell and then protect the sheet for the locked cells. After I run the macro everything in my loop becomes unlocked rather than just the specified range. Any suggestions will be appreciated. Thank you, Jared Dim...