Code For Locking A Row Of Headings
Nov 20, 2009
My questions is how to "freeze pane" a row of headings on the Results page and post the results onto row 2 and downward *without* deleted row 1.
If you look at the attached file, you will see a tab that I created called "My desired Results Page" that simply has a frozen row of cells. Instead of just displaying the rows from the Details page on the Results page, I'd like them there but with the headings at the top.
Is there code that can do this?
View 5 Replies
ADVERTISEMENT
Apr 5, 2009
The first five columns of my table contain row titles. I'd like to keep these columns stationary while I scroll horizontally through the remainder of the columns.
As it is now, only the row number remains stationary, but I really don't need the numbers, just the row titles.
Is there any way to do this? And would this also be possible with column headings (so I can scroll down without them moving up)?
View 2 Replies
View Related
Apr 13, 2008
I'm trying to run the below code, but every time I do, it locks up excel. The code is running on 900 rows of data within the "loop to delete rows" section and in the main for loop there are 49 values to evaluate for the string strSA. how I can improve this code? When I step through it with F5 it works fine.
View 14 Replies
View Related
Feb 16, 2007
1. When I put data into one cell I need three other cells to be locked and not allow data to be inserted unless the data from the previous cell is deleted.
2. I have attached the Excel sheet for better understanding.
View 2 Replies
View Related
Oct 13, 2009
Is possible to populate the headings of a listbox via code
I have a list box with three columns and need the headings to be
"Number" "Rider" and "Bike"
View 5 Replies
View Related
Jan 4, 2010
I have been assigned the task of creating our new integrated time and leave sheet in Excel 2007, previously we had 2 sheets, one for times and one for leave.
The problem I have is that I need to protect the authorisaton columns therre are 2 one for AM and one for PM, so that only Managers can authorise leave by inputting a password and then initialing the leave.
What I then need to do a the end of each month is for the manager to be able to click a Button with a Macro which will then lock the whole worksheet so that employees cannot change their times after the manager has checked the sheet.
I can lock the authorisation columns and password protect but I have to enable protection on the sheet, when I do this I cannot then figure out a way of running a macro which will then protect the whole sheet and assign a password to it so it cannot be changed after being checked and signed off.
I have tried to create a macro (button) to remove the protection on the 2 columns and then reapply protection to the whole sheet with another button but to no avail.....
If anyone has any suggestions I would be eternaly greatful.
Passwords on the sheet for the different buttons are abc or cobra.
You can download my Spreadsheet here.
[url]
View 9 Replies
View Related
Mar 28, 2012
I am currently working on spreadsheet which is using a mix of Conditional Formatting, Validation and a bit of VBA code.
The spreadsheet is a log of vacancies and applicants, When "vacancy" is selected in A I have introduced some VBA code to lock down cells S:AT on the same row.
The code is working but the issue is it is stopping you using the drop down validation throughout the sheet, if you click the arrow that appears on the cell nothing happens, However you can still access the dropdown by right clicking and choosing the 'Pick from Drop-Down List' Menu Item.
The validation is set up by ranges from another Worksheet.
The Code I am using is:
Private Sub Worksheet_SelectionChange1(ByVal Target As Range)
Dim myrow
Dim StarLock, EnLock
[Code].....
View 2 Replies
View Related
Oct 10, 2008
I recently posted a thread on locking one cell if another had a value in it, and vice versa for the other cell. I got this great response (thanks se1429!) and it works GREAT, but I failed to mention that the worksheet is password protected. It asks for a password when I enter a value in one of the cells. I just need help adjusting this code so I can put my password in the code and allow the worksheet to unlock and lock at will by using this password.
View 9 Replies
View Related
Oct 5, 2009
I need a vba code which inserts a text/heading into an excel chart.
Today I wrote the heading inside the code, in this way:
View 8 Replies
View Related
Feb 8, 2010
Is there a way to hide the formula bar and headings for a specific worksheet(s) with a workbook but not all the worksheets? In other words, I want to hide the formula bar and headings only for certain worksheets. When I select hide on the show/hide ribbon, it hides it for all the worksheets within a workbook.
Also, is there a VBA code that can be written to hide formula bar and headings for a selected worksheet?
View 9 Replies
View Related
Nov 23, 2006
I have a workbook. Numbers On The Left And Letters At The Top of all sheets cannot be seen. How can I make them visible?
View 2 Replies
View Related
May 10, 2007
I use currentRegion to add the item to the combobox, but i don't know how to add without including the first cell in the range,as usually, it is the field name.
View 5 Replies
View Related
Dec 10, 2008
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B:B")) Is Nothing Then
Application.EnableEvents = False
Cells(Target.Row, 1) = Now
End If
Application.EnableEvents = True
End Sub
everytime i lock the column a by using the protect sheet, the vba does not work or debugs. is there a way for me to lock the cell in column a when data is inputted or changed in column b? i am using date and time for column a
View 4 Replies
View Related
Mar 27, 2009
=IF(D2<>"",IF(A2="",NOW(),A2),"")
Whenever I type into field D2 it populates current date and time in field A2 and down the A column as I write into current D columns. The next step I would like to do in which he was able to figure out so far is how to lock in the date and time after something has been typed into D2. If I make any changes to the D2 field it updates the date and time, which I dont want to happen.
View 3 Replies
View Related
Mar 27, 2008
I have a user that is trying to lock certian cells within a spreadsheet but to allow certian users still to be able to edit these cells.
When this users is trying to do this and locks the cells it is locking for all users and not applying the "allowed" list of users to make changes.
View 9 Replies
View Related
Apr 1, 2008
is it possible to lock a worksheet. For example, i have a single worksheet in a workbook that i do not want people viewing. Is there any way that a password would have to be used to gain access to it? I have to keep the sheet inside this workbook because information is pulling from other sheets inside the workbook.
View 9 Replies
View Related
Oct 6, 2008
I did review some examples your members have already provided however I have a slight twist.
I have multiple users adding to a spreadsheet from which data is later copied to a master sheet. I need to lock ONLY cells which contain data when user chooses to save spreadsheet or saves speadsheet on exit. If the cells do not contain data, they should remain unlocked.
View 9 Replies
View Related
May 25, 2006
how to lock a graph in an unprotected worksheet?
View 7 Replies
View Related
Jul 28, 2006
top three or four rows so that scroilling down the screen leaves the title rows where they are .
I know that this is possible and have done it several times in the past, age however, dulls the memory and I have just forgot the procedure,
View 3 Replies
View Related
Nov 9, 2006
my spreatsheet calculations work, but the overall thing is too large to print; i am running many numbers and formulas. I made them all finally refer to a small 'summary' box which i created...but when i try to transfer the box to a new worksheet so that i can print it and only it; it automatically has no references for the formulas on the new (blank) sheet, and comes up all errors. to the point, how do i lock the way a box appears (when it contains formulas) so that it will remain sensible after it is transferred elsewhere?
View 3 Replies
View Related
Mar 29, 2007
I am trying to unlock a cell if another cell is a certain Value and if it is not that Value to lock again i have got as far as unlocking it but i can not get it to lock if the value is faulse. This is what i have so far!!
Private Sub Worksheet_Change1()
If ("K4") = "Daily" Then
ActiveSheet.Unprotect ("Password")
Range("F6").Locked = False
ActiveSheet.Protect ("Password")
End If
If ("K4") = "Monthly" Then
ActiveSheet.Unprotect ("Password")
Selection.Locked = True
ActiveSheet.Protect ("Password")
End If
End Sub
View 2 Replies
View Related
Aug 6, 2014
I've got a few worksheets that have staff names on Col A. And these names are under sub headings of what position they work in (Foremen, Operatives etc..).
Before I had access to them, the names were not in order, now I've change it to A-Z, for each staff under their position.
I know you can make your own custom order list, so the list goes top to bottom : Supervisor, Formen, Operative, Office.
What I sometimes need to do is sort Col B or C. But is am unable to sort it back to it's original state
Attached is an example of how I would like my spreadsheets to look. But is there a way to use Sort & Filter so it sorts the entire table by position, keeping the correct name under the correct position heading.
New Microsoft Excel Worksheet (2).xlsx
View 9 Replies
View Related
May 24, 2007
I use a macro to format a debtors ledger. This report shows the amounts that customers owe broken down by the age of the debt, ie Current, 30, 60, 90, 120 days.
To make it easier to read I want macro code that will replace these mostly numeric headings with months ie April, March, February, January, December.
View 13 Replies
View Related
Jun 16, 2009
I want to save a worksheet as a CSV but Excel saves the column headings as the first line of the saved csv file. I don't want the column headings in the saved file.
View 3 Replies
View Related
Oct 11, 2007
I have data sent to me describing angles as integers from -180 to 180. I need to average these angles together. For example, the average of 10 and -2 should be 4. Great. However, the average of 175 and -175 should be 180.
Has anyone ever worked with this type of issue?
(I've thought about converting -175 to 185, but then I have trouble with 5 and -5, which becomes 355).
I should probably note that I have a list of angles, not just 2. The analysis I need to do is 1) average of all angles and 2) difference from the average for each angle.
View 9 Replies
View Related
Nov 14, 2006
I am trying to find out if i can reference to a table on Excel. For example; if i enter in one cell the word 'january' (a header on the left of the table) and 'week 1' (a header on the top of the table) in another cell, can i set it to produce the value in the table that coresponds to the two headers.
View 2 Replies
View Related
Nov 22, 2006
Assuming I have a data martix which is X* Y. I want to store a range that is at Row Z. I have named a single cell at Row Z as "dataStart". How can I store that Row without the header?
View 5 Replies
View Related
Feb 10, 2007
as you know at the top of the excel 2002 worksheet there are headings:
A B C D E etc etc
how do i change these (A,B,C,D,E) to my own personal heading?
example:
A = Title B = Type C = Subs etc etc
or do i have to 'drop' all the info down by 1 level?
i really need to keep the 'numbers' for the colums so that the 1st entry doesn't start at A2
View 2 Replies
View Related
Jun 21, 2007
TAKING A BIT FURTHER THE POST Find Min Value In Multiple Columns And Match The Header
Here's my problem: I am trying to find the MIN value in a column with dual headings and match the corresponding product which makes my formula with three criteria.
see the attachment to see the structure of the tables and further explanation.
View 4 Replies
View Related
Jul 18, 2007
how do i go about coding a macro so that it can look at a column,lets say column F in this case, on a worksheet and figure out how many rows contain data, select all rows BUT the header row (row 1 in this case), select them for copy, and paste them to another spreadsheet in the xls file starting from row 2, pasting values only.
the way i would LIKE to do this function is to take column 1, determine its length, or how many rows contain data and where the first empty row kicks in, anchor that into a variable and use that variable to set the copy paste function for the remaining columns i run the function on. why do i need this done? i'm makign a macro that can automatically build reports for me from raw data dumpted from the system.... and later columns in the spreadsheet have empty cells, so i want the function to process at a fixed length with all cells using column one as a guide for the copy/paste function
View 4 Replies
View Related
