| Thread | Last Post | Replies |
|
| Act if spell check box occurs | 22 Jun 2006 07:50 GMT | 1 |
Problem: I have a program that checks the spelling of a cell. If the word exists, nothing happens. Good. If the word doesn't exist, the spelling box occurs. From there the user can choose to ignore once, ignore all, etc. Bad. I
|
| Open another workbook and then some.... from another Workbook !! | 22 Jun 2006 07:48 GMT | 16 |
Is this possible? Workbook (a) Workbook (b) From Workbook (a):
|
| Create new workbook when 00 sheets are reached | 22 Jun 2006 07:38 GMT | 1 |
Is it possible to have a code, so that when/if 100 sheets are reached in a single workbook, then the first 3 sheets are duplicated and another worksbook is created ? I understand that having more than 100 or so sheets is not wise.
|
| Resize array based on number of 'used' elements | 22 Jun 2006 07:26 GMT | 2 |
So here's my second question of the afternoon.................. I'm creating an array of unique words based on another list passed to the procedure (see code below). This works ok but I'd like to resize the resulting array (vUniqueList) to be the same number as the elements that ...
|
| Test for open workbook | 22 Jun 2006 06:54 GMT | 3 |
I'm having a few problems when one workbook is open, then another containing macros is opened (while the first is still open). The macro's cease up in this situation and they do funny things. So, I am wondering if there is a test procedure to check if there is a
|
| Conflict with Workbooks | 22 Jun 2006 06:47 GMT | 1 |
I've got a slight problem with that I've used "ThisWorkbook" but from my code I've created a second workbook which is automatically named "Book1, Book2, Book3..." and I've got code in "ThisWorkbook" that moves a sheet from itself to the newly created workbook.
|
| Send out email if | 22 Jun 2006 05:51 GMT | 2 |
I have a work sheet where we track which jobs are completed during the work day the sheet is updated via workers punching in their numbers what i am looking for is a macro that will send an email to veresv@gmail.com when ever the word "RG Complete" appears in column F.
|
| Macro to clear all images? | 22 Jun 2006 05:30 GMT | 1 |
Hi all, I have a quick question..keep in mind my vba skills are basic.. How could I tell excel to delete all images in a worksheet without refencing each one specifically? Just swipe the slate clean of whatever pictures are present without deleting numbers and such in the sheet..
|
| Need a simple printing macro code | 22 Jun 2006 03:20 GMT | 1 |
I have this userform that refers to Sheet1 (in Sheet1 I have data comin from Texbox's at the userform). I have a button at the userform that want to use to print whatever I have in Sheet1 (I have already set th print area in Sheet1).
|
| Option Groups and Select Case | 22 Jun 2006 03:20 GMT | 1 |
I'm currently setting up a script that will select an array based on specific criteria. I'm using the select case method. The problem is that I want the user to select a radio button and the value of that radio button will determine the array to use.
|
| Delete Rows in Worksheet2 that Match Criteria in Worksheet1!A1:A20 | 22 Jun 2006 02:56 GMT | 3 |
I have a macro put together by Ron de Bruin a fewmonths ago... wondering how I can modify it so that it will delete rows in worksheet2 if ColB in Worksheet2 contain values referenced in Worksheet1!A1:A200. In otherwords, how can I modify the line DeleteValue = "*Total*" to
|
| Freeze titles (Figer les volets) | 22 Jun 2006 02:49 GMT | 6 |
If I select A4 and freeze the titles, a line appears above line 4. Is it possible to make this line disappear by code? Thanks.
|
| How to save a file | 22 Jun 2006 02:33 GMT | 4 |
I want to place a button in a worksheet, which will ask for a filename, after the user input the filename, I want to save the file to a particular directory, how can I do that? I do not want to use the common dialog box. I want to use an
|
| code to unprotect sheet with password | 22 Jun 2006 02:26 GMT | 8 |
I need to run a macro that first unprotects a password protected sheet, and then reprotects it later, with a password. The user will not know the password, and therefore the code needs to, itself, have it hardcoded in there. I am not concerned about someone digging in the code ...
|
| Application.Volatile Question, HelP!!! | 22 Jun 2006 01:58 GMT | 1 |
Okay here's my problem, I have a VBA subroutine (Marco) that I want to run, BUT in my worksheets I also have functions that I've written (in VBA) that are Application.Volatile. So when I run the subroutine, Excel also has to re-calculate "all" the
|