Black Background Color on Excel Spreadsheet
Recently I had to replace my monitor. On my new monitor my
Excel spreadsheets(the same has happened to my Word and
Powerpoint programs)now exhibit a extremely black
background. I still do see the column and row lines on the
Excel spreadsheet and any added text or numbers are
visible, but how do I change the background to a lighter
As far as I know the only way to change the background color of a worksheet
is via Windows Control Panel - > Display Properties, Appearance, Advanced
and the Item is "Window". This is for Windows XP. Other Windows versions
may be diff...pivot chart changes not saved
I have a report that incorporates a pivot chart. It's been acting squirrelly
lately in that modifications I make to the chart (form in pivot chart view)
aren't saved. For example, I noticed a Title under the Title that I defined
that reads "multi-chart." I've tried to delete this field to no avail--when
I open the report, it still has a title "Multi-chart." I don't try to modify
the chart with the report open, I've deleted the field using the del key as
well as the delete "x," and I hit the save button before closing out. Any
ideas why the...Customising Tabs
We have CRM Sales Standard license without the Invoice functionality, we have
only light Invoice details required, I have customised a separate TAB for
Invoices and add the fields, also selected some of the default fields changed
their names to say Invoice No but the metadata name is the same old eg
address2contact does it matter ! and can I use this approach of customising
and creating my own Invoice Form.
are you simply changing the display name that appears on the form for the
Microsoft CRM MVP
http://www.microsoft.com/BusinessSolutions/Community/CRMFa...Change the chart when a cell is clicked
Hello and thanks for the help. I am using Office 2007. I have a sheet with 8
people listed and their sales. Here is a brief example:
Rep Jan Feb Mar
JO 5 6 7
AL 65 3 2
KIM 6 2 9
I would like to click on the cell that says JO and have the Jan, Feb, Mar
data appear on the page as a pie chart. When I click on AL then the Jan, Feb,
Mar data for AL appears and when I click on KIM the Jan, Feb, Mar data for
Kim appears. I would like for JO's chart to disappear when I select AL and
AL's chart to disappear when I select KIM.
Hi...In excell, I put an invalid character on a worksheet name tab, no.
I am several worksheets into a project and in naming a tab I put an invalid
character on the tab name. Now, any touch of the keybord or mouse just gets
me an error message and nothing is active....what to do?
Press Esc key ..
should cancel the action
GMT+8, 1� 22' N 103� 45' E
"lyk" <firstname.lastname@example.org> wrote in message
> I am several worksheets into a project and in naming a tab I put an
> character on the tab na...How do I alphabetize the tabs on a spreadsheet with 25 tabs?
The only way I know is to drag and drop but it's time consuming. Is there an
Alt+F11 to open vb editor. Right click 'ThisWorkbook' and insert module and
paste the code below in and run it
For x = 1 To Worksheets.Count
For y = x To Worksheets.Count
If UCase(Sheets(y).Name) < UCase(Sheets(x).Name) Then
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still s...Money 2004 Budget Summary won't load on Home page
I have Money 2004. The "Budget Summary" on the homepage has stopped
loading. It says "Loading..." but never does.
Any ideas what's causing it and how to fix it?
Here's what I tried so far:
1) Removed the Budget Summary from my home page and readded it. No luck.
2) Verified I have a budget loaded in the Budget Planner. The Budger
Planner displays the budget summary correctly.
3) Looked in the FAQs but didn't see this particular problem listed.
...a status like "checking" to change to date format when completed
I am creating a DB that is for Tracking engineering drawings.
I want to have a status field that has the following
1. not started
2. in process
3. in checking
4 complete / Date completed
Is it possible to have the complete status change to a date somehow?
I want to avoid having two fields, a status field and a complete field
I would suggest that you may want to change that to have four date fields.
That way you can easily check its status in the process and get a complete
but to answer your speci...Page layout
Operating System: Mac OS X 10.5 (Leopard)
I want to lay out some pages in the style of the English publishers Dorling Kindersley. I want the text to wrap around and weave amongst photographs (I'm the arty type). If you go to amazon.com, search Dorling Kindersley, and have a look inside #4 'The Human Body' (or any of their Eyewitness series) - that's the effect I'm after. Go Barack!
That type of work is not done in a word processing program - at least not if
you want pro quality output. That's especially true if you intend to
generate o...saving to web page
I have a spreadsheet that I have grouped into different subtotals using
the subtotals tool under tools. Is there a way to save this as an
excel webpage and give users the ability to expand and collapse the
groups in the same way that is available in the workbook?
My closest attempts thus far have resulted in the columns being hidden
in the webpage but not easily collapsed and expanded.
Message posted from http://www.ExcelForum.com/
...Chang/add pone listing type
Is there a way to add or change existing phone naming
structure. The military uses a phone system called DSN.
I'd like to add DSN to the drop down list in outlook. Or
perhaps be able to modify one of the current existing drop
No, those fields are locked.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
Having searched the archives and finding no answer, R Garvin
| Is there a way to add or change existing phone naming
| structure. The military uses a phone system called DSN....Disabling Page Setup?
Hi, I'm fairly new to Excel and was wondering how one might be able t
Disable the Page Setup menu in Excel? Any suggestions would b
appreciated. Thank you
Plazzma's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2523
View this thread: http://www.excelforum.com/showthread.php?threadid=38722
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=247, Recursive:=True).Enabled = False
You must also disable printpreview
See for more info
...Background Sound #3
Is there a way to add background sound to my email using Outlook 2003
( Without the need of Word )
Orlando Gondar <email@example.com> wrote:
> Is there a way to add background sound to my email using Outlook 2003
> ( Without the need of Word )
Not that I know of. See http://www.howto-outlook.com/Howto/addingsound.htm
...Only First Page of 3-Page Web Site is Available after Upload
I created a three-page web from a template in Publisher 2003 and uploaded
the .htm file to my Comcast site, but only page one is viewable, when trying
to access page two or three, the URL cannon be found. The second and third
pages are in the associated "files"file as page 378.htm and 450.htm. When I
choose preview web site in Publisher all three pages work.
Help or advice appreciated. Regards, Bill
When you Publish to the Web and produce the html output from Publisher 2003,
unless you change the default settings, you will get an index.htm file AND a
index_files folder,...Folder/Tabs Newbie Question
When you create a spreadsheet Excel creates 3 tabs at the bottom - is it
possible to open one of the tabs and create a set of sub-tabs, ie I could
have a main tab for week one, week two etc. and the within the tab Week1
could I have 7 sub tabs for each day of the week.
You can add more sheets to a workbook.
In Excel 2003 you can have 7 distinct Data>Lists on a sheet.
In Excel 2007 you can have 7 distinct Insert>Tables on a sheet.
Gord Dibben MS Excel MVP
On Mon, 15 Mar 2010 10:10:02 -0700, Andrew
<Andrew@dis...Macro to repeat the same tasks over 180 tabs.
I have a spreadsheet with about 180 tabs. I've done a Macro to complete a
few tasks on the 1st Tab. I now need to complete those tasks on most of the
remaining tabs. Is there a way to do this without copying the same Macro
and then changing the tab name? There are about 5 tabs that I don't want to
Macro to run on, so ideally, the Macro will ignore those. If that can't be
done, I can move them to another spreadsheet.
Thank you for your help,
You could loop through the worksheets with something like:
dim Wks as wo...Change Axes Scale Dynamically
I have been posting here for the past week about a project I have been
working on. First off I want to thank each of you who assisted, I really
Well I pretty much have it complete, but it seems when I think that a nother
problem pops ups. I have a workbook with about 15-20 worksheets which are
updated from other workbooks. Also, on this workbook I have a main worksheet
which holds the averages of all the worksheets combined. Some columns are
formatted as number other columns are formatted as percentages. I have a
combo box which is populated with a range and updates a...How can I change the color in a eps file?
I can get the file inserted but cannot change the color. Any suggestion?
You can change the .eps file to one color only if it has a .tiff header,
right-click the image, format picture, picture tab, recolor.
If the .eps file has a .wmf header, select the picture, arrange, ungroup.
Mary Sauer MSFT MVP
"Debmck" <Debmck@discussions.microsoft.com> wrote in message
>I can get the file inserted but cannot change the color...force first page view
I have an excel spreadsheet with lots of different sheets. I want the force
a specific sheet to be visible whenever the file is opened - irrelevant of
how the file was saved. So, the specific sheet is the first thing that
anyone who opens the file sees.
Is that possible?
Alt+F11 to open VB editor. Double click 'ThisWorkbook' and paste the code
Change the name to the sheet you want
Private Sub Workbook_Open()
Application.Goto Sheets("Particular sheet").Range("A1")
I have a text box with the default date in ("dd/mm/yyyy") format.
The user can then type over this date or leave it alone, and exits the text
box by means of the TAB key.
Within the exit code all the date validation takes place (See below).
If there is a problem the idea is to not allow the user to leave the textbox
until it is corrected.
The code executes and the error messages are displayed, HOWEVER there is
also code which executes when the TAB key is pressed.
This code does no validation as is all done within the exit event, the
KEYPRESS envent disables the text...charts tabs
My charts, graphs, and conditional formatting tabs are all faded out and
inaccessable, as if they are deactivated. What can I do to use them?
Do you have multiple sheets selected?
If the workbook/sheet protected?
Is it a shared workbook?
Is it only 1 file that displays the symptoms you describe?
Andy Pope, Microsoft MVP - Excel
"clark" <firstname.lastname@example.org> wrote in message
> My charts, graphs, and conditional formatting tabs are all faded out and
>...i recommend to enter this page and find some great links to loans website :
i recommend to enter this page and find some great links to loans
credit cards :
Allpricequotes.com is a leading search engine & directory for price
quotes on everything: Insurance, Loans ,Mortgages , Stocks, B2B
services, Travel and much more services
...print the sheet tabs
I want to have a way to print the sheet tabs only...
If one has a number of sheets .. and each sheet tab
a "label".. and you want to print them only or get a
summary page that list the sheet tabs... like a content
page ... stating the sheets contained..
Is there a way to do this?
>I want to have a way to print the sheet tabs only...
>If one has a number of sheets .. and each sheet tab
>a "label".. and you want to print them only or get a
>summary page that list th...HOWTO: Bulk change "Hide from Exchange address lists" under "Exchange Advanced" using ADModify or VBScript
1. Select the CUSTOM tab
2. Check Box "Make a customized attribute modification"
3. Attribute Name field, enter "msExchHideFromAddressLists" (without
4. Attribute Value field, enter "TRUE" to Hide from lists, "FALSE" to
show in lists (again, without quotes)
5. Hit Go!
(http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct05/hey...tabs inside a tab
i have a tabbed dialog, in which on one of the tabs i intend to added
to have sub-tabs.
which is the best way to add tabs can we use CPropertyPage or should
we go with CTabCtrl.
Thanks in advance,
I would use CTabCtrl. But it's a matter of preference. CTabCtrl will give
you more flexibility than using a CPropertyPage as a child control.
"chandra" <email@example.com> wrote in message
> i have a tabbed dialog, in which on one of the tabs i intend to added