Excel 2003 :: Unprotected Cell Won't Allow Input On Protected Sheet

May 19, 2010

Using excel 2003, Workbook has several sheets, all sheets are protected workbook is not. I have my cells containing formulas locked, I have unlocked the other cells that require input of various data. When the user goes to type in a "unlocked" cell, (to over write the now obsolete data) it will not allow the user to delete the data, the curser remains a cross and the formula bar or the cell itself will now allow any changes.

I have double checked that the cells are unlocked. I can enter data after the last entry in the unlocked row and or column, but I want to be able to "cut or delete the data that is no longer need and begin entering data from the beginning cell of choice. I want to copy this "old" data to an archive sheet, but it will now allow me to select it.

Example: I have 6 columns starting, (a to f) the formulas are in columns e and f and start at row 4 These columns are locked and hidden. Columns a,b,c and d are unlocked for user input. All data is started from A5 which I want it to start from each time the old data is deleted and new data entered. If I place my curser on any of the cells in the e and f rows, the cursor remains a cross which is what I expect it to do, but columns a to d are doing the same thing, they are acting as if they are locked OR atleast those cells in the a to d areas which have existing data, as I can enter below.

View 7 Replies


ADVERTISEMENT

Excel 2003 :: VBA Macro - How To Prevent Cell Border Changes To Unprotected Cells

Aug 3, 2012

I have unprotected cells in excel where I need to change the content (number) and cell color, but I don't want the cell borders to change. I'm a beginner with vba. I've tried protect sheet and workbook options, but looks like I need a vba code and don't know where to start.

Win 7
Office 2007

View 4 Replies View Related

Protected Sheet And UnProtected Cells

Feb 24, 2009

Excel 2007 or 2003 Is there code to be able choose the formating of a cell when right clicked if the cell is Unprotected. But, the sheet is Protect and the Workbook is Protected. Without Unprotecting anything 1st.

The reason being is sometimes the user may need to change the type of font from Arial, or Gdt or Y14.5M.

View 9 Replies View Related

Excel 2003 :: Error When Pasting To Protected Sheet?

Feb 7, 2013

Excel 2003
Windows Vista

I keep getting this error: (at the line highlighted in green)

Runtime error '1004'
PasteSpecial method of range class failed
**** Open workbooks to transfer temporary data

[Code]....

View 2 Replies View Related

Automatically Update A Protected Cell Based On Contents Of An Unprotected Cell

Apr 30, 2009

I am trying to find some VBA that will allow protected cells to be updated when a user enters or selects data in other cells.

For example:

Cell 'A1' starts out blank.
Cell 'B1' has a drop down to select specific items.
Cell 'C1' is the date of the order and is a locked cell.
Cell 'D1' is the date of completion and is a locked cell.
The worksheet is protected to prevent direct changes to cells C1 and D1.

If a user enters any information in A1, then C1 displays the current date.
If a user selects 'Complete' from the drop-down list in B1, then D1 displays the current date. Both of these actions are independant of one another. This format is the same for every cell in the 4 columns indicated above. I thought I was able to do this in another spreadsheet I created a year or so ago but I have not been able to figure out what I did and I do not have the spreadsheet to look at.

View 5 Replies View Related

VBA Macro To Auto Change Cell Color On Protected Sheet Based On Input

Apr 13, 2009

I have a macro code for conditional formatting. The first 2 lines of the macro are


Private Sub Worksheet_Change(ByVal Target As Range) ....

View 9 Replies View Related

Highlighting Protected/Unprotected Cells

Jan 28, 2008

The Special GoTo function doesn't have a listing for highlighting (going to) only protected or (preferribly) unprotected cells. Is there an easy way to do this?

View 9 Replies View Related

Timestamp Macro When File Has Been Unprotected / Protected?

Mar 6, 2012

I have a file used by numerous facilties. I would like code to track any time a protected sheet has been unprotected / protected. I would also like the stamp to show the user data if that can be done.

View 2 Replies View Related

Adjust Column Width Of Protected Worksheet Without Unprotected It?

Apr 9, 2014

