How do make a cell show a check mark on 'click'
I am trying to have a column whose cells toggle a check or a 'tick' sign when clicked on. How can I do this? I can't find any info on the excel books I have
Thanks in advance for your help!
Excel doesn't really have a way to catch a single click on a cell.
How about a right click (or even double click)?
Here's a routine that checks to see if you rightclicked in column A.
If you did it checks to see what's in that cell. If it's empty, it adds a
formula (=char(252)) and formats the cell with a Wingdings font.
If the cell has something in i...Editing budget shows Recurring bill as zero
Within the Budget, I have a recurring bill under 'Bill Summary' showing up
as ZERO and there is not 'Money icon' showing it is a Withdrawl or bill when
I am trying to edit the Expenses. All my other recurring bills are showing
the 'Money icon' indicating Withdrawl or bil.
I can edit it but then when viewing the 'Budgeted' amount, this is then
Has anyone experienced the same?
Should this SP1 be installed on SBS2003 or is it already installed?
On Tue, 22 Jun 2004 12:48:04 GMT, J B wrote:
> Should this SP1 be installed on SBS2003 or is it already installed?
It's not already installed and the decision is yours, just be aware there
are a few issues when applying the Exchange 2003 SP1 on SBS 2003:
More on Exchange SP1 and SBS 2003:
Smallbizserver.Net > SBS 2003 > Service packs & patches > Exchange 2003:
EXCHANGE 2k3 SP1:
http://...Numbers show instead of text
I entered text into some cells, and it shows up as numbers. What do I do?
What sort of text?
Where is it entered?
What type of numbers?
A small example would be nice.
Gord Dibben MS Excel MVP
On Sat, 7 Oct 2006 14:36:02 -0700, Mcoste <Mcoste@discussions.microsoft.com>
>I entered text into some cells, and it shows up as numbers. What do I do?
It sounds like you have the data formatted for numeric in the first row of
Select the problem cells, right click, select format cells, and select
Number type of "General".
"Mcoste&quo...Outlook 2000 Inbox does not show new message until click somewhere
This installation is a 25 user SBS 2000 w/Exchange 2000 sp3.
Two user do not show new inbox items until they click somewhere else then
the new message show in the inbox.
If no movement to another inbox etc. message may take 45minutes to show even
internal exchange mail.
We are having the same problems, look 4 or so pages below under the subject
strange behaviors for my post.
> This installation is a 25 user SBS 2000 w/Exchange 2000 sp3.
> Two user do not show new inbox items until they click somewhere else then
> the new messag...Upgrading from STD to Enterprise
We will soon need to upgrade from Exchange 2003 STD to ENT
because of the 16Gb limit.
Has anyone does this? What is the process? I read that you
pretty much just install it and it keeps your information
stores, and thats it.
Is it really that easy and has anyone had ANY
It's a painless process. Insert the 2003 Enterprise CD, run setup.exe, and
watch the magic. Everything is kept intact.
"Carey" <firstname.lastname@example.org> wrote in message
> We will soo...CRM Shows Wrong Current Date
In CRM 3.0, for some reason CRM shows date one day behind the current date.
This is applicable to any onload events, default dates in service activity
The date on the SBS server that we use matches current date though. Any
suggestions on this please.
In the CRM database, all dates are stored in Greenwich Mean Time. And
depending on the timezone you have set in your CRM settings (log into CRM and
click Tools-->Options--> look at your timezone setting) CRM will convert and
display the date and time to whatever you have selected as yo...Making 1 big excel file 10 small files
I have to a list of contacts into groups of 100, is there a way excel can do
that faster then just having to cut and paste into new files? A divide comand
or something? Please Help!
> I have to a list of contacts into groups of 100, is there a way excel can do
> that faster then just having to cut and paste into new files? A divide comand
> or something? Please Help!
It's slightly easier to copy the file 10 times,
then delete the parts you don't want in each new file.
Less chance for mistakes, too.
...Query to show empty cells
I am doing a database for addresses and would like to run a query showing the
addresses that are empty. What should I put in the criteria to show an empty
Try out the query with IsNull as criterion.
If the message was helpful to you, click Yes next to Was this post helpful
If the post answers your question, click Yes next to Did this post answer
> I am doing a database for addresses and would like to run a query showing the
> addresses that are empty. What should I put in the criteria to sh...Direct show video effect filters
I want to make a application in which i can adjust the
color,brightness,hue saturation of a video(avi) file and also crop the
required area within the video and then save that cropped video to a
I am using directshow filters for this purpose.Any help in this regard
will be helpful.
check out the fddshwo and its "tryouts". They are very powerfull
filters available for video pre- and postprocessing, including your
avi demand (where you should know that avi is no real format, its
See the page bottom for mor...problem with hiding/showing the dialog
I have an MFC dialog based application comprising of 2 dialogs.In the
first UI the user is allowed to select images and the count is being
displayed.On clicking NEXT the second UI appears.
Now the problem is On clicking BACK in the second UI i need the first
UI to be dispalyed with the previous state i.e the number of images
I have tried using AfxGetApp()->HideApplication() in the OnNext handler
and AfxGetMainWnd()->ShowWindow(SW_SHOW) in the OnBack handler.This
displays the first UI with the previous state but the whole window is
Can someone please suggest what cou...Distribution reference column showing Blank in Detailed TRial Bala
After upgrading to Great Plains 8.0, in the GL Detailed Trial Balance
report, the Distribution Reference, Orig.Master Number & Orig. Master name
columns are showing blank for all GL journal entries.
But these columns are populated & showing up correctly for all the Payables
So why are the GL journal entries missing the information?
Prior to the upgrade, these columns had information for all entries.
How can we fix this?
...Publishser 2003 show links to pc but should link to index folder
I'll get to the quick point.
I save and publish my website and then uplad to the ftp site.
The links on my navigation bard point to file:///c:\document...
I't should just point to index\index.html
Now I built 3 other sites in the past but I can remember how I slove
Can someone please help me?
I thought there was a simple way to correct this inside publisher 2003
but now I can rememer what it is.
I hope someone reading the groups this sunday. I know the world cup is
If you are using a Master Page in the web publication you can have this
Dav...Redeploy SBS2003 R2 Premium
We have an SBS 2003 R2 Premium box that we're going to replace with a
SBS 2008 box. We then want to redeploy the 2003 to our smaller site
(only 5 users).
I'll be doing a clean install of 2003 back to the same box (and then
doing a swing migration from SBS 2000). I already have the Swing kit
When I redeploy it, I don't want to bother with SQL and ISA server,
since they're overkill for the smaller site.
So my question: Can I just skip the installation of the Premium disk,
and not suffer any consequences in the future? Or am I likely to bre...If(a=3;1;emptycell)???
if I use an function e.g. IF(A=3;1;"") the cell isn't empty anymore.
When I draw a graph the "" will appear as 0. Also by making a
regression line these 0's ar taken into account. How can I avoid this?
wim rademakers's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30134
View this thread: http://www.excelforum.com/showthread.php?threadid=498214
( My real mail address: arvi.laanemets<at>tarkon.e...Really need help
I need to create a job/sales tracking sheet. 4 employees how do I set
it up to track :
Job #, Date, Customer, Price, Employee, Reg Hrs., Ot Hrs.
I have the basics figured out, but need some help to be able to tune
up info to seperate info for individual employees. I have attached a
copy of what i have so far
I need to block cerstain websites. I know this can be done in ISA, but we do
not have this product. What other ways (software or hardware can this be
accomplished? Looking at blocking gmail, facebook, etc.
Most would consider the "best" way to be a third party edge appliance such
as, but not limited to, SonicWall, WatchGuard, Calyptix, Cisco, more or less
in order of increasing price.
But there are others. Untangle, for example, will run on practically any
old PC and the basic software/firewall is "free".
http://www.u...Multiple document support in MFC 7.1
I have ported my MFC codes from VS6 to .Net and found that
I am no longer able to start a multiple document app by
double clicking the icon of an associated document file in
the Windows Explorer. The VS6 versions linked with MFC6
works fine, but the .Net versions linked with MFC7 do
The same goes for a simple .Net/MFC7 skeleton multiple
document app built with the .Net App Wizard. The document
info is being registered in the registry, but apparantly
Windows cannot find the clicked file.
All single document apps work OK, so I wonder what can be
>I have ...Fractions not showing/printing in Word
I have several files which I know contain typed fractions (i.e. 1/2,
1/4), but the fractions are not displaying or printing when I open the
files in Word X for Mac. (The files originated in Word on the PC--not
sure of which version however.)
When I copy the text out of Word and paste it into practically any
other program, including Text Edit or even Mail, the fractions show up
and print just fine.
Anyone have any ideas as to what I can do to make these files work
properly in Word?
On 15/11/05 18:38, in article
email@example.com, "s771...Migrating SBS2003 to SBS2008: DHCP
I read in the migration documentation that it is "preferred" that DHCP be
used in the Sourse (2003) server so that during the migration it merely
accepts the DHCP settings BUT you can uncheck the box to indicate that
another device is being used as the DHCP server (i.e. Router). It also says
that if there is another device being used as a DHCP server that during the
migration that the device (i.e router DHCP) should be disabled. So, here is
I understand that the migration is "live" and that the users are still
accessing the SBS2003 server whil...column named "group" causes problems with new SQLServer
Unwisely we called a column in one of our tables "group". We talk to
the table primarily though ADODB code in VBA in Access. This works
fine with our SQL2000 box, but we're moving to SQL2008 (with
compatibility 80) and in testing we found that Access will now give
errors during .Updates on this table.
Any advice here?
I'm actually surprised that it works in any version of SQL Server.
It might work if you put square brackets around the name in your SQL
For the future, check what Allen Browne has at
http://www.allenbrowne.com/AppIssueBadWo...Display more than 1 month in Outlook 2007?
When I'm in my Calendar view, I'd like to see at least 3 months at a time in
the little calendars in the left-hand pane. There's plenty of room, but only
1 month shows.
I can get more months if I expand that pane wider, but then it moves the
corresponding pane in the Inbox view also, which I don't want.
KathyN <KathyN@discussions.microsoft.com> wrote:
> When I'm in my Calendar view, I'd like to see at least 3 months at a
> time in the little calendars in the left-hand pane. There's plenty
> of room, but only 1 month shows.
> I c...End-of-line Handling in the XmlReader (.NET Framework Version 1.1)
This is a multi-part message in MIME format.
According to the XML 1.0 (Third Edition) W3C Recommendation =
(http://www.w3.org/TR/2004/REC-xml-20040204/#sec-line-ends) all #xD, =
#xA, and #xD#xA character combinations should be converted to a single =
According to the "Reading XML with the XmlReader" section of the ".NET =
Framework Developer's Guide" on-line help, the XmlReader will not =
perform this normali...MSExchangeOMA 1507 on SBS2003
On an single SBS2003 system, i.e. domain controller, exchange server etc..
OWA is working perfectly, however OMA is not. The symptoms are as follows:
From a client open the OMA url: i.e. https:\\server\oma
After entering valid credentials I get the following error in the browser:
A System error has occurred while processing your request. Please try
again. If the problem persists, contact your administrator.
This generates a 1507 event on the SBS machine.
An unknown error occurred while processing the current request: Exception of
type Microsoft.Exchange.OMA.DataProviderInterface.Provide...Making the same guidelines show on every page in a Visio Document
I have a Visio Document that has about 25 pages.
I want to create some guides *once* and then be able to see those guides
on all of the pages in the document, without having to recreate those
guides in every page.
Is this possible and if so how is it done?
Create background page and set all page to use it as background. Then add
guides to background page.
site about visio - prodigitall.narod.ru
"Peter Haywood" <firstname.lastname@example.org> ???????/???????? ? ????????
> I have a Visio Document that ha...