| Thread | Last Post | Replies |
|
| Inactive Form Controls | 08 Sep 2006 16:31 GMT | 2 |
I am having some issues with form controls in Excel 2004 for Mac. I opened a document made in Excel 2003 for windows that contains drop down menus. When I try to use the drop down menus, clicking on the drop down arrow chooses a cell behind the drop down. How do I go about
|
| Excel file will not open | 08 Sep 2006 11:25 GMT | 3 |
Who may support me? I use excel 2004 and suddenly (I guess after update) I can not open some excel files. If I transfer the files to a PC it will open with no problem.
|
| Excel for Mac selection color | 08 Sep 2006 03:24 GMT | 1 |
It is hard for me to see which current cell is selected in excel. The color is too faint. How do I change it and make it darker? Thanks!
|
| loss of all formalea ina worksheet | 06 Sep 2006 20:58 GMT | 2 |
Have recently come across a very strange and exceedingly annoying excel behaviour. I spent half a day putting together a complicated analytical template. When I finishned I copied the relevant sheet into a new (single sheet) workbook to send to a colleague. However, when I
|
| file open | 06 Sep 2006 19:50 GMT | 1 |
im writting a macro in excel which requires that i import data from a txt file. ok. the txt file changes on each ocaasion. how do i from excel tell the macro which file to open and from which location. pls help thnx.
|
| runtime error 1004 saveAs mac Text file | 05 Sep 2006 20:06 GMT | 1 |
I get a runtime error on the ActiveWorkbook.saveas line. I want to save the file as a Mac text file (19) I would like it to have the .txt extension. I would like to have the date and time appended so that it doesn't write
|
| Automatic control of line properties | 05 Sep 2006 05:18 GMT | 1 |
I want to make several line graphs with 100s of lines, but Excel (as far as I can tell) puts all lines as 2 pixel default thickness. Then, it makes me change line or color one (slow!) line at a time. How can I tell Excel that the default should be the thinnest line is
|
| Chart Question | 04 Sep 2006 06:16 GMT | 2 |
I wanted to draw a line chart. No big deals. But: The line always shows a light grey shadow below
|
| message box syntax error | 02 Sep 2006 19:15 GMT | 4 |
I have a form with 3 option buttons with different procedures in each. If the user picks option 1 then I want it to do 2 procedures and give the user a message box. Something is wrong with the message box. I just want it to print a message with the report date from two ...
|
| Syntax error with arrays | 02 Sep 2006 19:00 GMT | 5 |
I am trying to compile code that I have had working for over 10 years in excel for windows. It is in Visual Basic and is really annoying that it wont work in Mac. Function someFunction() as string()
|
| applescript to resize font of all non-empty cells | 02 Sep 2006 12:39 GMT | 6 |
I spent about an hour tonight trying to write a small applescript that will take each non-empty cell in an excel 2004 workbook, and change its font size to it's current font size + 3. To get a list of cells, i tried this:
|
| user form keeps running after option + okay procedures performed | 01 Sep 2006 21:52 GMT | 1 |
My form works. If i pick an option it calls the procedure. There are several problems. One is after I choose cancel it closes the form but excel doesn't come back. I have to force quit Excel. everything in the menu is grayed out. I think the form is still running. How do ...
|
| Excel Mac to pc and back. | 01 Sep 2006 16:02 GMT | 4 |
I have networked from my Mac to my PC with a 75 ft cat5 cable. The Internet reception on the PC is very strong and fast,100Mbps. I can't, however,figure out how to exchange Excel files, and other files, between the two computers. I have Word Offfic on both computers and
|
| Replacing row values | 01 Sep 2006 11:02 GMT | 8 |
I have a macro with the following included: iDataRows = Application.CountA(Range("A:A")) ActiveCell.FormulaR1C1 = _ "=SUMPRODUCT(--(LEFT(R2C1:R170C1,2)=""AP""),--(R2C7:R170C7=""Reactive""),
|