Programming

vba project password
Hello I created a form about 2 years ago and I put a password in the vba project. Today I was asked to make a change and I cannot remember the password. Is there any way to do this? Please I hope so.... thanks ... 30 Apr 2010 09:29

Moving Macros to the Application Level
I have built a spreadsheet and written code to add a toolbar with a button that executes a macro (that I also wrote) that formats a Scorecard spreadsheet. As it is my team has to have my spreadsheet open, copy the Scorecard to be formatted into my spreadsheet and then run the macro from there. I would like to... 29 Apr 2010 15:49

Macro that searches for keyword and replaces it with ...
Here is what i need from a macro : i have an excel sheet . In A column i have book titles . In B column i have their descriptions . From time to time the description contains the keyword "This title" . I need the macro to find the cells in B column where this keyword is and to replace it with the text from cell cor... 3 May 2010 12:04

Column Array
Hi, Is it possible to do a "Column Array" so you can copy paste special Column's A, D, Z As Range("A:A,D:D,Z:Z").SELECT Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Does not work -- Message posted via http://... 29 Apr 2010 13:33

Converting strings to numbers
I want to join the values of a range of cells (say 1, 2, 5, and 8) to produce the number 1258, which can then be used in other calculations. Any ideas on how to do this? I'm using Excel from Office 2000 Many thanks ... 29 Apr 2010 11:15

Copy to Named Range
I can "Set Range" then "Copy" then "select" then paste as below If Cells(CCC - 1, 1).Value = Cells(CCC, 1).Value Then Set MyRange = Cells(CCC, 100).End(xlToLeft).Offset(0, 1) Range(Cells(CCC - 1, 11), Cells(CCC - 1, 14)).Copy MyRange.Select ActiveSheet.Paste For speed I do not want donot want to select but t... 29 Apr 2010 11:15

Copy filtered data (Values only)
The following code copies filtered data: Set Rng = ActiveSheet.AutoFilter.Range Rng.Copy Destination:=Worksheets("Sheet2").Range("A1") but copies values and formulae. (e.g. .PasteSpecial xlPasteValues) How do I modify to the copy only the values Thanks! ... 29 Apr 2010 11:15

Insert Shape Based on Cell Changes
Hi. I have a graph in Excel which is populated with data based upon a selection from a drop down box. For some of the selections though there is no data and an error message comes up and the graph does not display properly. I want to (using VBA) have a command that executes if there is no data to populate ... 29 Apr 2010 08:59

Sort bug on Excel 2007
On Excel 2003 it works perfectly, on Excel 2007 I have error 1004 "sort method of range class failed". Sub SortSalary(CellToSort As String, SortRange1 As String) Sheets(1).Range(SortRange1).Sort Key1:=Range(CellToSort), Order1:=xlAscending, Header:=xlYes End if Is it a bug on Excel 2007? ... 29 Apr 2010 13:33

Click Excel custom menu item via MFC automation
Hi, I have a question regarding custom Excel 2003 menu item click via MFC automation. The VBA version of the action I want to do is pretty straightforward: Application.CommandBars(1).Controls("NumeriX").Controls("Object Tools").Controls("Delete All Objects").Execute Now I need to translate the above line ... 29 Apr 2010 06:46