merge is disabled
I'm working in version 2002. For whatever reason, in this particular file,
merge is greyed out. Does anyone know how to enable it.
I have some text that I want to merge over a few cells so that I can print
this puppy on one page.
Look to see if sharing is turned on, having said that there is no really
need to merge cells for printing, in fact unless you use merge in the top
rows to merge more than one row and you'll never copy and paste into those
cell of from those cells it's a waste of space and in fact the evil of evil.
Once you have to audit a large spreadsheet...The macros in this project are disabled.
From the ControlBox when clicking on the Exit Design Mode button, I
get a message:
The macros in this project are disabled.
This is preventing me from running my project.
Any Ideas ???
Try Help>About Ms Excel>Disabled items.
Anything there that you can re-enable?
Gord Dibben MS Excel MVP
On Sat, 10 May 2008 14:16:53 -0700 (PDT), Greg <ApexData@gmail.com> wrote:
>From the ControlBox when clicking on the Exit Design Mode button, I
>get a message:
>The macros in this project are disabled.
>This is preventing me from running my project.
>Any Idea...Exchange backup disabled user
We are running Exchange 2000 and Veritas Backup Exec 9.0
When a user leaves, we want to:
Disable the AD a/c and stop the user from receiving mail, backup the
mailbox, then delete it after 30 days (default retention period).
We want to disable a user the day that they leave so they no longer
have access to our network. The problem is though that we cannot
backup the mailbox while the AD a/c is disabled. We would like to
leave the mailbox in the backup schedule for 30 days so that it is
backed up onto the tape which we store away once a month (therefore we
always have a backup of...Formatting sheets #2
I am wondering if anybody can give me any tips about formatting Excel
spreadsheets? Perhaps there is a good web site? I'm often not sure how best
to go about it, especially if I have a combination of figures and text.
Microsoft seems to produce some really clever templates. For instance, all
the gridlines will be turned off and the background formatted a certain
color. I'd like to learn more about doing this on my own spreadsheets.
You might try a Google Search for Excel Formatting to get some ideas.
What I would do:
Make several copies of a sheet I have that is typical of th...lock format in a document
Is it possible to "lock" a format in a document? I am attempting to e-mail a
document to another user and their Word program is over riding the formatting
in the document which is causing the document to be incorrectly formatted. I
am using 2003 and they are using 2000.
If you are talking about Word, ask in a Word newsgroup.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Michele" <Michele@discussions.microsoft.com> wrote in message
>...Formula for date field
1.I have simple dates in one column (say column A) .
2.In the next column(Column B) I would like the date five months after
Column A to be displayed.Eg if Column A has an entry of 9th June
2007,Column B should display 8th November,2007.
3.A simple formula does not do the job as this does not take into
account the different number of days in different months!
Your post is a bit ambiguous since you don't really say how the
different number of days in months should be handled.
In articl...Format E-Mail address in Contact
I have a problem with the format of the email address in the contact form in
Outlook 2000. I have imported some contacts from Outlook Express and I added
some after the import. The imported contacts are showed as eg Mike Test and
if I show the properties of Mike Test a full contact window apears (one like
from the Windowsaddressbook). If however I open an added contact the email
address apears like email@example.com. If I show the properties of this
address I just get a small window with the SMTP adrdress.
I want all addresses to have the SMTP format in the email field. Has anybody
an ...Auto Emails through Workflow
I need to make a workflow on CASE Assnign:
If the severity level is high then email should go to specific position role
like "Vice president sales" or "Customer Relations Manager" or both, not name
If the severity level is medium then email should go to the manager of the
and in any condition email notification should to the person to whom the
case is assigned, to Account manager
I tried several ways but couldn't make it yet
No one read me post
> Dear All,
> I need to ma...Outlook 2007 (Exchange) Auto Login
Super simple need: I'd like something to fill in the password prompt
that I get everytime I try to log into my Exchange account when
Outlook 2007 launches. I figure I could write a window sniffer, but
does something out there already exist?
Is there a reason that Outlook is not set up to use NT authentication and
prompts you for a password? Is this your own email account or is it shared?
Or are you logging onto the network using a generic NT profile and you have
an email account with a different profile?
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/ ...Money 2005/Vista/Date Format
Changing the date format on Money 2005 with Vista
My Money 2005 still displays the date as 12/23/07 i.e. MM/DD/YY - regardless
of my regional settings on Vista which is set at DD/MM/YY.
I have set my date settings on Vista via regional settings etc. but when I
import a statement from my bank (UK) I get the date format error message. My
bank uses the UK setting DD/MM/YY.
In microsoft.public.money, Richard190065 wrote:
>Changing the date format on Money 2005 with Vista
>My Money 2005 still displays the date as 12/23/07 i.e. MM/DD/YY - regardless
>o...can a cell remind you of an upcoming bill date payment
i am trying to have a bill sheet inform me of upcoming payments of different
bills. is there a way to crreat a formula that will do just that. to remind
me of an upcoming pay event at least 4 days before the actual bill pay period?
With your date in A1, enter the following formula in B1:
You could use the same first part of the formula for conditional formatting
in either A1 or B1.
> i am trying to have a bill sheet inform me of upcoming payments of different
> bills. is there...Outlook 2007 totally disabled
New man on the block (Executioner's that is :( )
1. MS Office 2000 installed on Vista OS. All email accounts, including
Hotmail, operable using Outlook, with Outlook Connector.
2. Installed Enterprise 2007 and uninstalled (apparently not all of) Office
3. Accessing Outlook 2007 from desktop icon produces error "The Add-in
"Outlook Connector Extenions" (msncon32.dll) cannot be loaded and has been
disabled by Outlook. Please contact Add-in manufacturer for an update. If no
update available uninstall the Add-in".
4. Now Outlook 2007 is totally inop...Auto-Forward Rule Changes Sender to Me
I work part-time at a college that just upgraded to Exchange. With
their old mail system, I set up a rule to auto-forward all my mail to
my main POP account, which I monitor using Outlook. With Exchange,
the auto-forwarding rule changes the sender to my email address. This
means that when I hit reply, the response gets sent to me. This is
not what I want.
The school help desk people tell me that's the way it is and they
can't do anything about it. This seems like such a common situation
that someone would have developed a fix for it. If anyone is familiar
with this situation, I ...Conditional formatting to change bar colours?
Hi. I'm currently using Project 2003. Is it possible to change gantt chart
bar colours automatically to indicate whether a task is not yet started, in
progress, completed or behind schedule? Any help very welcome.
Yes, all of that is possible - you will need formulas in flag fields.See for
more FAQ 31 in
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
"DonnaO" <DonnaO@discussions.microsoft.com> wrote in mes...Record Macro and Edit Macro options disabled
I've downloaded the Excel 2007 trial and I'm want to record a macro but the
button, along with the Visual Basic and Macros ones on the Code section of
the Developer tab in the Excel Ribbon are disabled.
I have the Macro Settings set to "Enable all macros" and ticked the "Trust
access to the VBA project object model" in the trust center. I have closed an
re-opened Excel and have tried creating new workbooks in 3 formats
(extensions xlsx, xlsm, xlsb) but can't get the buttons enabled.
What have I missed? Or are macros disabled in the trial version?
Tha...how do I search dates using the "between and" function
I am using the between and function to display dates, it is working in the
qurey design but not on the form can anyone help
>>it is working in the qurey design but not on the form
Explain a little more.
What is it not doing in the form that you expect?
Is the query the source for the form?
Build a little - Test a little
On Tue, 11 Sep 2007 10:56:05 -0700, rickyb <firstname.lastname@example.org>
>I am using the between and function to display dates, it is working in the
>qurey design but not on the form can anyone help
>...mfc disabled ico treatment
I am trying to resolve an issue with .ico files in MFC
dialog displays rendering poor quality disabled icons when
those functions are not available. My theory is that the
display call is looking for an alternate and lower color
depth version of the icon.
I am looking for any info on this from people who have
encountered this problem before. I will be planning to add
a 1 and 2 bit version to the .ico files to test, but was
hoping to narrow down the specs, since the files can be
grayscale or color and 1 or 2 bit.
thanks in advance for your help!
...Disabling that annoying question
I'm using Vista with Office XP. Is there any way to turn off that annoying
question that occurs every time I send an email?
The one that basically says "a program is trying to access your Outlook
file, blah, blah" and then asks for your ok for 1 to 10 minutes.
No, not really, although it really depends on what is causing the message
and what type of email acct you have. But you should only see it when you
use an automated system or other application to send mail, not when you
compose mail in Outlook and send it.
Diane Poremsky [MVP - Outlook]
Author, Teach...entering numbers to display a time format
I am trying to add time format to a cell to show just hh:mm if a single
number is typed in ie 14 to show as 14:00 or 14.23 to show as 14:23.
the current format hh:mm seems to default to date and time when a number is
typed in cell such as 14 will show 00:00:00 in the cell and the fomula bar
shows dd:mm:yyyy hh:mm:ss.
would finally like to find a formula which will calculate a timespan between
two cells displaying a time value.. ie start and finish times in seperate
cells then night and day totals to be shown in their respective cells for a
bespoke wages/ time sheet .
ie ;start time ...disabled
Is anybody know? how I disabled copy and paste in my
...Disable listbox items...
I have created a program which contains a listbox with 100+ items. I
want to distribute a sample program by disabling approx 90% of the
items in the listbox (but allow the potential user/buyer to see them).
I have searched the newsgroups and understand I need to create an
owner drawn listbox but could not find any sample code that made any
sense. Could someone enlighten me with some sample code?
Do it as owner-draw, and draw the disabled items grayed out. Then if the user clicks on
one, or double-clicks on one, refuse to deal with it.
To do this, you will probably pu...Day Date Problem
This is a multi-part message in MIME format.
I'm trying to set up a spreadsheet which when I input a date in one =
column (B), it will automatically fill in the day of the week in the =
I've used the formula:=20
6,"Fri",I...Help WTD please with dates
Can anybody help me with a dilemma I have in excel. It all revolves around
calendar dates, dates from and dates to and dates in between.
What I am trying to do is construct a spreadsheet which will show me a date
in the future from a date I have entered.
I want to put a date in say cell A1 (Date of Commencement of work) and from
this date a set of rules will apply.
I want to enter a date in cell A2 (first day of sickness) and from this date
be able to use a chart to determine how much sick pay an employee is
The rules of sick pay entitlement are time based ...Graphical co-ordinates format data label (with brackets) for chart
Using Excel 2007, I have made a chart using a data series with the x-values
in one column and the y-values in another. I wish to show the data label for
these points, but want to include the brackets to replicate the mathematical
way of expressing the co-ordinate i.e. that the data label would read (-8, 6)
instead of -8, 6. I've tried creating a custom data label using format codes,
but I'm getting nowhere fast. Can anyone help please?
Also, I have a second series on the same graph that I do NOT want to display
this information (I'm making a teaching resource). It d...Error: $customObject | format-table
I see this problem all over but have tried every proposed solution but
nothing provided works for me. Bottom line, I am creating a custom object
via .csv import but when trying to format-(to anything), I get the error
shown below the script. Sorry if this is a dead-horse. BTW...using v2 on
W2K8R2. Everything works except the last line. If the "ft" is not there,
the results are listed in "format-list" by default...but I want a table
format. (Script below is word-wrapped of course".
###Beginning of script
param([SWITCH]$help, [STRING]$ouDN, [STRING]...