General

Disabling Tools/Options setting
Can anyone help me to find the VBA code to disable the Tools/Options setting. This to avoid that the user of a model can change the original setting of a model. Many Thanks Jeronimo ... 22 Mar 2010 01:29

How set many row heighths = height of another row
Is there a nifty way to use paste special to copy a row and then select a bunch of other rows and set all of these selected row to the same height as the copied row? I need to do this for several rows on several sheets and first getting the height # of the source row, then setting heights of target row numeric... 21 Mar 2010 19:44

Disable running of SelectionChange macro when in another macro?
Using Excel 2003 I have a macro in a module that automatically deletes cells. The problem is that as it selects these cells, it activates a SelectionChange macro. The SelectionChange macro then slows this other macro down tremendously, even though I have screenupdating off in the module macro. Is there a way to ru... 21 Mar 2010 15:05

Update Links
In Excel 2003 there use to be an update links prompt. how do i activate this in 2007? ... 21 Mar 2010 13:52

Excel sluggish performance
How do I fix the sluggish Excel 2007 in Window7, when the message bar shows a security warning saying that the automatic update of the links has been blocked? ... 21 Mar 2010 12:44

Lost functionality to copy a formula across rows
Recently I lot the functionality to copy a formula across a group of cells. Normally clicking on the cell will give you a "handle" to allow you to drag across a range of cells. At work we are currently using the 2002 Excel and I had this functionality until just recently. I have been getting several workshee... 21 Mar 2010 12:44

Pivot table format on paste values
Hi, I've constructed a working file with numerous pivot tables to be used in reports. what i would like to do is paste these sheets into a new book as values and still retain the Excel 2007 formats. As i have multiple pivot tables on one worksheet when i copy and paste into the new sheet i lose all the pivot t... 21 Mar 2010 11:37

Calculating How Old Someone Will Be in a certain year
I have a list of dates (birthdays & Anniversaries) in the dd/mm/yyyy format down a column, with the years in the format yyyy across the first row. I want a formula that will calculate the age of the person or anniversary by using just the year part of the date and comparing it with the year across the first row... 21 Mar 2010 12:44

Calculating age
I have a Spreadsheet that contains a column of dates (birthdays and anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010, 2011, 2012 etc. At the intersection of the two I wish to insert a formula that will calculate the age or the anniversary. I would be grateful for any help. Thanks in adv... 21 Mar 2010 12:44

Conditional Format Fragmentation
My Excel 2007 Worksheet has 19 colms & anywhere from 10 to 40 rows. The data changes daily with deletions, insertion and additions to the end. Colm N has an action indicator & I have set Conditional Formatting to highlight any "Delete" entries &I set the range to the entire column - $N:$N. Works great at firs... 21 Mar 2010 11:37