make colour in rows stay
How can I lock the fill colours in a row even when I change around the data
or sort alphabetically?
Thanks and God Bless,
Regards Ron de Bruin
"Crowraine" <Crowraine@discussions.microsoft.com> wrote in message news:ED158D7D-62AB-4DA8-A948-2A6556D8047C@microsoft.com...
> How can I lock the fill colours in a row even when I change around the data
> or sort alphabetically?
> Thanks and God Bless,
...How to Hide Left Panel of Folder Window?
I'm well behind the Windows curve and I'm just now learning to use Windows XP
Home. Up to now I've been using Windows 2000 Pro.
On my XP desktop I have a shortcut to my music folder which containins my
When I double click on the shortcut, a window opens on the desktop
displaying the contents of my music folder.
This window has a panel along the left side containing items like "File and
Folder Tasks" and "Other Places."
I can't figure out how to close, hide or otherwise delete this panel. This
panel takes up a lot of prec...What is 'Align Text to Base Line Guide'?
Trying to make sure all lines have the same amount of space between them I
selected paragraph from the format menu and under the line adjustments there
is a box 'align text to base line guides' Ok I did that, now there are lines
at the margines of my newsletter. What are these? Also selecting this pushed
my text down from the top edge of the text box. What is this?
The baseline guide measurements are in the Arrange, Layout Guides, Baseline tab.
There is help in the Help menu.
"Go_Girl3647" <GoGirl3647@discussions.microsoft.com...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...One Entry to Multiple Rows
I have data that looks like this:
X1 | Y1 Y2 Y3 Y4
X2 | Y4 Y5 Y6 Y7
And I need to get to:
X1 | Y1
X1 | Y2
X1 | Y3
X1 | Y4
X2 | Y4
I can change the 2nd row's entries to more columns, but that doesn't seem to
get me much closer to the needed format (and there are thousands of lines so
I'd rather not do it manually). Any ideas?
should do it. change mc to suit
Dim mc As Long
Dim mr As Long
Dim i As Long
Dim lc As Long
mc = 3 'col c
mr = 1
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
lc ...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...Query to hide duplicate records
I recall that this used to easy in previous versions (Unique values
only ??), but in 2007, I can't get this to work at all.
I have a table with our companie's job numbers in it. The job numbers
show up multiple times because of different phases of the project:
3077 Univ. of Vermont/UC/LEED
3077 Univ. of Vermont/University Commons: Building Fee
3077 Univ. of Vermont/University Commons: Excess Professiona...
I need to jut have a single listing of each project number, otherwise, I
get repeated records in the query that looks at this information (which ...Hide tab or sections
Is it possible towrite an event code for onChange to hide the tabss or
sections when the value change in a picklist?
"Alper Can" <firstname.lastname@example.org> wrote in message
> Is it possible towrite an event code for onChange to hide the tabss or
> sections when the value change in a picklist?
> Thank youo
actually you can, but its unsupported,..........I did something similar and
the code was horrible (but worked), and after 1.2, it got erased (didn't
want it anymore).
&qu...Return values that sum to a known value
I have a list of data and would like to know if there is a formula that would
return any items from that list that sum to a known value.
Have a look at this thread for something similar:
> I have a list of data and would like to know if there is a formula that would
> return any items from that list that sum to a known value.
...Create individual files from a row
I have an excel file with several thousand entries, which contain data
in several columns. I would like to be able to create an individual
xml or html file for each row, but with predifined formatting around
Mr A bloggs, A street, A town, AA1 1AA
Could become Abloggs.html
<name>Mr A bloggs</name>
Any other info here as well
etc. Is this possible and any suggestions how?
GrahamN's Profile: ...Determine number of rows with data
I am using the macro below to pull some data from an external workbook.
The 2 issues I need to sort are:
1. The number of rows in the external workbook can vary. How do I amend this
code to pull all of the rows with data?
2. The number of rows in the autofill also may vary. How do I autofill only
the number of rows required? i.e the number of rows in column A that contain
'Lookup Previous Month Sales
Selection.NumberFormat = "General"
Selection.FormulaArray = _
"=S...Selecting cell value for a sum, based on a condition
Trying to come up with a formula or method that will enable me to sum values
based on a condition. For example, I have three columns which contain a
condition and two amounts. If the condition is of the 'each' variety, one value
will be used in the sum. If the condition is of the "square foot" variety,
another value will be used. Here is a small diagram that may help visualize
A B C D
1 Measure Unit Cost S.F. Cost Summed Total
2 Each 3.00 .30
3 S.F....Hide Global.xls (personal.xls) in project explorer
How do I hide VBAProject(Global.xls) in project explorer. I just want
my normal project there.
You can't hide it, but you could give it a password:
Select your project
Give it a memorable password
At least the project won't be too intrusive.
> How do I hide VBAProject(Global.xls) in project explorer. I just want
> my normal project there.
...Copy/paste range of rows between 2 dates...
Hi! I have a sheet called data which act as a database. The column A has
the dates. In order to create customized chart in a userform, for
different range of data(i.e from column D, G and M...), I'd like to
select a range of rows that are between 2 dates and create the charts
accordingly. Or copy to range to another sheet and then create the
charts. I am not so advanced in VBA and any help would be greatly
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
...Enable/Disable a Form Control Based on Security Group Permissions
How do I enable or disable a control in a form based on a user’s security
group membership? For example: If I have a checkbox on a form (call it box1),
I want box1 to be enabled if the user who opened Access is a member of a
security group called “Breaker Test Admin.” For members of any other group
(except of course “Admins”), box1 should be disabled.
Thank you, for your help!
On Mon, 02 Jul 2007 18:57:13 GMT, "BenS" <u35527@uwe> wrote:
>How do I enable or disable a control in a form based on a user�s security
>group membership? For example: If I have a checkbox on a ...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...EXTRACTING UNIQUE RECORD BASED ON CONDITION
This is a multi-part message in MIME format.
I would like to extract unique records based on a condition. For =
example, how to extract unique record from column 'B' when column 'A' =
has "AP" or any other desired condition.
The data is as follows:
A B =20
AP PATRICK CUDAHY INCORPORATED=20
AP PATRICK CUDAHY INCORPORATED=20
AP SUGAR CREEK ...set value of a group of activex control points
Have a spreadsheet that has some 20+ activex control points (option buttons).
Is there a way to group all these controls together & set their initial
values the same? Trying to setup a "reset" type of operation that would clear
all control points. I can do them individually via properties, but it's too
...underline in row not repeating
It seems as if my bottom of the cell outline is not repeating on subsequent
pages. I have a few header rows on a sheet. The bottom row has a bottom
line. I'm talking about cell outlines, not underlining of words in the cell.
Anyway, I've told the print option to repeat the first 3 rows on following
pages but the bottom outline does not seem to repeat. How can I fix this?
Never mind. This seems to be working. Not sure what was going on the first
"Keith G Hicks" <email@example.com> wrote in message
>...How to unhide Excel rows after they are automatily hidden
Helpful advice on posting to newsgroups here... http://www.cpearson.com/excel/newposte.htm
San Francisco, USA
(Excel Add-ins / Excel Programming)
wrote in message
...Storing distinct values in an array
in the speadsheet, i have a column containing a series of numbers
maybe of them repeated multiple times...
i would like to store all distinct values in an array
any ideas on how i could do that ...
eg , if these were the numbers going down column then 1 3 5 7 5 3 5 7
5 4 3 4 5 7 8 5 3 .. store 1,3,5,7,9,4,8 in an array, in no specifi
shimeel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1583
View this thread: http://www.excelforum.com/showt...Populate cell with a value if another cell has a certain value
All, good morning. i have a issue, i need to populate cell E4 with a value
CX/025966 when cell F4 has a text Bond Street.
Is there a simple way of doin this?
If my comments have helped please hit Yes.
> All, good morning. i have a issue, i need to populate cell E4 with a value
> CX/025966 when cell F4 has a text Bond Street.
> Is there a simple way of doin this?
=IF(F4="Bond Street","CX/02...Show zero values
When a formula returns a zero value, the zero value is not being
I have reviewed the following:
- conditional formatting
- zero values are checked (Tools/Options/View)
- stepped through my VB code (it inserts formulae based on a Worksheet
- locked and hidden values unchecked with and without protection (this
should have no effect when the sheet is unprotected)
Are there any other circumstances that result in a zero value not being
displayed? Are there any other reasons for this occurrence?
Check also normal cell formatting! there are formats that hide ...CButton::GetButtonStyle()
is it possible that the function GetButtonStyle() returns one single style
where can i get information when to use a mask and when to use the plain
how about other controls/windows?
actually i am a little bit confused about this...
"Philipp Huber" <firstname.lastname@example.org> wrote in message
> is it possible that the function GetButtonStyle() returns one single style
I'm not sure what you're asking, but GetButtonStyle returns the LOBYTE of
the GetWindowLong/GW...Help with Highlighting all duplicates in a row
I am trying to highlight duplicates in a row and am using the explanation:
Highlighting Duplicate Entries
Our first task is to highlight the cells in Range1 that are duplicates. We
use Excel's Conditional
Formatting tool to accomplish this. First, highlight the entire Range1.
Then, select the
Conditional Formatting tool from the Format menu: Format->Conditional
Change the "Cell Value Is" option to "Formula Is" and enter the following
formula in the
formula text box:
Where A5 is the first cell in Range1....