I'm looking for a URL or other document for 2007 Office that is similar to
the information for Office XP found on this URL

http://www.microsoft.com/office/ork/xp/journ/prog0001.htm

that is is how do I programmatically detect whether a system has 2007 Excel
(and other Office products) installed?

Thanks,
Ted

I have a spreadsheet with info for multiple years. Is there a way to set it
up so that I can print each year independently without having to highlight
that particular section each time I need to print it? Thanks.

When I insert a checkbox, the default border is black. Is there
anyway to change it to another color? I am using excel 2007. Also,
the checkmark is black. Can it be changed to another color? Lastly,
can you resize the checkbox?

Thanks

I am running Windows XP Home, and recently updated to SP3. The Windows
updater is now trying to install the following update:

Security Update for Microsoft Office Excel 2003 (KB951548)

However, every time it tries, I just get the message, "Some updates could
not be installed," with that update listed.

As a result, my computer is continually downloading, trying to install, and
then failing to install that update. It's getting really annoying.

Is there a way I can get it to stop trying to install that update, or
otherwise fix the problem? It doesn't tell me why it can't install the
update.

Thanks.

Cool, Ron, this is truly awsome... I know this is so easy for you but so
valuable for not excel expert... thanks!

"Ron de Bruin" wrote:

Hello,

Is there a way to prevent Excel 2007 from opening in compatibility mode for
each workbook you open? I have Office Professional 2007, Windows XP Pro OS.
This is what I have done so far:
I opened Excel and saved the default worksheet Book1 in the xlsx format. The
file was saved in C:\Documents and Settings\\Application
Data\Microsoft\Excel\XLSTART
This does work if I have one instance of Excel open, but when I open a
second it shows Book1.xlxs is locked for editing and when I close that
warning box it opens with Book1 in compatibility mode.
Before I saved book1 the XLSTART folder was empty with the exception of my
macro personal file.

Advice and help is much appreciated!!

Thank you

Using MS office 2007 Excel. Want to track rents from 9 apartments. Some
renters are late or do partial payments throughout the month. Anyone have
template I can use to track these rents?

Thanks Roger but it is not working, I want it to go to the first vacant
empty row in column B
My Macro looks like this
Sub NEWOUT()
'
' NEWOUT Macro
'

'
Sheets("Loan Area").Select
Dim Lr As Long
Lr = Cells(Rows.Count, "A").End(xlUp).Row + 1

End Sub

It still takes me to B2 each time vacant or full

Any suggestions for an old amature

thanks
"Roger Govier" wrote in message
news:CC035F57-B021-450D-AF17-15CD660CD01D@microsoft.com...

am entering a formula that is counting items in a resource tracking
register
I Pasted 2000 entries along a row for example
=IF($B$2=FW1,$D$2-$H$2,0)
(FW1 is the item number)
I now want to copy this row down 2000 rows
so I have to change each column header to allow for downward copying example
=IF(B2=$FW$1,D2-H2,0)

I have tried writing a macro that will change example 1 to example 2, but no
matter how I try I find that the cell refences chang (D2-e2 and so on). I
need of course to be able to have these change (to c3, c4 etc) when I copy
down, so I cant use the $ signs here.

Manually it is taking forever, can anyone come up with a saving for me .

Thanks