Programming

How to determine if an excel Excel was open by code (automation) or manually, by a human user
Hi. An excel file is opened by people, but also by code from a VB application. I would like the code in Workbook_Open to run whenever the file is opened by a human, but not to run when the file is opened by automation. Any ideas ? Thank you very much Alex. ... 22 Jul 2008 00:23

Linking Checkbox to Worksheet
First, let me say that my knowledge of Macros and Visual Basic is very limited. What I have is a workbook with about 20 worksheets. On a summary workheet I have inserted checkboxes and linked those checkboxes to a specific cell on the summary sheet. I want to associate the check boxes (or the linked cell) ... 21 Jul 2008 16:10

Offset Range
Hi, I am using the following code but I need to have D3 value change depending on what row I am entering data into. I have been working on this and can't find the answer. Here's the code: Private Sub Worksheet_Change(ByVal Target As Range) Dim AOI As Range Set AOI = [D3] If Not Intersect... 21 Jul 2008 14:06

Set initial filename before saving
When a new workbook is created from a template the proposed (initial) filename when saving the workbook is the "template name".xls. I would like to have this proposed name (initial name) to be equal to cell content. Would you please help me with the coding. Here is what I have so far: Private Sub Workshee... 21 Jul 2008 15:08

Assign a single variable to an Array filled with same data types
Why am I getting this error "Can't Assign To Array" for this code? Dim myArray(0 To 5) As Single Dim Var as Single ERROR => myArray = Array(var1, var2, var3, var4, var5, var6) For Each Var In myArray Var = 0 Next Var but if I code it this way everything works: Di... 21 Jul 2008 14:06

Print Range Question
I am trying to develp a macro that will set the Print Range in a worksheet. I have tried to modify several macos on the forums with no success. The problem is I need to count down to the bottom of column A (which does contain some blanks), to the first row that contains 0. Then I want the macro to set the Print... 22 Jul 2008 10:37

sheet name text color
Is there any way to change the text color of a worksheet title (the actual text on the tab)? Thanks all! ... 21 Jul 2008 13:04

Delete Rows x-n
Hi everyone! What I want to do is basically Worksheet.Rows.Delete xlShiftUp except that I do not want to delete the headings row. So something like Worksheet.Rows.Delete (2) to delete starting from row 2, without having to provide the end of the range that I am deleting. Simple question - is ther... 22 Jul 2008 05:29

random permutation of an array
Can anyone help me with a script that would shuffle the elements of an array of integers randomly. For example: MyArray before shuffling: 1, 2, 3, 4, 5 MyArray after shuffling: 3, 5, 4, 2, 1 I want the reordering to be really random. TIA ... 21 Jul 2008 16:10

Macro on Password
Is there a way to have a password protect on a workbook and once end user keys in the password, the workbook status will changed to modified? ... 21 Jul 2008 13:04