| Thread | Last Post | Replies |
|
| Pointer displays Hourglass? | 23 Mar 2006 14:28 GMT | 1 |
Dear Excel experts, I have a hourglass displayed as pointer after the following events: Double clicking a textbox of a Userform(1) opens a new Userform(2). When I close Userform(2) the focus goes back to the textbox of Userform(1) (as
|
| VBA Print code????? | 23 Mar 2006 14:18 GMT | 2 |
Can anybody give me the VBA code for a command button that will prin the active worksheet and also give the user the option to select ho many --
|
| how to find if multiple chart objects are selected? | 23 Mar 2006 14:14 GMT | 2 |
how do i find if multiple chart objects are selected by the user using the ctrl + click mechanism? chiman
|
| Code not woring - please help!!! | 23 Mar 2006 13:21 GMT | 4 |
I tried posting this yesterday, but my post seems to have disappeared, so if this is a repeat I appologize. I have a macro that someone else wrote and i'm trying to add to it some formatting and summary data at the bottom after the details section,
|
| Multiple Saving | 23 Mar 2006 13:01 GMT | 2 |
Please help... I am trying to save one workbook into 2 separeate excel files. I want to try and save one worksheet as one file and delete other sheets, then go back to my original data report and save another worksheet as a text
|
| go to far left worksheet | 23 Mar 2006 12:12 GMT | 2 |
I will be grateful for a piece of code to take me to the furtherest worksheet on the far left (in the base of the workbook where the sheet tabs are displayed ie, the furtherest tab on the left) in a workbook with many sheets many thanks
|
| Close button userform | 23 Mar 2006 12:02 GMT | 1 |
Dear Excel experts, Does clicking the Close button of a Userform actually unload the object (like Unload Userform1) or do I have to use the Unload statement to actually remove it from memory?
|
| Save workbook via Command Button???? | 23 Mar 2006 11:11 GMT | 3 |
I have a workbook with a command button and need to save the workbook with a date as the file name. The date is in cell "A5" and the file I need to save it to is "Midtown Farm". Can anyone help please???
|
| Passing sheet names to an array | 23 Mar 2006 11:07 GMT | 3 |
I am passing sheet names to an array. 4 sheets from one open file and 4 sheets from another open file. I open the second file in the routine using the GetOpenFile stmt. I have named the sheets in VBA. What I am trying to do is pass the Name property of the named sheet to the ...
|
| Code execution has been interrupted | 23 Mar 2006 10:02 GMT | 3 |
Do you know why I'd be receiving this error when running an exce macro? It occurs at End sub. This is my code: Sub OpenInpSpread()
|
| Workbook wont go away! & OUT OF MEMORY error | 23 Mar 2006 09:49 GMT | 12 |
I have written a class that when instanced, represents product information or a product line. I am working with MS Office 2003 and Windows XP Pro. Inside the Class_Initialize() .. I have the following code: ***************************************************************
|
| combobox problem | 23 Mar 2006 09:30 GMT | 2 |
in the file attached below i am having a problem with one of th comboboxes. If you go into the spread sheet under advanced and unloc all (password is gmsafety123) and look in the definitions workshee under the column titled area. Then go into the visual basic edito
|
| Moving sheets | 23 Mar 2006 09:28 GMT | 2 |
How do I write a macro to move the activesheet to the end of the active workbook. Thanks Greg
|
| Macro for: If cell has 4 characters, make cell red | 23 Mar 2006 09:27 GMT | 2 |
I'd like a macro to identify cells with only 4 characters (i.e. a yea like 1989) and if the cell has only 4 characters, to make th characters in the cell to the right of it bold red. For example, i cell A29 is 1933, the characters in cell B29 should be in bold red.
|
| Workbook_BeforeSave: Bypassing prompts for external links | 23 Mar 2006 09:21 GMT | 1 |
I am trying to writing a Workbook_BeforeSave event procedure to handle files with external links. However, Excel's own prompt (Save "Bookx" with reference to unsaved documents?) always pre-empts the event procedure whenever external links exist in the workbook to be saved.
|