protected sheet

I have a worksheet that has cells/formulas protected so that the data stays accurate. I left certain cells unprotected for others to access and fill in their information. The problem is that when trying to send the worksheet as the message body only by email, not an attachment, an error pops...

Hi, I have this code in my module Private Sub Boys_Click()If Boys.Value = True Then Rows("13:57").EntireRow.Hidden = True Else Rows("13:57").EntireRow.Hidden = False End If End Sub However, my problem is whenever i protect the sheet it doesnt allow me to proceed(debug mode) since i am...

How can the top row of a worksheet be protected/locked? We have a status log being accessed by multiple people who need to be able to add/delete rows. People keep putting typos in the top row however, which contains our column titles - so I want to find a way to lock that down. I have tried the...

Understand how to lock and unlock cells, how to protect and unprotect worksheets. When sheet is locked, I need to allow the user to select the generated chart, and copy it for use elsewhere. Seen other posts-- Format Chart, Properties, Unlock. But, when the sheet is unprotected, I select the...

Hi - I am using Office 2013 and have a protected sheet where I would like users to still be able to open/close groupings. I have used the code: Private Sub Worksheet_Open() With Worksheet ("Europe") .Unprotect Password:="PW12" .Protect Password:="PW12", Userinterfaceonly:=True .EnableOutlining...

Hi there, Would anyone know how to allow users to adjust a filter for a pivot table (external data source - OLAP cube) on a protected sheet? When I try to change the filter I get the following error: That command cannot be performed on a protected sheet because the source for this PivotTable...

Hi Excel Masters :-) I have done some research on line and it seems that there is a bug in excel as there is no simple way to use the group function by default when the sheet is protected (even if you tick the option outline in the pop up window). My question is : What is the workaround? I...

Hi Guys, I need a favor from you guys, I forgot my protected sheet password and now i want to make some changes can you please guys help me out to remove the protected sheet password or for any instance i can change some of the columns? Kindly help me out i am stuck. Thanks in Advance

Hi All, I am trying to decipher how to run a macro when I have protected all the worksheets on my spreadsheet. I am not an experienced VBA person so appreciate any help on this. My attempt (which is largely driven by using the 'record macro' option) is as follows: Sub Split_Shift() ' '...

I set up a worksheet for other users to calculate the tax consequences of different divorce settlements. The users enter the cells bordered in black. The cells bordered in blue return results and are the cells I want to lock (and to do this I need to protect sheet.) I want the users to be able...

Hello All Being new to the forum as well as self taught in VBA was hoping for some insight I'm trying to find a way to enable me to just VIEW object(s) inserted (below Code) in a Projected sheet, WITHOUT tamparing (deleting, changing) or editing the object. Private Sub Insert_OLE_Object()...

Hello, I created a spreadsheet that needs to allow multiple users to add, edit, delete data in ceratin cells, but not be able to change the formatting. In order to accomplish this, I unlocked the cells that can be manipulated, then protected each sheet. Now, however, the auto date macro is...

Hi, I've found a quirk of Excel 2007 which I can't seem to overcome: When a cell has: 1) a comment, and 2) data validation as a list, and 3) no "locked" status in the "protection" tab of the formatting window. And when the worksheet containing this cell is protected, and the cell is...

I have a protected sheet where users can make choices (by DataValidation) to certain cells. I want to use the "BeforeDoubleClick" event to let the users switch between the options. So if a cell holds "Option A" and "Option B", then doubleclicking would switch from "Option A" to "Option B" and...

I wrote a date/time stamp macro to auto update in a single, specified cell every time data is changed or entered in any other cell for specific worksheets in a workbook that have various other macros and functions. The code works perfectly when the sheets are NOT protected; however, it no longer...

Hello all, I am new to this forum and hoping that you will be able to help me. I am working on putting together a data correlation for a work project, and am connecting to an external SQL data source. I have created several rather large equations to work on the same sheet where the external...

I am using a drop down box which specifes different amortization frequency. That goes to another page and calculates it. It worked fine, but now I have to protect the calcuation sheet before I send it out. This creates issues as now that amortization freq. calc macro does not work. Below is my...

Hello, I have made a sheet which will be used for the information transfer about items/products from R&D to me. I will then enter all the new items and/or changes in the ERP system. To make it as easy as possible for R&D to let them fill in the needed information I have added formulas and data...

I have a sheet that is protected but does NOT have a password. The sheet contains some columns that are locked and others that are not. I would like to allow users of this sheet to insert new rows into the sheet. My problem is that I want some of the formulas that are locked to be available in...

In my old version of Excel for Mac, the enter and tab keys had the same function with the return key having a separate function. This was extremely useful for entering data into a protected spreadsheet. Each time the enter key was pressed the active cell would move to the next cell SKIPPING...