I have an excel 2003 file which contains relatively simple macros. My problem is that unprompted by the user excel will open Visual basic while this file is...

Hi, Is it possible in Excel (preferably not by using macro's or VBA) to make the data in one column unvisable unless a password is entered? regards, marieke

Hi I am using Excel 2002 (In Australia) - the currency symbol displayed on the toolbar is a Euro and it should be a dollar $ symbol. How do I change it? My...

Hi. My first attempt at using a Pivot Chart in Excel 2003 was to display a graphical count of unique items in a column. It worked great for that purpose...

I have a C# add-in for Excel that creates a toolbar. I open the excel embedded in an application. If the toolbar is floating and I give focus to another...

I would like it to display the results of a cell formula in the same format that is in the referenced cell. For instance (simplified): Cell A1 is formatted in...

A formula that: Finds the first number in the row bigger that "10", and when it finds it return the value on the same column but on row 1 (for the next row...

I have a list of names, listed as LAST, FIRST, MI. The Middle initial is optional, and I would like to remove it for the purpose of creating a lookup from...

Hi! I often use stacked column-chart in Excel 2007. I normally show the data labels in the chart. Usually I have 2 or 3 data-series. Is it possible to...

I've done the below formula but would like to omit zeros. How should i proceed from...

Is it possible to copy information from Excel and then paste link it into an Outlook message so that when the source file changes the information in the...

Hi, i have this code: =sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100) This code retrieve numbers. I need a code, just like...

I have two excel spreadsheets in 2003. I want to search the main spreadsheet for certain ID code. Once that code is found to dump the associated information...

Hi, i have two dropdown list in A1 and B1. A B john b32 mary b66 jim b55 cris b88 i need to link somehow this two dropdown list, so...

I have two sheets, one for actuals (as they happen) and one for budget data. I have another sheet which shows actuals to date (by month) followed by the...

I know about the wrap text function in Format Cells, but how do I force a line break at a given point in a cell ? Kind Regards, Fedtmule And

I used conditional formatting property for one row such that if $M$2="X" then apply formatting to $A$2:$O$2. That formatting rule works. Now I want to apply...

Hi, I asked this question before, and got the advise to use macro's. Is there another way? And if not, how should I build up my macro so that this goes...

Hi! Can you help me with a macro to copy and paste a cell x number of times dependent on a number that is entered into a cell. Ex: If A2 = 2 then cell B2...

Example On another Sheet: A B BEM 06T19 BFN 09S09 BEM 03R02 KIM 96R01 Now on another sheet I want a table that if I select BEM from a drop...