Replies

You are welcome. Glad it helped.
For others interested, the link again is: Formats and Styles
(no registration required)
‘–
Jim Cone

Maybe…
The list of unused styles is displayed in a new workbook.
You have to switch back to your original workbook before running the program again.

If that is not the problem, I would very much like to get a copy of your workbook to see what is going on.
‘–
Jim Cone
( 30 + ways to sort )

Excel uses the calculation setting of the first workbook opened.
If the first workbook you open has calculation set to manual, that setting will apply to all subsequent workbooks opened.
‘–
Jim Cone
Portland, Oregon USA
Special Sort add-in info link

My free Excel add-in “Formats & Styles” will list/remove unused Styles in a workbook.
It can also handle custom number formats and conditional formats.
Some have been quite pleased with the results.
Download from… http://excelusergroup.org/media/p/4861.aspx

Have you checked how many styles are in your workbook?
They have a tendency to multiple when using xl2007.
I have seen reports of workbooks with thousands of styles that magically appeared.

Don’t overlook Taskbar Shuffle – drag and drop your taskbar buttons – I use it every day.
Taskbar Shuffle

The new Microsoft product is Microsoft Security Essentials Beta Home. I’ve been running it on three systems at home. It is very lightweight and I’ve had no problems so far. Unfortunately, the beta is currently closed. You may want to check the MSE home page from time to time to see if they are accepting more beta participants or the product has been released.

Joe

For what it is worth…
Initial news reports stated that the program requires Automatic Updates to be enabled.

First thing I would try is turning off Script debugging by check marking…
“Disable Script Debugging” in Tools | Options | Advanced (tab).

Also see… http://support.microsoft.com/kb/321410
‘–
Jim Cone

In case there is someone reading this who wants a dedicated Excel Thesaurus;
the free “Thesaurus for Excel” add-in (xl2000 to xl2003) can be downloaded from…
http://excelusergroup.org/media/
It has not been tested on xl2007.

Can print single/multiple_synonym/antonym lists to the worksheet with a click.
‘–
Jim Cone
Portland, Oregon USA
(yes I wrote it)

I updated, not a new install, and didn’t have your problem, Jim. Run it again, see if the program unloads in the Task Manager Applications window after you end it. If the problem persists, and the program stays in memory, try uninstalling and reinstalling.

JohnBF, thanks for your comments.
Second scan of MWB completed and exited normally.
However, this time I had told mwb to ignore the 3 security center objects it found in the first scan. Don’t know if that made the difference.
‘–
Jim Cone
Portland, Oregon USA

For what it is worth…
On Windows XP, Service Pack 3:
I downloaded and installed Malwarebytes for the first time yesterday (06/18/2009)
It installed and ran without any problems.
After the quick scan completed and the exit button was clicked the
program displayed a message that the scan was still in progress.

A minor issue but ?
‘–
Jim Cone
Portland, Oregon

A couple of ideas…
At the time on the SP install, did you happen to clean out the Windows temp file?
If you had thousands of files in there, then removing them could make a difference.

Did you change any settings in your anti-virus program.
Norton was/is famous for slowing down Excel with its office scan.
‘–
Jim Cone
Portland, Oregon USA

You construct a shape range.
The data type of the array must be a Variant.
Selection is not required.
‘–
Sub ComplicatedIsNotBetter()
Dim a As Worksheet
Dim arrShps() As Variant
Dim N As Long
Dim shpItem As Shape
Dim shpRng As ShapeRange

Set a = ActiveSheet
ReDim arrShps(0 To a.Shapes.Count – 1)

For Each shpItem In a.Shapes
If shpItem.Top > 500 Then
arrShps(N) = shpItem.Name
N = N + 1
End If
Next ‘shpItem

ReDim Preserve arrShps(0 To N – 1)
Set shpRng = a.Shapes.Range(arrShps())
shpRng.Group
MsgBox shpRng.Name & vbCr & shpRng.GroupItems.Count & ” shapes”
End Sub
—
Jim Cone
Portland, Oregon USA

This problem occurs only if Windows XP SP3 was installed *after* Internet Explorer 8. If Internet Explorer 8 was installed after SP3, you should have no problem uninstalling it.

‘–
I uninstalled IE8 yesterday and had no problem with that portion.
However, IE7 then kept displaying the splash screen (customize your settings)
every time IE7 was opened. It wouldn’t go away.

The solution was a registry modification shown here…
http://support.microsoft.com/kb/945385
I made the changes manually. Maybe this will help someone else.
Jim Cone
Portland, Oregon USA

Since you are new to Excel, this may not be what you want.
However, just in case, the following vba code should do what you asked…
‘–
Private Sub Workbook_SheetDeactivate(ByVal Sh As Object)
‘Jim Cone – Feb 2009 – Portland, Oregon USA
‘A newly selected worksheet will scroll to the same
‘row position as the worksheet you just left.
‘This code works automatically if you place it in
‘the “ThisWorkbook” code module.
On Error GoTo DoRight
Dim NewSheet As Object
Dim lngRowNum As Long
Application.EnableEvents = False
Application.ScreenUpdating = False
Set NewSheet = ActiveSheet
If TypeName(NewSheet) “Worksheet” Or _
TypeName(Sh) “Worksheet” Then GoTo WrongWay
Sh.Activate
lngRowNum = ActiveWindow.VisibleRange.Row
NewSheet.Activate
ActiveWindow.ScrollRow = lngRowNum
Application.EnableEvents = True
WrongWay:
On Error Resume Next
Set NewSheet = Nothing
Application.EnableEvents = True
Application.ScreenUpdating = True
Exit Sub
DoRight:
Beep
Resume WrongWay
End Sub
‘–
Jim Cone
Portland, Oregon USA