| Thread | Last Post | Replies |
|
| vba worksheet and range | 10 May 2006 10:16 GMT | 3 |
Two small question: 1. How can I make sure a user can't delete a worksheet. Since I constantly make new sheets and delete hem myself this should be in VBA and must not interrupt with my own deleten en making worksheets. So it
|
| Excel Bar Graph | 10 May 2006 09:14 GMT | 1 |
I have two sets of data on a bar chart but want to differentiate between the two by different colors. Is this possible? I have 5 sets of data. I want 3 to have a blue bar and the remaining two to have a red one. Thanks.
|
| Newbie seeks suggestion on recording new macro to print sheets | 10 May 2006 06:53 GMT | 2 |
Hi there, I want to click on a button (created from form), then the print window appear. I did the following steps: created a button; recorded new macro;
|
| how to implement such function | 10 May 2006 05:49 GMT | 5 |
the function is sum the number of positive for example input 5 column 3, 0 , 4 ,2, 0 result : 3
|
| Key in Date and time | 10 May 2006 05:36 GMT | 1 |
How can i code the fields with mm/dd/yyyy hh:mm. so that when i key in i just key in numbers don have to worried about the the slashes and colon. Thanks.
|
| excel -10 sections - footer needs to say "Section # Page # | 10 May 2006 03:02 GMT | 2 |
I have a 10 section worksheet that I need to have a footer that says Section # page # on each page for printing the whole worksheet. eg Section 1 Page 10 would the page 10 of the whole worksheet: Section 3 Page 59 would be page 59 of the whole worksheet
|
| Cell format - how to disable auto date | 10 May 2006 02:34 GMT | 2 |
I want the cell to be "3 - 5" but it auto changes it to "5-Mar". How do I stop that from happening besides using '3-5 ?
 Signature KH_GS
|
| limit of setting conditions | 10 May 2006 02:10 GMT | 2 |
Hi friends I have 26 different kinds of materials and each one could have nearly 200 different type of processing. That is to say for instance, I have column A holds 26 different kinds of material and column b holds 200
|
| Shortcut Key for delete? | 10 May 2006 01:59 GMT | 2 |
Is there any keyboard shortcut for deleting a row? Instead of right click delete.
 Signature KH_GS
|
| Creating a Random Lottery | 10 May 2006 01:53 GMT | 2 |
I have been tossing around the idea of how to use Excel to simulate a lottery drum for picking prizes. I have to pick out random drawings monthy for prizes and have been placing tickets with names into a fish bowl. I have to say this is very anoying and time consuming.
|
| How could I forget this formula? Help please | 09 May 2006 23:58 GMT | 7 |
Good afternoon, Alright, here's a simple one. How I have forgotten it (when I use it almost every day) is beyond me. All I know is that my mind is mush right now.
|
| IF(ISNUMBER.... problem | 09 May 2006 23:27 GMT | 4 |
I can't seem to figure this one out. I am trying to make either a checkmark, someones intials or a check box (reall doesn't matter which but check mark would be best) appear in a cell when three other cells in that same form contain data. The cells that need to be searched
|
| Automatic E-mail Notification | 09 May 2006 23:15 GMT | 12 |
I have a spreadsheet where I have to select a macro button to run a macro that will automatically update the data in the spreadsheet from a text file that is being updated every 15 minutes by my company's MRP system.
|
| VLookup/Data Validation | 09 May 2006 22:29 GMT | 1 |
Last week I posted for help w/VLookUp, Data Validation or anything that would populate a spreadsheet based on a criteria. I don't think I explained correctly or gave enough information, so I'm desperately trying this again - I need so much help.
|
| Formula bar and name box not shown | 09 May 2006 21:08 GMT | 2 |
Please tell me what to do in Excel Spreadsheets
|