Modifying display colors
Is there a way (through settings dialogs or registry
settings, whatever) to modify the background and text
color of the row & column headings?
I'm not sure exactly what you are doing, but it sounds like
you should be using conditional formatting. It's easy to
use. Do some reading on that subject in the help file.
>Is there a way (through settings dialogs or registry
>settings, whatever) to modify the background and text
>color of the row & column headings?
Not for Excel alone.
You can c...Locking and Protecting and NOT displaying formulas
Is it possible to not only lock but also NOT display some formulas we have in
a ROI-Return On Investment-spreadsheet???
Sum of the formulas are proprietary and would like them to not even be
displayed within the spreadsheet that will be distributed to prospects leads.
Let me know.
RTP, format, cells, protection, check hidden for the cells with formulas,
protect the sheet. be aware that this protection is VERY weak and can be
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedb...How to Change Value of Active Control
I'm writing a routine to change the value of any Active Control to null. I
can get the name of the control using ActiveControl.Name but I can't figure
out the syntax to change the value of this control. I've tried assigning it
to variables but variables aren't working in a:
Forms![variable]![variable] = ""
"Sondreli" <Sondreli@discussions.microsoft.com> wrote in message
> I'm writing a routine to change the value of any Active Control to null.
> can g...Pivot Tables & changing data
Hi - I have never used pivot tables in Excel before so hopefully what I am
going to ask is possible and not too complicated for me.... :o)
I am working with Excel 2003. I have a pivot table already set up and the
information is pulling data from a row titled "sum of Subscriber". I added
new data in a new column from the main spreadsheet and I would like to pull
the data from there. Its titled "Adj Subscriber".
Is it possible to switch it? If so, how?
Thanks, Anna Marie
> Hi - I have never used pivot tables in Excel before so hopefully what I am
&..."All users" "Programs" create/modify shortcut from app...
I've created two shortcuts into "Programs" folder for "All Users"
It lets me to get them available for all user.
Application running in "User" context needs to delete and re-create such
links but it fails due to an "access denied" ...
Settings correct permission to such links it starts working as well
I've created links using the IShellLink/IPersistFile sehll interfaces.
So, I actually need to have link under "programs" for "All Users" which
might be modified by application running in "Users"...How to change default printing parameters on Excel & ......
How to change the default printing parameters on Excel & keep them changed
for future workbooks.
Example: Normally I use Printing margins 0.25 on all directions, but
default printing margins are 0.75. I want to change them to set 0.25 as
If you start a new workbook and change the page layout (for all the sheets), you
can save it into your XLStart folder as Book.xlt.
Excel will use that as the basis for new workbooks.
You can change a lot of settings that way--including orientation,
> How to change the default printing parameters ...Createing Quote sometimes make Error: 80070057
Today I found some funny problems.
I create Quotes via the quote WebService from the CRM.
This normally works fine, but now I have some quotes, which will get me an
error, when I open it. This error is no normal error, I will get an
white/yellow Page with ASPX Errorpage:
Here the Message (sorry but I only have this error in German):
Serverfehler in der Anwendung '/'.
Beschreibung: Beim Ausf�hren der aktuellen Webanforderung ist ein
unverarbeiteter Fehler aufgetret...Change color of multiple autoshapes
I need to change the color of several autoshape based on different cells
I know how to change one autoshape using a worksheet_change event
but i can't just copy and paste this and change the object name + cell name.
is it possible to have multiple worksheet_change events in the same
You have only one worksheet_change event, but in it you can test to see which cell was
changed with something like
If not Intersect(Target, Range("A1") is nothing then
' do range A1 stuff here
If not Intersect(Target, Range("A2") is nothing then
...Date/Time Displayed as 07/tt/jjjj
I'm new with MS CRM and just testing it. I have a prob with all date/time
fields like described in the subject of this post.
Timezone is set for all users
Problem occurs in all date/time fields in the web application
Anyone has a clue?
As Administrator, go to Home > Settings > there is an area in there (can't
remember what its called) that enable you to change default date/time format
"JanScheider" <JanScheider@discussions.microsoft.com> wrote in message
> I'...Recovery after "do not save changes" selected accidently
I mistakenly clicked on "do not save changes" for a
worksheet (file) that i'd been working on (I thought a
different file was highlighted). As it turns out I had
not saved the original file in over a day, though the
autosave is set up.
is there any way to get my file back, or at least an
intermediate version, instead of one with a day's less of
Thanks very much for your help!
Sorry to say, but your day's work is gone.
Greeting from the Gulf Coast!
"Mayukh" <firstname.lastname@example.org> wrote in...Scrpit when trying to change CRM option in Outlook client
I get the attached script error when i try to change the MSCRM Option in
MSCRM Outlook client and it does not accept my changes.
An error has occoured in the script on this page.
Error: Type Mismatch
URL:http://localhost2525/tools/personalsettings/dialogs/personalsettings.aspx?clientid= etc etc
Please let me know if any one knows how to fix this issue, thanks.
...How to get rid of a "line" in Word
If I type a number of dashes in Word and press Return it automatically
gets changed into a continuous line.
How do I later remove such a line?
Sometimes if I delete the text line above it then the line also goes but
often I just can't get rid of it. I have to resort to creating a new
document and then copy/paste the god bits over and then delete the old
(The Reply-to address IS valid)
Les Desser <NewsDump1@dessergroup.com> typed:
> If I type a number of dashes in Word and press ...FRx
I encountered problem of changing default base period.
The version of FRx software is 6.5.28 and it is running under Windows
The situation was:
After opened the Catalog of Report Window, there was a pop-up message
box which said 'Changed the default base period to C'. I did not know
why this could happen.
- Would you please tell me under what circumstances this pop-up message
box would display??
In order to continue to use this software, I only could click 'OK' from
the message box. The report date is then changed to 'Default Base
Period' - (Ja...How do you display a dialog on startup?
If you want to display a modal (or modeless) dialog when your MFC application
first starts up, where do you put it? (This would be a login or an
informational dialog that appears on top of the main window.)
I tried putting it in the OnInitialUpdate() method in my CView-derived
class, but I get asserts.
In InitInstance of your app(or OnCreate of your mainwindow), you could post
a custom message to your mainframe. In its handler, show the dialog.
Ajay Kalra [MVP - VC++]
"Edward W" <EdwardW@discussions.microsoft.com> wrote in message
news:...Changing a username/address
I work with someone who just changed her name, and I'm trying to figure out
how to change it on the Exchange (2000) server.
I changed the username in Active Directory (also 2000), but messages from
the user still have the old name in the Sender field. Also, when I point to
the mailbox for saving messages, it has the new name (Mailbox - New Name)
until restarting Outlook, and then it has the old name.
Do I have to Exmerge out the mail, delete the account, re-create the
account, change the name of the .pst file and import the mail?
Thanks in advance!
Follow these steps:
=...unable to display inbox folder due to "invalid handle"???
Ran a scandisk that identified a couple of cluster
problems, and allowed the computer to fix the problems
identified . Since then, whenever trying to access email
in OUTLOOK, we get the following message: "Unable to
display the foler. The file
data\microsoft\outlook\outlook.pst could not be accessed.
The handle is invalid."
What is going on?
Can some one assist me? I would like to temporarely display the calender and
select the date in a form and capture the desired date.
I am a novice at this
Message posted via AccessMonster.com
If you'd like to only have the calendar appear when you need to pick a date,
you can use this routine.
YourTextBoxName is the name of the box that will hold the date
YourCalendarName is the name of your calendar.
First, place the calendar where you want it to appear on the form.
Next, select the calendar and goto ...Change the sender to the previous owner when a lead is reassigned
Business scenario is as folllows:
A new lead fires a workflow which sends an email to the lead with the owner
as the sender. When the lead is reassigned, they want an email to have the
PREVIOUS owner as the sender.
There is no facility in email to change the SENDER in the email.
What is the recommended solution - callout, etc.
Very right, Callout is the solution.
uMar Khan :: MS CRM MVP
CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.wordpress.com
MVP :: https://mvp.support.m...Public folder default display
I have an Exchange server 5.5 and I make some forms used by the clients to
publish information in public folders.
My problem is : How create a default display (server side) for a public
folder used by Outlook clients.
In my case I want a chronology display.
...How do I populate the "Find" dialogue in Word with the contents of the clipboard?
I tried, and failed to create a macro.
(I do a procedure hundreds of times every day so wanted to automate
I press Control-F (to open the 'find' dialogue) and then press Control-
V (to paste the contents) into the dialogue. As you can see from the
code below, when I recorded the macro, it used '2022' (which is what
happens to be in my clipboard right now) but I want it to use the
Is this possible? I hope I've explained the problem properly.
Sub FindWhatsinClipboar...unable to download stock quotes
I'm trying to update stock quotes (less than 50 quotes), it
doesn't appear to be working. In the call summary I get a
message unable to connect to the online quote server, check
your internet connection.
It appears to have checked for Money update and the call was
suscessful. I'm connecting over a cable modem.
I have a connection to the internet, I can get email, view
web pages, connect to MSN and get current stock quotes.
I'm running XP and Money 2004
In microsoft.public.money, Warren wrote:
>I'm trying to update stock quotes (less than 50 quotes), it
&...How to change a bar to line in a combo chart?
I am currently using Excel & PPt 2000 and cannot figure out how to control
which rows of data are displayed as a bar or line in a combunation chart. In
PPt it combo bar/line chart defaults to the last row only as a line and in
Excel it seems to have half as a bar/ half as a line.
In the chart, select the series you want changed. Then, select Chart |
Chart Type... and pick the desired type+subtype.
When a single series is selected the chart type choice applies only to
that one series.
Excel, PowerPoint, and VBA add-...Return a "" value from a formular
Any help greatly appreciated: I have 2 formulars that works, but I want them
to return nothing eg "" when there is nothing entered into a cell, at the
moment they return the 'false' value. My formulars are:
=IF(O12>O11,"End milestone deadline passed","OK")
milestone passed and 'Actual's' late","End milestone passed but 'Actual's'
=IF(isblank(O12),&...Change database source for pivot table
I've built a pivot table based on an Oracle database.
however I want to change the source database (from test to live) but can't
figure out how to change the source database.
Just answered my own question, in the query go into table definition and
change the database
"Neil" <email@example.com> wrote in message
> I've built a pivot table based on an Oracle database.
> however I want to change the source database (from test to live) but can't
> figu...Default "Save as Type" problem
Outlook 2003 - when saving an e-mail message "save as type" defaults to HTML. This unfortunately strips off the attachments. I need to change to Outlook Unicode type as a default, but when changing settings in Tools - Options - Other - Advanced Options - "Use unicode message format when saving" when ticked on - doesn't seem to make any difference. Default still appears as HTML.
Can anyone help