Excel problem Tools Option

[cesar miranda]

I need help, i work with excel every day, sudenly happened
a problem "the option to show new windows on task bar"
stoped to function. Anybody could help me ???
I alredy reinstaled the office and the problem weren´t
disapear. What i do?

 

[Dave Peterson]

I've seen a couple posts like this. Did something happen so that you don't have
access to write to the windows registry? (where this setting is stored)

If yes, then I'd talk to my IT department, (er, unless you're at home), to see
if they could fix it.

If you're comfortable with editing the registry, you could try updating it
manually to see if it sticks.

If you're not comfortable, then record a macro that sets the "windows on
taskbar" the way you want it. Rename the subroutine to Auto_open and save that
workbook in your XLStart folder.

Then each time excel opens, this file will open. And it'll set it the way you
want.

Here's one version of the macro:

Option Explicit
Sub auto_open()
Application.ShowWindowsInTaskbar = True
thisworkbook.close savechanges:=false
End Sub

I added that .close portion. It means your workbook opens, sets the windows in
taskbar and then closes to get the heck out of the way.

====
windows registry info (only if you're comfortable):

I use windows98 and excel2002.

It looks like excel keeps track of this setting in:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options

the value Name is: ShowWindowsInTaskbar
I have a 1 (hex)
in that value when this option is turned on and 0 when it's off.

 

[cesar miranda]

I tried this and....
nothing, the did´n appear the second excel in task bar!

 

[Dave Peterson]

You tried the workbook or the registry tweak or both?

What happened when you tried the workbook?

 

[cesar miranda]

I tried the both.
When i ran the Macro, only opened new document, but inside
excel.
And to edit registry, the value was right:
ShowWindowsInTaskbar = 1 (Hex)
I Really want solve this problem, but i can´t

 

[Dave Peterson]

Tell me again what happened when you used the macro?

The plan was that the workbook would open, change that setting and then close.

Did the setting get changed? (You didn't say whether you looked.)