Is it possible to adjust column width of a PW protected worksheet without unprotecting it, or unprotect it and adjust in background then PW protect it?

On sheet1 H1 = column width value
Will adjust Sheet2 (password protected) column E width

View 9 Replies View Related

Excel 2003 :: Runtime Error On VBA Protected Code

Apr 24, 2012

Why am I getting a runtime error on the following code:

Code:
If Target.Address = "$E$5" And Target.Value "" Then
Range("E5:G5").Copy
If Sheets("Sheet5").Range("F5").Value = "" Then
Sheets("Sheet5").Range("F5").PasteSpecial xlPasteValues
Else
Sheets("Sheet5").Cells(Rows.Count, "F").End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
End If
End If

When I select only one cell it's ok but when I select multiple cell to delete it sends me a run-time error '13'.

Excel 2003, sheet is protected.

View 2 Replies View Related

Excel 2003 :: Conditional Format - Highlight Cell In Sheet 2 If Duplicated From Sheet 1

Mar 25, 2014

I have two Sheets, first is Service Data, the second is Log Sheet. In the Service Data sheet I have a column of serial numbers in column A. I also have a column of serial numbers in the Log Sheet, column A.

I'm looking for a conditional format whereas I enter numbers into column A on the Log sheet it will auto highlight the cell if I duplicate a serial number from row A in the Service Data sheet. I would like it to highlight the Duplicated number on the Log sheet. I know new versions of excel make it easier to do this but unfortunately I have Excel 2003.

View 3 Replies View Related

Excel 2003 :: Finding First Empty Cell In The Sheet?

Nov 8, 2011

I have two work sheets where I have data.

Sheet1 contain daily input table which as follows:
Name salaryBonusXX10002XY9001YY11002ZY15003ZZ12502AA10502AZ9501

Sheet2 have table where all the information is saved. So we can say this is database of sheet1. Which store every day information of sheet 1.

SALARY DATABASEMonth Name Salary Bonus

Problem:

I want that when I finished writing on the sheet 1(which i do manually) then with macro it go the sheet 2 and find first empty cell in the name column and past the all the data of sheet1 table. Months I will put manually. I am working on MS2003.

View 9 Replies View Related

Excel 2003 :: Protect Textbox From Formatting But Not Input?

Mar 15, 2013

Is it possible to protect an inserted text box from being moved, stretched, etc. while allowing data input into the cell/s? I'm using a 2003 version of excel.

I've attached the sheet in question. The yellow text boxes are what I want to lock, yet still allow data input.

excel tip example.xls‎

View 2 Replies View Related

Excel 2003 :: How To Pass A Parameter In The Input Range

Mar 21, 2014

I have a combobox in a excell sheet. It is possible to pass a parameter in the input range instead of Parm!$B$1:$B$10

View 2 Replies View Related

Excel 2007 :: Can't Edit Cell - Unprotected Button On Changes Group Tab Grayed Out?

Jul 28, 2014

I'm trying to change a cell in a 2007 workbook but I'm getting this message:

"the cell or chart that you are trying to change is protected and therefore read only. To modify a protected cell or chart first remove the protection using the unprotect sheet command (review tab, changes group) you may be prompted for a password."

However, the unprotect button on the changes group tab is greyed out (the protect button is available though). The workbook isn't password protected and I'm not being asked for a password. What am I missing?

View 2 Replies View Related

Excel 2010 :: Macro Runs On Protected Sheet But Changes Protect Sheet Options?

Feb 24, 2011

I am using Excel 2010 and I have a password protected workbook with password protected sheets that uses several macros. Most of them, in order to run, have to un-protect the sheet and then re-protect it again. This has been accomplished easily enough by adding ActiveSheet.Unprotect Password:= "mypassword" and ActiveSheet.Protect Password:= "mypassword" to the appropriate places in the script. All of my macros, which do various things like sorting and moving data, deleting blank rows, displaying dialog boxes containing warning messages etc. run fine.

