Programming

find mac address of my own computer by excell macro
I am using excell 2002. I want to find mac address of my own computer by excell macro. ... 12 Mar 2010 16:12

#Value! cell
I want to display a message in a cell if the cell returns #Value! ... 12 Mar 2010 11:41

worksheet_change becoming active just by entering the cell
I have the following code in my worksheet: Private Sub Worksheet_SelectionChange(ByVal Target As Range) ' Watching for changes in cells {H,L,O,T}{2,5,8,...} If (Target.Cells.Count = 1 And _ Target.Row Mod 3 = 2 And _ Target.Column Mod 4 = 0 And _ Target.Column >= 8 And _ ... 12 Mar 2010 10:33

Change a default Excel warning
Hi, Column D is locked when the worksheet is protected but the cells in that column can be selected. If a user tries to enter text into any of the cells in "D", the standard warning appears i.e. cell is protected and read only. The cells can be double clicked which opens a user form into which the user will ent... 12 Mar 2010 10:33

Click on a Pie Chart
Hi, I'm pretty sure this isn't possible but..... I've been asked if it's possible to click (or double click) on a slice of a pie chart and jump to the data it represents (the same as you can in a pivot table). Many thanks Paul ... 12 Mar 2010 19:34

Editing a Chart on a protected worksheet
Hola, I wonder if there is a way to allow the user to edit an embedded chart within a protected worksheet. I know that setting the parameter DrawingObjects=True (when protecting the worksheet) allows for editing while protected. However, in the worksheet there are other shapes that I don't want the user to be... 14 Mar 2010 05:28

Find last user of computer from ActiveDirectory using Excel/VB
I want to be able to enter a computer name in a cell, and then for the active directory to return the last user who logged onto this computer into an adjoining cell. I'd ideally like to be able to run this against a list of computers held in excel. Hope that makes sense. ... 12 Mar 2010 09:26

Excel 2007: Formula bar text flicker, can't access other open workbooks or close Excel.
I am working on a fairly large application that refers to code in several addins. Userforms are used, but there are no shapes, charts, etc. on any worksheet. My problem is that 'randomly', but usually some time after using the main form (that can interact with cells on a worksheet) the test in the formula bar te... 12 Mar 2010 08:19

Merging all the sheets in the folder
Please can you help me how can I merge all the excel files to a new different worksheet named destination. All the files are of the same format having same columns. regards sanju ... 12 Mar 2010 08:19

Forgotten password
I have forgotten a password to an old excel vba code I created some time ago. Was wondering if there is some way of removing the vba password protection. Tried all my default passwords but no good. Since have made spreadsheet with all my passwords on so it wont happen again, but I really need the old code. Can ... 13 Mar 2010 11:58