Disable changing the sort/grouping setting in inbox messages
Is there a way to disable a person from changing his sorting/grouping
of messages in his inbox in Outlook 2003?
We have a person that keeps sorting/grouping by sender, so he tends to
only see the messages he wants to see.
We want him keeping them sorted by received date/time so he sees all
messages as they come in, as some are going unread for days that he
needs to be seeing and doing something with.
Anyway to force a sort order in messages, and disallow grouping,
through a registry entry, or in some other way?
No. Unfortunately there are no technological solutions for this behavioral...Can't change font property in Excel 2002
I have been using the following code in a procedure that puts a red "X" in a
cell when you click on it. It works fine in Excel 97 / 2000 but not in Excel
2002 (Runtime error 1004: Unable to set Color property of font class). In
fact it won't change any properties of the font class.
Has there been a change in the newer version? All these properties still
appear as available.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Value = "X"
...OWA Certificate Error with IE7
I noticed many post about this problem but I didn't find anything good
for my problem.
My customers have IE7 and to improve OWA security on our system, I
Now it is working with https//mail.server.ca/exchange
But they have now a security warning page telling :
"Certificate Error : Navigation Blocked"
"We recommend that you close this webpage and do not continue to this
And I explained to teh users to click on :
"Continue to this web site (not recommended)"
Then they have OWA login page with the URL in red and with a
certifica...Scroll bars in Cell
It seems like you can only size a cell so that it is 409.50 pixels. I have
large ammount of text that I would like to put into a cell, and be able to
scroll through that text. It would keep the size of the cell minimum, and
allow the user to easily see what are the contents of the cell.
Is this possible in Excel 2000? Is there a similar way to do this?
Thanks for your help,
This is not possible for a cell (that is attach scrollbars to it)
Stephen Closson wrote:
> Hi all,
> It seems like you can only size a ...How do I change the colum headings?
I want to change the preset colum headings (A,B,C.....) to something
different.....How do i do that?
You have the option of letters or numbers (Tools/Options/General "R1C1
Reference Style"). That's all.
In article <CB62F616-739D-4393-89F1-2FB01BD37051@microsoft.com>,
"help" <email@example.com> wrote:
> I want to change the preset colum headings (A,B,C.....) to something
> different.....How do i do that?
From the menu choose
Tools, Options, General,
then check the "R1C1 reference style"-box
"help" <help@di...Portfolio Total Change Column
Wonder if this is a bug.
In the Total Change Column, the numbers are not correct. For example, I
have several stocks that are down today but the column is showing positive
The grand total is also showing a positive value although it should be
Anybody else having this problem?
...need to create a bar chart with a centre axis
Need to create a chart with a centre axis, with one comparison going to the
left, from zero to 22 and another set of data goin to the right with a
comparison set of figures - if this makes any sense
Sounds like a Tornado chart.
> Need to create a chart with a centre axis, with one comparison going to the
> left, from zero to 22 and another set of data goin to the right with a
> comparison set of figures - if this makes any sense
...I need scroll bars
How can I add vertical scroll bars to my CRM page?
There are two situations where I need this capability: 1) When I cusomize an
existing CRM form there is no way to scroll below the initial screen to add
additional controls and 2) when I create a link to an external web site
within CRM, the page displays without scroll bars.
Is there a configuration option I can set to change this behavior?
I can get the vertical scroll bars to show on an external page by adding the
following attribute to the <body> tag of the external page:
No change is requir...Changing publisher doc to a doc a friend can open?
A friend does not have publisher so cannot open the programme I have written.
How can I change it for her to open without Publisher?
On Wed, 23 Mar 2005 12:51:09 -0800, "MIck BRasil" <MIck
BRasil@discussions.microsoft.com>, in message ID
<AC19C64E-9A01-4827-A881-0C3D53F91C9B@microsoft.com>, in the newsgroup
>A friend does not have publisher so cannot open the programme I have written.
>How can I change it for her to open without Publisher?
This is a frequently asked question.
Download and install primopdf from www.primopdf.com...Pivot Table Refresh Changes Color Scheme for Some Cells
I want to display a Pivot Table output in a certain (blue) format.
When I refresh a Pivot Table, the color scheme on some cells changes, in my
case from blue to orange.
Your help is greatly appreciated.
...change the "from" email address
Can I change the "From" address when sending in Outlook?
If sending a message to a website and don't want them to
have my primary email address, can I send an "alias"
address so I don't get spam from them?
You can change the From address in the properties of your email account, but
it won't accomplish what you think it will.
Your email address is contained in the header of the email and will be just
<firstname.lastname@example.org> wrote in message
news:1c0201c4ad49$65855030$7d02280a@p...To determine the font of a cell and change it if required
I need to have a sub
The sub checks range A1 to A10
and determine the font of the cell
IF the font is not Times new roman
it makes the font to times new roman
and the font size to 10
also, if the font is not installed in the system
it should give a message.
ANy tips will be appreciated
Thanks in advance.
On May 6, 8:33=A0pm, Subodh <getsub...@gmail.com> wrote:
> I need to have a sub
> The sub checks range A1 to A10
> and determine the font of the cell
> IF the font is not Times new roman
> it makes the font to times new roman
> and the font size to 10
...Closing a PO causes Approved By field to be changed
We use Purchase Order Approvals in the Purchase Order Enhancements module. We
recently discovered that the field POA_Approved_By (which normally contains
the user ID of the person who approves the PO) is updated with the name of
the person that closes the PO (if it's manually closed).
Does this make sense? Because of this, we don't have a record of who
originally approved the PO.
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
...How do I change the x axis in a line chart
I have two sets of data and want to swap the y and x axes around.
right click in chart
select "source data"
from the "series" tab
select new values in the "name", "values", and "Category(x) axis labels"
> I have two sets of data and want to swap the y and x axes around.
...How do I delete the Event Planner Reminder from my task bar? Please!
I use Windows XP and yesterday when starting up, a yellow rectangular item
with a pin is showing showing up on my taskbar. It says it is an Event
Planner Reminder. I went to Outlook 2003, options and deleted all the X
marks. I do not know what this is and I want it deleted. Can someone kindly
tell me how to do this?
Thanks so much...
...Changing sort order of "name" in Contacts
The "Name" field (which I prefer to the indiviual "first" and "last" fields) is sorting by last name. I would like to change this behavior to sort by first. Can this be done?<br>
So far, I'm disappointed in Entourage. It's so... uncustomizable :(
Yes, you can.
If you customise the View so that First Name is visible, you can then sort
I put it right at the end of the row so it's off the screen. I look at the
"combined" name field, but I sort (in my case, by last name) by a field I am
not looking at.
On 10/0...Macro to change pivot field with latest value 03-01-10
This is a re-post as my questions hasn't been answered by anyone...
Hi there and thank you in advance for any help.
I have written a macro that changes (hides / shows) fields on a pivot table.
One of these changes the field used for the page fields section of the pivot
table. However, when i add a field to this section, it defaults to All. How
can have this field default to the latest value in this field.
Let me explain further: I want the pivot to be shown either by date or by
week. The macro then changes the page field section to show either the date
or week field. If ...How can I see who is using OWA?
We want to shutdown the OWA server but were wondering if we could see who was
online using OWA. Exchange 2003, Windows 2003 front end and back end with AD
Check the log created by ISS with a log analyzer
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Marie W" <MarieW@discussions.microsoft.com> wrote in message
> We want to shutdown the OWA server but wer...OWA Prompting Mulitple Times for the Same Login
Hello, I have a user that is getting prompts multiple times for OWA access.
If she opens a new message then she is prompted for her credentials, and if
she does anything that makes a box popup she is prompted for her owa
She has to login 2 differnt times to send out a simple email message. Anyone
have any suggestions?
...Tasks in OWA
I've got Exchange 5.5, SP4 with OWA. When a task is assigned to someone who
can only access email through OWA, they cannot accept or reject the task.
Is this by design or is this a bug?
In article <email@example.com>,
"AnytimeAnywhere" <firstname.lastname@example.org> wrote:
> I've got Exchange 5.5, SP4 with OWA. When a task is assigned to someone who
> can only access email through OWA, they cannot accept or reject the task.
> Is this by design or is this a bug?
This is a design limitation. OWA doesn't support task assignment...OWA Errors when selecting Premium Option
We are using SBS 2003 and Exchange 2003. One NIC on the server. The
system is about a week old. I'm trying to encourage people to use OWA
over having to install PC Anywhere. The problem I'm having is with OWA
when the Client mode is set to Premium.
After logging in the system will present Runtime errors at almost every
turn. First there is a "Line 14 - Object Expected" error when just
displaying the Inbox. If you try to select a message you get a "Line
223 - 'g_fIsMimeInstalled' is undefined" error. If you switch to
Calandar y...Status Bar disappears in Excel 2007
I get this problem repeatedly and it's very, very annoying. The Status Bar
keeps disappearing in Excel and the only solution seems to be to close and
keep reopening the application.
This is very annoying as I'm using an add-in that takes about 30 seconds to
I tried to Google this, but seems like no one's reported a similar problem
before. Can someone tell me where I can access the Status Bar settings from
the ribbon or some other place in Excel 2007?
We have been trying to do that since 2007 came out, the only way seems to be
through code. Che...Font size and type drop downs on formatting bar inoperative
The font size drop down menu on the formating bar appears empty when
attempting reformat text and the font type drop down is inoperative. Both
can be formated using the Format drop down from the menu bar
Have you tried an Office Diagnostics in the Help menu? Not sure why you cannot
select fonts or font size unless your cursor isn't in the text box. If you just
select the text box, the fonts are not active.
What version Publisher are you using?
"mantor" <email@example.com> wrote in message
news:5B28C...chart Bar with %
How I create automatically chart similar to PIE but "columns with % "
without create a new table with % numbers ?
You can make a stacked column chart which shows each column as a
percentage of the total of that stack. Unfortunately there is no option
to use the percentages in the data labels.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Marina Limeira wrote:
> How I create automatically chart similar to PIE but "columns with % "
> without create a ne...MVP challenge: OWA frontend-backend
So, I hope ther is a MS MVP who wants to take this challenge, or of course
somebody who can answer..
I have a Windows Server 2003 with Exchange server 2003 Enterprise Frontend
server and several different kinds of Exchange backend servers, in differens
Sites and Exchange Administrative Groups.
Now, OWA from the Internet over HTTPS goes well to the backend member server
which is a Windows 2000 server with an upgraded Exchange server (from 2000
What results in an Internet Explorer error 'The page cannot be found' from
the Internet however, is a Windows 2000 domain cont...