How To Make Columns Read Only
Aug 7, 2014Is it possible to make Columns Read only? So not one can type or edit. Not all columns just the ones I need
B,C,D,I,J
ADVERTISEMENT
How To Make Cell Read Only
May 9, 2006I have tried the following code, but doesn't work unless I protect the sheet:
Range("A1:A4").Select
Selection.Locked = True
Selection.FormulaHidden = False
If I protect the sheet, then it works fine, but how can I make a cell read only
WITHOUT protecting the sheet?
To Read A File And To Make Changes Using VBA
Aug 21, 2009I have attached three excel files .....In the file called 'sampleBook1latest' I have a button called 'click here to clear a schedule' If I click that button and choose OR,start time and duration of a surgery then a schedule that is already created wil get cleared.....I have the total number of nurses and number of nurses used saved to the side of the sheet..... The total number of nurses at the side is read from another excel file called 'Input file for # of nurses'
Now the problem is that if clear a schedule then the number of nurses used is not getting updated at the side.....if I clear a schedule then the number of nurses at the side should also get updated....for example(If I create a schedule with 3 nurses and if only a total of 3 nurses are available then..... the used number of nurses for that specific time at the side will get updated to 3 from 0 and if I clear that schedule then the used nurses for that time should again become 0)....
The other problem is that if I schedule a surgery then all details of the surgery will be saved in another excel sheet called 'input file for patient details' so if I clear a schedule then all the details of that surgery saved in that excel sheet should also be cleared......
Make A File Read Only
Aug 30, 2007I need to make a workbook read only depending upon certain conditions that are apparent only on start up. As I cannot assign the ReadOnly property, is my only solution to trap the Save command and dissallow "save changes".
View 9 Replies View RelatedHow Can I Make A Persons Name Read A Formula
Jul 28, 2009If I type the name Joe Bloggs How can I make whenever i type that name the computer knows to retreive a number or formula from a cell on another or same sheet.
View 9 Replies View RelatedHow To Make A Cell Read Only Decimal
Jul 1, 2013I'm trying to create a formula in a cell that references another cell but I only need it to reference the decimal. How would I go about doing this and is it even possible?
View 3 Replies View RelatedMake Workbook Read Only Upon Opening
Dec 12, 2007way of changing the mode of a workbook to readonly upon opening it.
View 6 Replies View RelatedRead A .txt Into Columns
Jan 21, 2009I have a text file that I want to read the data into a sheet and split and store into columns.
The format of the textfile as follows (Only two records will contain 200 with line break to seperate):
Atom "file" contains: C:B_200801142021_VIDEO_BOYS_EVENTS_FIRSTBIRTHDAY@Video Title 1.mp4
Atom "©nam" contains: Video Title 1
Atom "purd" contains: 200801142021
Atom "keyw" contains: VIDEO_BOYS_FIRSTBIRTHDAY
File "F_©nam" contains: Video Title 1
File "F_purd" contains: 200801142021
File "F_keyw" contains: VIDEO_BOYS_FIRSTBIRTHDAY
Countifs Except When Two Columns Read X?
Dec 17, 2012I'm trying to find total gross commission within a spreadsheet, where gross commission found in Deals column Q. Columns T & U indicate with an "X" whether the deal was associated with referrals and such.
=SUMIFS(Deals!$Q$2:$Q$500, Deals!$T$2:$T$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")
=SUMIFS(Deals!$Q$2:$Q$500, Deals!$U$2:$U$500, "x",Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<1/1/2006")
But now I need to sumif Q2:Q500 excluding rows where "X appears in either T or U, or both, to indicated complete self-generated deals.
Making Columns Read-only
Aug 4, 2006I want to make some of the columns read-only (user cannot edit any of these cells).
View 2 Replies View RelatedRead Only Visible Columns From A Range
Jun 17, 2009I do hav a sheet in which i do hav some column;s n data
Worktype
Metrics
April
May
June
in work type few rows are hidden which i don't need what i need is i want to populate only comman metrics in other range named metrics i had build a macro for this and that's working fine but the problem is it also reads metrics from hidden rows too. i had tried a loop in which i had placed as hidden column property condition.
Formula To Read Alternative Columns - Instead Of =
Jul 14, 2008I have got several columns of data with subtotals, months, total unit per month, total sales per month, Example
jan feb
total unit total value total unit total value
60 £600 35 £180
SOLUTION
dateunitsale01-Jan6060001-Feb3518001-Mar335801-Apr911220
I am having to use = sign (=A10 --) transfer the information to solution, is there a formula that I use instead. I have try $A10,A$10 to ancher the column?. ideal I need formula that read alternative columns for date, unit and sales- that I can copy down?
Make A Worksheet "Read-Only"
Feb 15, 2010I have four worksheets in my project and I would like to protect one of the sheets so changes can't be saved. In other words, I would like to make that specific worksheet "read-only". The other three sheets I want changes to be saved with the document.
View 4 Replies View RelatedTextbox Wont Read From Hidden Columns
Sep 23, 2009I have a userform with a bunch of textboxes that read from certain rows/columns/etc. However, when I hide certain columns (I need them hidden) the textboxes don't display the data (it only displays when the columns are not hidden).
View 2 Replies View RelatedFile May Be Read-Only, Or You May Be Trying To Access A Read-Only Location
Jan 4, 2007I'm trying to open a file on a network drive...but I'm getting the following error message when it opens: "This file may be read-only, or you may be trying to access a read-only location. Or the server the document is stored on may not be responding." Now, the file itself has no rights restrictions and is not read only. It doesn't appear to be locked.
Now, there are other Excel files in the same directory which I could open fine; however, the Excel documents having the above problem all have a little black icon "appears to be a padlock" (image attached) at the bottom left hand side of the Excel file icon. I tried the following:
- Renaming
- Converting to a different file format (didn't work, it won't let me)
- Opening in notepad...etc doesn't work.
This file is dated back in 2004...do you think it's corrupt? Is there anything i can do to open or recover this?
Concatenate 2 Columns To Make Every Possible Combination
Jul 19, 2009Is there an easy way to concatenate two columns and provide every possible combination?
E.g.,
A B
1 A1 B1
2 A2 B2
3 A3
The function should result in
C
1 A1B1
2 A1B2
3 A2B1
4 A2B2
5 A3B1
6 A3B2
Make Columns Start From Left To Right (A ,B, C, ...
Dec 22, 2009I recently installed 'windows 7 ultimates' , and after i insalled Excel 2007 .. the columns start from right to lfet (..., C, B, A), I want to reverse it to start from left to right (A, B, C, ...), I don't know whether the new ystem 'windows 7 ultimates' has some effect on it to be modified like this. moreover, the language of system is English. so how to solve it
View 3 Replies View RelatedHow To Combine Two Columns To Make Phone #s.
Feb 1, 2010I have two columns of numbers. The first is the area code and second is the phone number. How can I combine the two columns to make one with both: as in area code-phone number?
View 3 Replies View RelatedHow To Make Columns In Listbox In Userform
Mar 20, 2013I made an excel MAcro Sheet as I am not good in macros. How to make a columns in list box via text boxes in userforms.
View 2 Replies View RelatedFreeze Columns And Make Them Non-scrolling?
Jul 21, 2014I have a worksheet in which I want to freeze columns A and B, and either make them non scrolling or 'fix' rows 1 - 25 so that they are permanently in view.
View 4 Replies View RelatedMake A List Of Unique Values Using 3 Different Columns?
Feb 26, 2014See attached file with a smaller sample of the 1667 row table of data I am working with. What I am looking to do is make a list on another sheet of each every line with a county and have the corresponding Township and range with it. So if I have a cell and I select Audubon county, I would like a list to populate that has the 12 lines of Audubon county in column A, and the Township in column B and the Range in column C.
Excel Rate Example.xlsx
Make Columns Visible/invisible As Per The Conditions
Sep 4, 2009I am trying to create a daily task activity sheet. I would like to know, how to make the columns visible and invisible as per the selection from previous column.
For eg:
Column A has a list which has values 'TC creation' , 'TC modification', 'System Test' etc.
Upon selecting TC creation, i need to make a column visible ie 'total tcs created'.
Upon selecting 'TC modification' i would have to make the previous column invisible and make a new column visible for entering no of tcs modified.
Upon selecting 'System test' the other columns should go invisible and make other 3 columns visible for no of tcs executed, no of tcs passed, no of tcs failed etc...
Make A Mcaro Loop Through 5 Pairs Of Columns
Jan 26, 2009I've managed to get my macro to work ok - but what I want to do now is to get it to loop through more columns. Currently it looks for email addresses in column AH (which will always be the same) then it looks for a "yes" in columnAB and if there is no "SENT" in column T then it sends an email,after which it adds the word "SENT" to column T. What I want t do is for the macro to then run on columns AC+U, AD+V, AE+W and AF+X. So basically it will loop through one column to the right each time for a total of 5 pairs of columns
View 2 Replies View RelatedHow To Make Excel Report Width Of Columns(s)?
Jan 13, 2010I'm looking for a macro or function/formula to list & total a range of column widths. Having lots of columns with varying widths t'would rather not have to do it manually from each column's Properties.
View 9 Replies View RelatedExcel 2007 :: Make Connector Lines Invisible In Some Columns
Feb 3, 2012Using Excel 2007.
I have some connector lines that cross over tables in Columns G:K that are connecting tables in $D to tables in $M
How can I make the part of the connector line in $G:$K invisible?
something like:
Code:
Sub FormatConnector
Dim oConnector as Shape
With oConnector
If .Connector Or .Type = msoLine
If .Connector In Columns($G:$K) Then
.Connector.Segment.Visible = False
End If
End If
End with
End sub
Cascading Ranges - Vlookup (make My Reference Range Access Multiple Columns)
Feb 10, 2010I need to run a vlookup to find some data. But I have a lot of data about 600,000 lines. Currently this list is spread over several columns (as the limit is something like 50000). How can I make my reference range access multiple columns?
View 5 Replies View RelatedExcel 2007 :: Make One List Out Of Columns Based On Common Information In Column C?
Oct 12, 2011Is it possible to take the information below and make one list out of columns F, H and J based on the common information in column C? For example, group all the 18s in a list, followed by the 44s.this is excel 2007
column CColumn Fcolumn Hcolumn J
Option code
18180L12369301/123/54
18180L12369301/123/54
18180L12369301/123/54[code].....
Make Userform Show Data From Spreadsheet And Add Delete Or Make New Entry
Jan 24, 2014I have a spreadsheet on sheet 1 with a list of customers and their information. So on column A I have the customer number (i.e. k968, e37, p528,...), on column B i have the customer's name, on column C the street's name, on Column D the house number, on column E the zip code and finally the city on column F.
Right now there are around 600 customers in this list.
I have made a userform with a combobox in which I want to select an existing customer (pulled from the spreadsheet). On the same userform I have textboxes (customer number, name, street, number, zip, city). When I select a customer in the combobox, I want this customer's info to show up in the textboxes. I want to be able to change the info and hit Next to store the changes in the spreadsheet. When I do not select a customer from the combobox, I want to add new info in the textboxes and hit Next to store this info as a new customer. The userform also has a delete button. Then I select a customer in the combobox, this customer (and it's info) should be deleted from the spreadsheet when i hit Delete. So the spreadsheet is variable in length.
Make Now () = 06/29/2009 (make To Cells With Dates Equal Each Other)
Jun 29, 2009I need to figure a way to make to cells with dates equal each other if the
day,month and year are the same but are placed into a cell at different times during the day. "Making Date Now () = (06/29/09) In another cell". Therefore, A1= Now() and E11 = 06/29/09
Read Only To All But Two
Feb 18, 2009i m wishing to make a ss available to all but only ready only format 2 people need access to ammend the data and spreadsheet.
View 2 Replies View Related