My problem is this: when I password protect the sheets manually, I have checked the following options in the "Protect Sheet" dialog box. Under "Allow users of this worksheet to" I have checked 1)Select unlocked cells and 2)Format cells. After entering my password and closing the dialog box my sheet is protected, but I can edit cells in the manner my allowances permit. However, once I run any of the macros that un-protect and re-protect the sheet, I remain able to select and edit unlocked cells (practically, for my purposes, this means that I can input data which will appear in the default font size and color of the sheet) but I cannot format cells (which, practically, for my purposes would allow me to occasionally change the font color and size of the data). Naturally, after running a macro, the other cell-formatting options are unavailable to me as well. Is there any way to get my manual selections to remain in place after running a macro that functions as mine do? Or is there any way to make my manual selections the default settings for a protected sheet?

View 4 Replies View Related

Locate Password Of A Protected Excel Sheet?

Aug 28, 2013

I read somewhere that password of a protected excel sheet is located in the sheet itself , hidden somewhere. So , it can be located by some "curious" ones.

Second question is , how can we find that password and prevent anyone from detecting it?

View 1 Replies View Related

Excel 2013 :: Formatting Charts On Protected Sheet

Aug 12, 2014

I am gaining an error in my code due to the sheet being protected.

I cannot seem to get the correct code to allow for the code to still run, while the sheet is protected.

[Code] .....

I tried protecting the sheet via:

[Code] ....

But I still get an error.

View 2 Replies View Related

Macro To Run If Sheet Is Unprotected

Oct 14, 2013

I need to know if it is possible for a macro to run if a specific worksheet is unprotected?

For example, if someone takes off the protection to my costings sheet either through VBA or finding out the password, i want Excel to run a certain macro if possible?

View 3 Replies View Related

Excel 2010 :: Chart Data Labels On Protected Sheet

Oct 4, 2013

I'm using Excel 2010 and I've got a chart on a worksheet and the worksheet needs to be protected. I'm able to manipulate the chart in any fashion EXCEPT the position of the Data Labels. Is this a bug in Excel 2010?

View 3 Replies View Related

Excel 2010 :: Unable To Use VBA Check Box With Protected Sheet / Columns?

Jul 9, 2014

I need to make a excel costing model to calculate various products prices. I am using Excel 2010.

I have many products and do not need all of them displaying at the same time, therefor I inserted a Checkbox (ActiveX Control) that hides my columns that I do not need. I did that by inserting the following and it works fine :

[Code].....

The problem is I now need to lock certain cells so that they can remain fixed and the recipe cannot change.

Once locked my checkbox no longer works and I get the following error :

"Run-time error '1004': Unable to set hidden property of the range class"...

View 1 Replies View Related

Unprotected Sheet Code Not Working?

Jun 9, 2014

I'm currently using a vba script to unprotect all of my worksheets within my workbook in order to refresh the pivots and then protect them again once the pivots are completed, but there are two worksheets I would like to remain unprotected in order for users to be able to edit them after the pivots have been refreshed. Now I've tried adding a sub code in order to unprotect one of the sheets as a test to see if it will allow me to edit the worksheet after I update the pivots. Unfortunately the coding isn't working, and the worksheet is still remaining in protect mode. Here's the code I am using to protect the worksheets when refreshing the pivot as well as the code I am attempting to use in order to unprotect the one worksheet.

View 4 Replies View Related

Keep Sheet Unprotected But Protect Some Cells

Nov 30, 2008

I Need to protect some cells from being Changed or deleted, if i protect the whole sheet there are some cells that need to be changed using the formatting bar I.e borders, colours, font- colour, Merged cells.

the protection setting allows you to leave individual cells unprotected however you still cannot change the border for example.

View 6 Replies View Related

Excel 2003 :: How To Detect Pattern In Sheet

Aug 25, 2013

We have a huge excel-sheet, containing disputes with customers. Everytime there is a dispute, the customers data will be transferred into the sheet. The sheet is organized like this:

DATE / NAME / ID / COMMENT / FREQUENCY (how often one customer appears in the list) /ID2 (ID combination of the date + ID) /Weekday

And here comes the task:

