Changing options permanently

R

Ron Beck

Under Tools, Options, View tab, there is an option to
Show, Windows in Taskbar. How do I set that permanently?
It is such a pain to have to change it constantly.

Thanks,

Ron Beck
 
R

Ron Beck

I have no problem with going into the registry to make the
change if that's what is needed. Hope someone knows what
to insert for that.

Thanks,
Ron
 
D

Doug Kanter

Do you see any error messages after making the adjustment via the normal
method? By normal, I mean through the Excel options dialog box.
 
D

Dave Peterson

Do you use xl2k and do you use shared workbooks?

If so, there's a bug that's been fixed in xl2002 that played with that setting.
 
N

Norman Harker

Hi Ron!

I think that Excel takes the setting of this option from the last time
Excel was closed.

Accordingly, once changed to whatever you want it will stay that way
until it is changed again.

Check whether this is the case.

If it isn't then you need to look for what is changing it. It can be
changed by a Workbook_Open event handling procedure in your
Personal.xls workbook or another workbook in XLSTART or an Addin. It
should just be a case of tracking it down.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/
 
R

Ron Beck

I'm not sure about that. I'll check with IT. We do use
shared workbooks and they act just as bad. The problem
occurs even with non-shared.

I can save a spreadsheet after changing the option, exit,
and when I come back in, it's changed back to default,
which is no check in the box..all worksheets in one window.

Appreciate the thoughts.

Ron
 
R

Ron Beck

No error messages. I open a spreadsheet, change the option
through Tools, save the worksheet, exit, comeback in and
it's back to default...a pain in the workbook.

Thanks,
Ron
 
R

Ron Beck

No, it seems that Excel has it turned off by default. I
can open a sheet, change the option, save the sheet, exit,
come back in and it's turned off again.

Thanks for the thoughts.
Ron
 
D

Doug Kanter

OK...at this point, I'm asking questions which may be irrelevant, but I'm
stumped. Networked machine, or standalone?
 
D

Dave Peterson

This ain't much of a fix, but as a workaround, you could use an application
event that always sets the windows in taskbar the way you want it whenever a
workbook is opened or created:

http://groups.google.com/[email protected]

I don't think it's necessary for xl2002+. What version of excel are you using?
 
T

Tom Ogilvy

When your checking with IT, see if they have restrictions on registry
entries or otherwise manage your registry.
 
D

Doug Kanter

Tom Ogilvy said:
When your checking with IT, see if they have restrictions on registry
entries or otherwise manage your registry.
Click to expand...

I can understand why IT would want to prohibit using regedit, but it seems
insane (and annoying) to keep users from customizing their software via
their options menus. Isn't it possible to handle the two issues separately
in Win2K or XP?
 
J

JE McGimpsey

Doug Kanter said:
I can understand why IT would want to prohibit using regedit, but it seems
insane (and annoying) to keep users from customizing their software via
their options menus.
Click to expand...

That's because you're not IT. In my experience, with rare exceptions,
IT's conception of their job is to protect the network at all costs,
even if it means that the work that pays for the network can't be done.

Users are often perceived as annoyances and threats to security, rather
than the ones that pay for IT salaries and fancy hardware.

So in their world, it's not insane at all...
 
D

Doug Kanter

JE McGimpsey said:
That's because you're not IT. In my experience, with rare exceptions,
IT's conception of their job is to protect the network at all costs,
even if it means that the work that pays for the network can't be done.

Users are often perceived as annoyances and threats to security, rather
than the ones that pay for IT salaries and fancy hardware.

So in their world, it's not insane at all...
Click to expand...

Nice. In such an environment, a work stoppage sounds appropriate. But, in
all fairness, I can see that allowing users to change the "Edit Directly in
Cell" option in Excel could easily bring a large multinational corporation
to its knees in a matter of minutes, and probably be a precursor to
Armageddon.
 
R

Ragdyer

Conceptually John, IT is correct in defending their defined "realm".

Being my own IT, and also a user (among approx. 50 others), I can definitely
and definitively state that it is *with rare exceptions* that most (average)
users are anywhere (nowhere) near knowledgeable enough to be allowed even
near the XL formulas, much less the network itself.

I do agree though, that the innuendo (they're *not* properly performing
their function) in your insinuation (they're *only* interested in protecting
the network) is absolutely correct!

When I become involved with some of my suppliers' (some *large*
corporations) IT departments, I find that the higher up the corporate ladder
the *head* of IT is, the better the over all performance becomes, simply
because the sphere of responsibility and answerability begins to encompass a
larger portion of the corporate achievement.

The only way that I've found to deal with an unyielding, stubborn, and
perhaps uninspired and disinterested IT force, is to (plain and simple),
"butter them up" in the attempt to get what you need or want.
And believe me, this is much easier if the "head" is of the opposite gender!
 
J

JE McGimpsey

Ragdyer said:
IT is correct in defending their defined "realm".
Click to expand...

I really wasn't trying to insinuate anything different - they're paid to
keep the network safe, so that's their focus. It's like the topside
watch on my old submarine, who insisted (backed with a .45) that I show
my ID before boarding, even though we'd served together for two years. I
really wouldn't have wanted him to make an exception for me, as it would
imply an application of of judgment and possible susceptibility to
outside pressure that could have compromised the security of the boat.
Still, it was a real, if minor, irritant.

Aside from the gender issue (most women I've worked with/for have been
far better than the men at detecting and resisting an attempt to "butter
them up" - I'd like to think it isn't just me), I've had similar
experience with clients and employers.
 
D

Doug Kanter

Ragdyer said:
Conceptually John, IT is correct in defending their defined "realm".

Being my own IT, and also a user (among approx. 50 others), I can definitely
and definitively state that it is *with rare exceptions* that most (average)
users are anywhere (nowhere) near knowledgeable enough to be allowed even
near the XL formulas, much less the network itself.

I do agree though, that the innuendo (they're *not* properly performing
their function) in your insinuation (they're *only* interested in protecting
the network) is absolutely correct!
Click to expand...

Yeah, but the option which is the subject of this thread is obviously NOT
going to have any affect on the network. Matter of fact, in Word & Excel,
the only option that could even be mentioned in the same sentence as
"network" would be the one involving the location of certain files, and
screwing THAT up on a client machine should hurt only the user, not the
network. This assumes, of course, that the network is set up correctly.
 
J

JE McGimpsey

Doug Kanter said:
Yeah, but the option which is the subject of this thread is obviously NOT
going to have any affect on the network. Matter of fact, in Word & Excel,
the only option that could even be mentioned in the same sentence as
"network" would be the one involving the location of certain files, and
screwing THAT up on a client machine should hurt only the user, not the
network. This assumes, of course, that the network is set up correctly.
Click to expand...

But from IT's perspective, they'd have to know enough about XL to set it
up in a way that's safe. Sure most of your options aren't likely to
screw anything up (or, almost as important, require tech support), but
they don't necessarily know that to the extent they'd need to feel
secure about letting you loose with them.

It's far easier for them to simply block everything.
 
Top