Help required ... please see email below.
Trying to remove menu command created by mistake!
>Thanks for your help, problem sorted. Having run
>file twice I now have 'Find Links' twice on my menus, any
>ideas on how to delete one of them?
>Thanks for your help
>>try the following add-in to find/delete these links:
&g...Copy Userform ListBox AND TextBox values
How can I copy the values from ListBox1 and TextBox2 from the same Userform
into the same cell on a worksheet?
I have the code to copy either one to the correct location but I need to
merge the values from both, seperated by a slash (/). I have tried using the
following but it will paste "FALSE" into the appropriate cell:
.Value = ListBox1.Value & " / " & .Value = TextBox2.Text 'copies data
to column B
Traa Dy Liooar
Ignore last - I have managed to do it.
Traa Dy Liooar
...Excel Data Querry using criteria from Cell
Hello, I have created a data query in Excel using DATA - IMPORT EXTERNAL DATA
- NEW DATABASE QUERY and then selecting Access and browsing to an query
within an Access database. This query returns all data into excel, but I
would like to limit the criteria based on what a user has typed into a cell
in the Excel workbook. I thought this could be accomplished by clicking DATA
- IMPORT EXTERNAL DATA then PARAMETERS but the PARAMETERS option is grayed
out. I can select EDIT CURRENT QUERY, but this just brings me into the
Microsoft query, where I don't see any options to query based on...Prevent change to refs in second worksheet when drag cells in firs
I have a complex calendar in Excel. Each week, admins Ctrl-drag cells among
different locations in the primary calendar worksheet. I have a second
worksheet that needs to list those cell values in a fixed configuration, e.g.
the value in Sheet1!A1 needs to always appear in the cell of Sheet2!G10.
Sheet2!G10 contains the formula: “Sheet1!$A$1”. If the user drags Sheet1!A1
to Sheet1!A3, the formula in Sheet2!G10 gets automatically updated to
“Sheet1!$A$3”. I have tried all combos of locking and protecting to prevent
this updating. Is there a way to do this?
Try referencing the other shee...Excel 2003 not understanding Access 2003 "like"
I have a number of Access queries linked and displayed in an Excel workbook
by way of Data, Import External Data, Import Data. Some of the criteria and
select statements in the queries use the keyword "Like" (e.g. Like "*Smith"
to pull up all names ending in "Smith"). These statements seem to be
completely ignored by Excel so that records I should see are not appearing in
the workbook. This worked fine in versions 97 (from which we've just
upgraded) so is this a version 2003 bug? If so, is there a fix?
...Change 2007 excel Autofilter back to 2003?
Does anyone know if there is a way to change excel's 2007 autofilter
functionality back to like excel 2003 autoflilter use to work? I need to
quickly bring up like values and compare other columns based upon the
filtered values and the extra clicking of the check boxes is driving me nuts!
If it helps any (and if you haven't thought about it yet), you can click the
"(Select All)" entry twice to remove your current selections.
Rick (MVP - Excel)
"jonnybrovo815" <firstname.lastname@example.org> wrote in message
news:36837406-1...publishing images with Excel workbook
I have created an workbook with Excel and put a photo on the first page. when
I publish the workbook as an web page (interactivity) my photo is missing.
Anyone know what I am doing wrong?
I have try everything I know to do = insert picture, putting copying photo
to clipboard and shift, pasta picture and still logo is missing.
...How do I create a Cost Volume Profit Graph in Excel?
I was wondering if I could get some help on how to create a CVP graph in
A cost volume profit shows how costs, revenues, and profits vary with volume
(sales). You can either plot total cost, or fixed and variable costs, which
add up to total costs.
One way to show this is to make a break-even chart. Put unit sales (number
of items sold) in the first column, fixed costs in the second (which are a
constant), variable costs in the third column (these are typically a
straight line through zero), and in the fourth insert formulas that sum
fixed and variable costs to make total ...can I print selected cells only within a worksheet
I have designed a simple template using text only for a unique advice note. I
want to be able to add variable information within this template but need
only for the variable information to print onto a pre-printed advice note. I
do not want to hide the template as I need to see exactly where to insert the
variables but I do not want it to print. Anyone help? Thanks.
Maybe you can use this ?
Regards Ron de Bruin
"martin hanley" <martin email@example.com> wrote in message
news:AA062677-3...how can I split a single cell diagonally in Excel 2000
Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?
As far as I know, you can not split a cell diagonally so that it can contain
2 pieces of information. However, you can merge cells which might give you
the effect that you want. To do so, go to the standard toolbar and hit
Format -> Cells -> Alignment Tab -> Text Control and work with the merged
> Anyone out there know a way to split a single excel ce...Reading ranges and copying data from Excel when it is not open
Is there a way in code to copy data out of an Excel file even if Excel is
not up and running? If Excel were open, I'd copy, say, the first 30 rows
and paste the info to PowerPoint. Then, since rows 1-5 are for column
headings, I'd hide rows 6-30 and copy a new range which would look involve
30 rows, but since rows 6-30 were hidden would be 1-5 and then 31-55 as a
I am trying to do this in VBA without opening Excel and instatiating
objects, etc. Is it possible? What VBA commands would I use?
You would need to treat the excel file as a database and use ADO to g...Mode Indicators in Excel?
A good example of a missing mode indicator one for whether th
calculation mode is set to manual or automatic. Isn't there any othe
way to find out other than going to the Tools>Options>Calculatio
dialog? This has messed me up almost any time calculation gets set t
Another example is that trying to use stored Custom Views for filtere
lists gives the error "Some view settings could not be applied" on som
worksheets (usually complex ones), but works OK in others (usuall
simpler ones). I know sheet protection is one thing that can caus
this (which itself has no mod...Frontpage 2003 network link
Question: for the life of me I can't remember how to create a network link to
my website so I can open it directly in Frontpage. Meaning... If I want to
edit my webpage in frontpage 2003 directly instead of using my local copy of
the website. How do I create a link on my computer and put it on my desktop?
I, know this is probably an easy thing for you "brainies" but I can't
remember how to do it. Please assist.
There are two ways:
Open FrontPage and use File->Recent Sites
This option will keep the last four websites opened.
Opening the website in FrontPage ...Chart drawing problem in Excel 2003
Over the last few months I have had the same problem in excel with all
charts where I've used a two colour fill effect for either a data series or
background. When I use this feature the entire chart is only viewable in
black and white and excel takes a long time to actually draw the chart.
However if I print the chart or even copy and paste into excel all the
colours are as they should be.
The mpeg moving shows how excel draws an example chart when the chart sheet
and to see how excel prints to pdf see the pdf belo...Auto Filter
When using the filter only the first 1000 unique entries in a list will appear when you click on the arrow. I have
more than 1000 unique entries [ie. company names] that I would like to see when filtering. Is there any way
of being able to accomplish this?
you may have a look at
for a workaround
> When using the filter only the first 1000 unique entries in a list
> will appear when you click on the arrow. I have more than 1000
> unique entries [ie. company names] that I would like to see when
> filterin...Excel cant SAVE added data?
This is a copy/paste with minor edits from post submitted
Excel 2000 ... I have a single page spread sheet (my
own) ... built in Excel 2000 (still Excel 2000) that was
After expanding the spread sheet to handle more
equipment I received error message stating:
Excel can not SAVE all of the added data & formatting ...
Here I had the option to select OK without fixing ...
CANCEL ... or ... HELP. I selected HELP & ended up on a
blank HELP Page ... So now I am turning to this board.
Anybody know what gives? Could I be running into a
formatting limit i...How to Link to the next blank row after the last entry in a column?
Cell BM6 Sheet1, has a formula that gives me a numeric total.
The total belongs in Column D1 Sheet2 after the last entry, and there
will be cells that will remain blank in that column before the last
Sheet1 is a work sheet, which will be saved with a new file name at the
end of the month after the totals have been sent to Sheet2. Sheet2 is a
permanent, ongoing record.
The numbers on original Sheet1 will then be erased and the worksheet
reused for the new month.
:confused: How do I get the values into the appropriate row of Sheet2
and have them remain there when I reuse the workshee...Coloured wheel of death with excel
Operating System: Mac OS X 10.6 (Snow Leopard)
I get a coloured wheel of death every time i use excel from office 2008, almost every time I type into a cell, for about 3 - 6 seconds. I've looked on here and there seems to be a lot of discussion about hp drivers, but I don't have an hp printer. I'm working in normal view. Can anyone help?
First, be certain that both Office (12.2.3) & OS X (10.6.2) are fully
updated. Run Disk Utility - Repair Disk Permissions, then see if things
improve after a restart of your Mac.
If things are still ...Worksheet hangs
My workbook freezes whenever I try to use Data>Subtotal directly or through
a macro. Why does this happen. When I deleted ALL macros there was no problem.
Any suggestions. If all my macros have to be deleted before using
Data>Subtotal, is a code available and how can I prevent the file being saved
after the macros
have been deleted.
Thank you in advance.
So sorry, even when the macros are disabled, the problem persists.
Disregard my post. Seems to work now. Have to identify earlier
...Excel cut/Paste Problem: Year changes after data is copy and paste
I am using Excel 2003, and here is the problem. I have an Excel sheet that
contains financials. Different departments need different sections of the
data, so I copy and paste out only those sections they need and paste it into
a new Excel sheet. The colums are broken up into dates, and formated to show
date-year (Dec-05). For some reason, when I copy and paste sections, the date
will change, for example Dec-05 will change to Dec-01. I have to go thru and
manually correct all the dates. Can anyone tell me what is causing this?
.. maybe the cells in the New worksheet are preset to a c...EXCEL Decimal changes during WORD Merge
Why does Excel change 16 cents into .1599999 in a merge process
Have not had this problem until we upgraded to 2003?????
I have tried different cell formats in Excel
Number - currency - accounting - custom - all with the 2 decimal places
text - but rather not lose numeric functions
(am re-entering figures by hand and using text format today to finish
merged letters - - ugghhh!)
I have had a similar problem in previous versions of Excel as well, not just
Office 2003. Is the data in Excel coming from an outside source like a non
Microsoft database query?
I run into this probl...Copy/Paste with Hidden Rows/Columns Excel 2007
I am working with rather large & detailed spreadsheets. I have hidden rows
and columns with supporting details that feed into the viewable results
I need to take the “zipped up” data and copy/paste to a new worksheet. When
I paste the data, it appears with all of the hidden columns and rows visible
Is there any way to paste the zipped up data without the reappearance of the
previously hidden rows and columns?
Can you paste a link without all of the hidden data reappearing?
Select range to copy which includes hidden rows and columns.
F5>Special...Excel XP automatic equals sign when formula bar clicked
In Excel 2000, you could click on a cell, then click on the
formula bar and an equals sign would pop up in anticipation
of a formula to be written. How can you make Excel 2002
duplicate this behavior?
This was removed from Excel 2002 onwards.
The closest you'll get is:
View > Toolbars > Customize
Under the Insert list you'll find "="
Drag it to a toolbar near the formula bar.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
&q...Date tracking on worksheets
A friend wrote with a question (below) about date tracking on individual
worksheets within a workbook. I know a little bit of Excel, but this is way
beyond me! Any ideas out there?! Thanks in advance....Rick!
"is there a way to make each tab of a document, like for example one
document 5 tabs, automatically date the tab each time u open it. she want to
track the activity on each tab, not the document in its entirety and was
wondering if that was possible?"
I was thinking that maybe it needs to date it when you exit the worksheet,
so that the next time you open it, it will show th...How do I link pictures in visio 2003?
I have a diagram of a room. I want to link blocks (squares with the name of a
specific rack) to a diagram of that specific rack?
If the rack diagrams are in different files than the room diagram, you could
use hyperlinks. If all the diagrams are in the same file, you can use
either hyperlinks or set the double-click behavior to jump to a specific
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <Ron@discussions.microsoft.com> wrote in message