Find all customers who appear 10 work-days(Mo-Fr) in a row. So if a customer appears Mo-Fr and keeps on being in the list the next Monday etc. it still counts as "in a row". Same with official holidays. If a customer appears at a certain date he is "booked" and it doesnt matter if a appears a second time on that specific date.

Attached to this post you find an example in which you can see the structure of my excel sheet!

example.xls

Note: I had to use a german version of excel when I made this little example - thats why the formula in the collum "Frequency" says "Zahlenwenn" its the german version of COUNTIF

Excel 2003

View 7 Replies View Related

Excel 2003 :: Selecting Only Certain Items From One Sheet To Another?

Mar 26, 2012

Using Excel 2003

We have a spreadsheet set up showing a list of sales invoices, each invoice has the customer name and a customer reference assigned to it i.e B1, B2 etc

We want to set up another sheet that takes the sales invoice information but only picks up that which relates to a specific customer, i.e want a list of the invoices relating to B1

This will be done with a view to creating statements for each individual customer reference number which will just take info from these sheets B1,B2 etc

View 1 Replies View Related

Excel 2003 :: Log Sheet - Creating Invoices

Apr 20, 2014

I am using Win XP Pro, Excel 2003. In the workbook, I have a invoice spread sheet (lets call it sheet1) to create invoices. Once the invoice is completed, I save it with this macro which saves it to the contents of E3 and E7 for the file name:'

Sub SaveMeExtraQUOTE()
Application.DisplayAlerts = False
' Dialog's Title
strTitle = ""My Tite""
If MsgBox("WARNING !! STOP! Enter ALL your quotes information to be saved BEFORE saving the file!!!

[Code] .......

This is working just fine BUT it keeps saving it to a template file where the master template is kept. Why will it NOT save it to the QUOTES folder when I am using this:

Filename:="C:EXCELATX Concrete DesignQUOTES"

I am also trying to have a space between the contents of cell E3 and E7 when the file name is saved. Now it just puts them together.

View 2 Replies View Related

Excel 2003 :: Formula To Pull Data From One Sheet To Another?

Jan 16, 2014

I have Excel 2003

My spreadsheet has multiple lines of data for multiple items (have a specific item #) and I need to be able to enter an item # on a different sheet so that the requested information can be pulled from the data source. The items have information on multiple rows. I need to have all of the rows pulled into my output file when I specify the specific item. #.

I have attached a spreadsheet showing the type of data is contained and what my desired output would look like.

View 1 Replies View Related

Excel 2003 :: Identify All Sheets Related To One Sheet

Oct 13, 2011

I have been given an excel model to review;the workbook has 53 sheets. I would like to know if there is a way to create a flowchart/matrix with the relation of all the sheets. I would like at least to get a list of all the sheets related to each sheet. All what I was able to do is to get all the sheet names in one sheet. (I am using Excel 2003).

View 2 Replies View Related

Excel 2003 :: Copying Row To Different Sheet Based On Condition

Feb 16, 2013

I wanted to know if it was possible for me to be able to copy a whole row into a different sheet based on a column value. For example, if B6 = CLOSE, the whole row would be coppied to the sheet name CLOSE. If B6 = OCCUPIED it would be copied to sheet name OCCUPIED. I also need if W7 = to a date thats passed today it would be added to the sheet name EXP PRD. An off topic question, i have this code for column "W":

=COUNTIF(W6:AD155,">"&TODAY()+15)

It works just fine, but I also have "N/A" / "INDEF" in the blocks as well so it's not giving me the correct results. I'm using Excel 2003.

View 8 Replies View Related

VBA - Protected Sheet But Enable Cell Range?

Jun 26, 2014

Have wrote the following code to enable 7 sheets to be unprotected, the pivot tables and charts housed within them to be refreshed then the sheets to be protected. However, once the macro has finished I need to be able to still use the filters on the pivots to flick through data. I also need the data table to be protected with the exception of a cell range that can be edited (preferably password protected.

Sub Refresh()
'
' Refresh Macro
' Refresh Pivot Tables/Charts

[Code].....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved