Excel problem Tools Option

cesar miranda

unread,

Sep 11, 2003, 6:03:31 PM9/11/03

to

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

unread,

Sep 11, 2003, 6:45:35 PM9/11/03

to

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.

--

Dave Peterson
ec3...@msn.com

cesar miranda

unread,

Sep 11, 2003, 7:03:02 PM9/11/03

to

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

>-----Mensagem original-----

>.
>

Dave Peterson

unread,

Sep 12, 2003, 6:32:37 PM9/12/03

to

You tried the workbook or the registry tweak or both?

What happened when you tried the workbook?

cesar miranda wrote:
>
> I tried this and....

> nothing, the did慨 appear the second excel in task bar!

> >> I alredy reinstaled the office and the problem weren愒

> >> disapear. What i do?
> >
> >--
> >
> >Dave Peterson
> >ec3...@msn.com
> >.
> >

--

Dave Peterson
ec3...@msn.com

cesar miranda

unread,

Sep 25, 2003, 1:33:24 PM9/25/03

to

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

>-----Mensagem original-----

>You tried the workbook or the registry tweak or both?
>
>What happened when you tried the workbook?
>
>cesar miranda wrote:
>>
>> I tried this and....

>> nothing, the did´n appear the second excel in task bar!

weren´t

>> >> disapear. What i do?
>> >
>> >--
>> >
>> >Dave Peterson
>> >ec3...@msn.com
>> >.
>> >
>
>--
>
>Dave Peterson
>ec3...@msn.com

>.
>

Dave Peterson

unread,

Sep 25, 2003, 5:49:56 PM9/25/03

to

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.)

cesar miranda wrote:
>
> 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愒

>
> >-----Mensagem original-----
> >You tried the workbook or the registry tweak or both?
> >
> >What happened when you tried the workbook?
> >
> >cesar miranda wrote:
> >>
> >> I tried this and....

> >> nothing, the did慨 appear the second excel in task bar!

> weren愒

> >> >> disapear. What i do?
> >> >
> >> >--
> >> >
> >> >Dave Peterson
> >> >ec3...@msn.com
> >> >.
> >> >
> >
> >--
> >
> >Dave Peterson
> >ec3...@msn.com
> >.
> >

--

Dave Peterson
ec3...@msn.com