| Thread | Last Post | Replies |
|
| Email Address' in Cells | 13 Dec 2006 10:49 GMT | 1 |
I want to type in a number of email addresses into one cell as a hyperlink, but when I click on cell it only creates an email with 1st address listed and ignores the rest. I have a heap of worksheets that I want to send to a nymber of different
|
| The case of the disappearing macro | 13 Dec 2006 03:12 GMT | 4 |
I'm having difficulty understanding how templates relate to .xls docs. For instance, I created a new doc which very evidently is based on my book.xlt file in the xlstart folder. Yet when I go to File/Properties the template designation is grayed out.
|
| Macro for e-mailing cell range | 12 Dec 2006 22:12 GMT | 1 |
I created a log in excel to manage our incoming documents and need to get a macro that will bring up a new outlook email with the subject as the name of the workbook and the body of the email as the text inputed with in a cell. I can get it to automatically email the entire sheet,
|
| Button on sheet: ? VB code to add date in active cell | 12 Dec 2006 22:06 GMT | 8 |
I placed a button on the sheet and would like to know the VB code to add the present date in the active cell. I did a group search, but not not find anything. Bart
|
| File DMEODMA.xla not found... | 12 Dec 2006 21:57 GMT | 4 |
When I try and open a file in Excel, using File -> Open, I get the following message... "The file DMEODMA.xla not found." The open file dialogue does not appear so I can't open a file.
|
| Clear Autofill List | 12 Dec 2006 21:20 GMT | 4 |
How do I delete individual values or the entire autofill list? Thanks for help. Robert
|
| Restrict Data Entry | 12 Dec 2006 21:07 GMT | 1 |
Is there any way to restrict the number of characters that can be entered into a cell. I know with Data Validation, that if a character limit is exceeded, one will get an error message. What I would like to do is set up the cells so that once the character
|
| Need to get from Excel to Word ...somehow! | 12 Dec 2006 19:48 GMT | 3 |
I put out a weekly newsletter that compiles information from varioius websites, a portion of this is developed from Excel. ...I start sorting as many as 30,000 articles and winnow it down to 85. I wind up with one column that I need to transfer to HTML and have it where I
|
| Need Help creating a formula****PLEASE | 12 Dec 2006 19:33 GMT | 5 |
I am a manager in a big office where agents log into their phones to get calls. We keep track of how many minutes an agent is "logged off" of their phone system. I would like to be able to have a formula to use in Excel to speed up the calculations for this info. Here is what
|
| Annualizing Revenue Received | 12 Dec 2006 17:51 GMT | 1 |
I have a report where I pull in revenue posted by month for the current calendar year from another Excel worksheet. Jan gets posted into column AA...Dec in AL. I use sumproduct because I want it to match the client code and the month. I need to annualize the amount we have ...
|
| What can cause Excel to crash? | 12 Dec 2006 16:19 GMT | 1 |
Excel (2002 SP3) crashes regularly on several of my model, most of the time when I open the spreadsheet. Was wondering what could cause this unstability. The main model I use is specific in the following way: - more than 500 range names are used
|
| Excel 2003 suddenly won't launch? | 12 Dec 2006 15:11 GMT | 5 |
Out of the blue, when I now launch MS Excel 2003 (WindowsXP|SP2) I get the MS Office Install dialogue box (?) which then fails to then find a file SKU112.cab???!! and asks for my installation CD. Not only do In not have the CD with me (it's locked away in a box 2500
|
| Gridlines disappear when applying background cell color | 12 Dec 2006 14:59 GMT | 3 |
I haven't found a way to do a very simple thing - retain cell gridlines when applying a background color to cells. Surely there must be some endemic way to do this. As it is, sections of my pages have gridlines and other sections do not.
|
| Filename containing cell values | 12 Dec 2006 14:30 GMT | 1 |
Has anyone experience with passing cell parameters to a file name using a button and VB? I have a spreadsheet I am using to send out to multiple individuals to collect data and need a consistent format to help manage the files that I will be receiving via email.
|
| Is it possible to make pasting not allowed? | 12 Dec 2006 13:28 GMT | 12 |
Is it possible to make pasting not allowed (the cells are un-locked, but the sheet is protected)? Bart Excel 2003
|