|
|
Code writing assistance in VBA by
Ron Green
I have received input from Paul B., Gord and Peo on this matter, but I am a total novice with respect to macro functions and writing code.
I need some help to...
|
May 28th, 2004 12:11 PM
by CLR
|
1 |
491 |
|
|
Linking... by
Oedi
I have a main workbook that lists all the accounts.
The accounts are each seperate workbooks. I'd like to know if I enter
information in a cell on the...
|
|
2 |
360 |
|
|
Excel VBA-Geting data from Access by
kodricales
My problem is that I don't know how to connect to an Access database
from Excel. I'm modifying a macro in which I have to compare some
strings in Excel cells...
|
|
2 |
898 |
|
|
Changing language in Excel by
Astron Pantingtons
Hi
My Microsoft Office seems to be in German, is there a way of changing
it back to english?
I've been to setlang.exe, but its in german, and nothing I do...
|
|
1 |
436 |
|
|
conditional formating by
Ian@visualise
I want to format cells so that if they contain a letter i.e. "r" they will have a fill colour no matter what else is in the cell i.e rota in the cell turns it...
|
|
1 |
376 |
|
|
Can't find Excel anymore on computer by
Blake
I have windows 98 se. I know excel was on my computer when I bought it. But I can't find it. My cd drive is broken so I can't reinstall my windows cd. I'm now...
|
|
5 |
494 |
|
|
Looking up words by
Lea
Hi,
I'm collating survey responses where the clients have been
allowed to write comments in their own words. I now need
to collate the comments into...
|
|
3 |
451 |
|
|
Protection - Autofilter by
George Gee
Hi all
Is it possible to protect the contents of a range of cells (Tools
Protection etc.),
but still be able to use 'Autofilter' on these cells?
Many...
|
|
6 |
393 |
|
|
Hyperlinks to folders? by
Excel-newbie
Can cells hold hyperlinks to folders? We are using excel
to track work requests. We want to have a cell that links
to a folder, containing any documentation...
|
May 26th, 2004 05:42 PM
by
|
4 |
305 |
|
|
linking pages in two different work books by
modicum21
trying to link two different pages in two seperate workbooks.
filling in statistical data in first workbook in
specific fields. then having to open the next...
|
May 26th, 2004 05:06 PM
by 123
|
2 |
511 |
|
|
Having trouble with one column formula by
Deb H
I can't figure out what I am doing wrong. I am adding
figures in a columns. I've entered the same formula
(with the appropriate column letter) and it works...
|
|
2 |
643 |
|
|
Formulas by
Bob
I have 10 worksheets in a workbook. One of the sheets is a totals
sheet that will show the totals from the 9 other worksheets and the
total them.
What does...
|
May 26th, 2004 01:08 PM
by Bob
|
3 |
388 |
|
|
Opening Files* by
Rube
When I open an Excel file only the blank Excel screen comes up. Then I have to go to open and find it etc. How do I set up so files automatically open in the...
|
|
2 |
469 |
|
|
Preventing date conversion in cells by
peter delamere
I often need to copy and paste data from internet sources into Excel. There
is usually no problem with this except when it appear to have a date format
eg 2-1...
|
May 26th, 2004 12:05 AM
by CLR
|
2 |
476 |
|
|
Message for Paul B. by
Ron Green
Please see additional question under "Spell Check in Text Box while protected"
|
|
2 |
409 |
|
|
Excel by
Ariane
I have an excel worksheet, that has about 1000 contacts
and need to print it on labels, is there a way to convert
this worksheet in a word document and then be...
|
|
2 |
317 |
|
|
Spell Check in Text Box while protected by
Ron Green
I have created a spreadsheet for our employees to use that includes several text boxes for their narrative. The spreadsheet has many macro functions and...
|
May 25th, 2004 08:23 PM
by Paul B
|
4 |
720 |
|
|
How to do header row? by
Marianne
How do you make a row a header row? It can be done in a
Word table, but I can't find any option in Excel for
defining a row as a header row to be repeated at...
|
|
3 |
392 |
|
|
macro disabled by
Mo. bannayan
Hi there;
well I got a file from a friend which contains a macro, but when I open it a
message pop in as the macro is disabled and I should change the...
|
|
2 |
303 |
|
|
Multiple Document Windows by
jerry
I'm a new user to Excel 2000. Unlike Excel 97, 2000 generates a new window every time a new document is open. Is there a macro, as I discovered for Word,...
|
|
4 |
654 |