How can I enter a cell in excel with hotkey or combination off key
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"theo passier" <theo email@example.com> wrote in message
...Save file with cell name
In cell A1 i have =cell"filename"A1 giving me the
I want to run macro that will save new file with data in A1
Example. tab named wc0701. new file saved as wc0701
Message posted via OfficeKB.com
You could just drop the formula in A1 and use the worksheet name itself.
.parent.saveas filename:="C:\" & .name & ".xls", ...rest of options
"Brian Thompson via OfficeKB.com" wrote:
> In cell A1 i have =cell"f...Position Chartobjects in Chart sheet
I have moved from Excel 2003 to 2007. When moving an XY scatter chartobject
from an existing chart sheet to another chartsheet using
Set cho = ActiveSheet.ChartObjects(1)
cho.Chart.Location where:=xlLocationAsObject, name:=chForStore.name
I get an error message saying something like "Dimensions not valid for chart
Further, when having located a number of chartobjects in a chart sheet Itry
to position them nicely. I start at the source Chart sheet ChartArea.Top = 0
and ChartArea.Left = 0 but the charts located in the top row invariably
appear to ...Merging and formatting a cell in workbook_open
I have a workbook_open event, in which Im unprotecting a sheet, copy a
cell's contents (A3 Cell) in that unprotected sheet and paste it in to cell
J12 of the same sheet and then protecting back the sheet.
Idea seeking - Im quite wary of my VB project password being "hacked" in to.
Plainly speaking I dont have much problem if they see the code etc but in
the workbook_open event the password of the sheet is given which I would not
like to disclose. Its because I use the same password for protecting other
sheets and the workbook itself. I understand that worksheet passwords ca...Mesothelioma : Dangerous Malignant Cancer That Everyone Should Know It
Mesothelioma : Dangerous Malignant Cancer That Everyone Should Know It
A Dangerous Cancer that darken many great people lives who worked with
check all of the details about mesothelima secrets at
Mesothelioma Dark Day
Can anyone tell me whether it is possible to format individual cells so that
they do not print. I do not want to hide rows or columns as I want to be
able to see the contents on the screen.
Almost what you want...
Use a custom number format of 3 semicolons ;;;
The content of the cell will appear in the formula bar but not on the screen.
San Francisco, CA
"Andrew Mackenzie" <firstname.lastname@example.org> wrote in message news:OXsY9zBZEHA.email@example.com...
> Can anyone tell me whether it is possible to format individual cells so...How to change cell color based on content
Hi, hope someone can help me. I don't use Excel much, but I'm creating a
spreadsheet that keeps track of ticket sales for a charity I volunteer for.
Anyway, what I want to do is to make the cells stand out for those that
still owe money, either because a check is forthcoming or because they
ordered by credit card.
I want the credit card orders to show up with a different color (eg YELLOW)
than those who are fully paid.
I want the forthcoming check orders to show up in a different color (eg
So I have a column with payment type that is either Cash, Check, or Credit
Card....Cell value not recognize in an expression
Any reason why the cell value of C18 would not be recognized, if I replace the value of c18 in the expression, it works but putting the value of C18 as a reference in the expression give me zero as an answer.
Norman Harker MVP (Excel)
"jaclh2o" <firstname.lastname@example.org> wrote in message
I have been creating graphs using the stacked area type to display data for
data by year. However I have some years that have missing data. This then
plots as zero. I have been to tools, options, charts and clicked interpolate
for missing values but this doesn`t seem to work for the stacked area
chart...has anyone else found this? Has anyone found an acceptable work
I`d be interested if anybosy has found anything similar, thanks in advance
for any help.
what do you want it to plot?
> Hi all,
> I have been creating graphs using the ...Cell format protection
I have certain cells locked in a protected worksheet. The spreadsheet is
used by others who input data in unlocked cells and return to me. My
problem is that when they copy & paste something, they are eliminating the
formats I have all ready set (border, allow numbers only, etc.). Is there
any way to prevent this, while still maintaining the protection of the rest
of the locked cells?
...Text box embedded in xl chart doesn't print
Hi, I have a text box that I would like to overlay on a chart to hide the
contents. I've selected the chart before drawing the text box to ensure it is
embedded, but when I print to a pdf, it appears that the text box gets
resized to sit at the top of the chart. Does anyone have any ideas as to how
to fix this? Thx
...\\.\backofficestorage\domain is pointed to wrong domain
In setting up Exchange to run through ISA, I somehow screwed up the domain
listing of Exchange.
Eversince the virtual directory for exchange local path has been moved to
Does anyone know why this would happen, and how I can change this back?
I tried the obvious which was edit the path to be
but that didn't work so well. I then deleted all virtual directories, and
edited the metada.XML file to set the value to 0 (KB888033) Restarted
services and the directories recreated. However Exchange local path is
still wron...Org Chart Templated
When building an org chart, name and title automatically show up, but I would
like to add other details such as salary; how do I do that? I tried the shape
data, but can't get it to display on the actual shape. I was thinking that
building my own template with the data that I wanted would be useful, but I
can't figure out how to do that. Please help!
"Jacqueline" <Jacqueline@discussions.microsoft.com> wrote in message
> When building an org chart, name and title automatically show up, but I
...Delete accounts numbers ftom the chart of accounts
I would like to know how to delete or reset my accounts number in the chart
of accounts in once in Microsoft Accounting profesional 2008
MA, this is a GP forum. You might want to try a MAP forum.
East Coast Dynamics
Can anybody find what is wrong with this code? It will just make a
empty chartobject. I believe the ranges are ok, it probably is some bad
syntax or object reference...
The code should make a chart with two series of xlColumnClustered and
one serie of xlLineMarkers.
Dim cht As Chart
Set cht = Sheet1.ChartObjects("R_CF").Chart
On Error Resume Next '(if no chartobject)
On Error GoTo EndCode
'Left and Top location = named ranges
With Shee...excel chart size using inside positioning
I am trying to standardize the sizes of multiple embedded charts so I can
copy the charts into Powerpoint. I can set the PlotArea
..Left,.Height,.Width,.Top numbers, but the left inside gridline of the chart
still shifts a little inside the PlotArea, which I assume is related to the
read only InsideHeight,InsideWidth, InsideLeft, InsideTop numbers. If you
want to set the constant dimensions of the inside area, does anyone know a
way to iterate through each chart to make these adjustments?
Anyone responding to this may first want to check if there are any
responses to the multi-pos...Confine results of web query to one cell
How do you confine the results of a web query to one cell in Excel 2004?
Under Excel 2004 a web query always seems to use up two cells in a given
column no matter what data range properties I set. I never had a problem with
this in Excel 2000.
...can I sort colored cells?
Can I sort a column that some cells are colored "red" and and some "yellow"
in the nearby columns seperately via VBA?. Please provide a sample code that
does the job. Thank you for your time.
with this code (paste in a module VBA)
Function MyColor(CkCell As Object)
MyColor = Abs(CkCell.Interior.ColorIndex) ' not for the conditionnal color
In a diff�rent colum, you type = mycolor(A1)
and you sort by this nex column
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/...Chart non consecutive data
Is it possible to chart non-consecutive data. I haven't been successful in
my attempts so far. Data is in same row, ie. row 4; columns needed are H4
and J4 (need to be stacked), next series is K4 , L4 & M4. Unfortunately, I
can not rearrange the cells to make this easier.
Any help or suggestion would be appreciated. I haven't done that much
charting with Excel (2003).
XL doesn't stack data in the same series. It stacks one series on top
of the previous.
You can simulate the effect you want as follows.
Select H4:J4 and create a stacked column chart. In step ...Celling formatting failing
I am having an unsual behaviour and am trying to track the cause. In
excel 2000 I am entering the date 17/12/1969 in a cell e.g. B2 then a
new date 17/12/2004 below it in C2 then lastly third a date 17/12/2005
I then highlight the 3 cells which show the date exactly as entered
above. I go to Format > Cells and change on the number tab the
category from General to date. I then select the desired type (in my
case being 17-Dec-69 in the first dates case).
The behaviour I see is that the Sample preview above the types field
does NOT change to match the selection. Nor does it ...Excel log/log chart
Using the previous version of Microsoft Excel (Excel '95),
I was easily able to produce a log/lock chart, using the
scatter chart as a starting point, without any problem
whatsoever. This included placing two and more series on
the same chart. With the new version that is installed on
my machine (which is Excel 97), I can no longer complete
this rather simple task. Does anyone know how to produce
a log/log chart of two and more sets of values (using X-Y
My Desire Is to Have One Set of X-Y values with another
set (A-B) of values as well as a third set of values (M-N)
p...help on macro for making chart
i want to make a plot using macro where I want my x-axis to be the
value from the same column but random rows for example
R18C3,R19C3,R21C3,R23C3,R25C3,R27C3 ( only rows are changing)
and my Y-axis should also be something like this
R18C5,R19C5,R21C5,R23C5,R25C5,R27C5 ( only rows are changing)
For one plot It is working but i do not know how i can plot for other
the code looks like this
' Macro2 Macro
' Macro recorded 3/30/2007 by Roger
' Keyboard Shortcut: Ctrl+m
ActiveChart.ChartType = xlXYScatterLines
...Highlighting Filtered column
I have a basic filter on an excel sheet. I would like to highlight the
column in which the filter was selected. Can anyone think of a simple
way to do this without having to resort to Macros (there are security
issues at work, hence Macros can be awkward)?
My first line of thought is to somehow detect when the filter has been
selected and on which column and then use conditional formatting to
highlight the column. However, I can't find a way to easily detect the
filter status. Presumably in VB code I can find the filter and the
appropriate property but I would rather not use a Macro.
Tha...How to copy a chart between workbooks?
Another guy in my office has a nice chart which I want to use in my own
weekly report. He has it posted on a shared network drive. How do I copy his
chart into my workbook? I'm using Excel 2003.
Thanks in advance,
Open the workbook he posted then select the Chart or Chart Sheet and Chart>Chart
Type>Custom Types>User Defined>Add this to the List of User Defined Charts.
This will add the Chart Type to your xl8galry.xls workbook which you didn't even
know you had<g>
You then use that chart type as your base for your reports.
Gord Dibben MS Exce...Stacked Column Chart #4
Date Event type Total
01-01-2006 A 10
01-01-2006 B 15
01-01-2006 C 12
02-01-2006 A 5
02-01-2006 B 7
02-02-2006 C 8
03-02-2006 A 5
03-02-2006 B 15
I would to generate a automatic stacked column (without having to mak
manual selections) with the example above.The final result should b
the date in the x axis and the column composed by the event typ
(A,B,C) with the respective total.
Note: the information is displayed as shown above.
How can i do this?
vilacova's Profile: http://www.ex...