Formula Encryption #2
Is it possible to encrypt or hide a formula in Excel and still input data
into the worksheet?
Thank you for your help,
You could protest the worksheet so that the users could not visit that cell
But the security is not that strong - we all have password breakers!
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Ra" <Ra@discussions.microsoft.com> wrote in message
> Is it possible to encrypt or hide a formula in Excel and still input data
> into the wo...Deleting multiple lines #2
I have a about 25000 + codes in one column (A) some of the codes are
duplicated 7 or 8 times. some 1 or 2. How do I remove the duplicates. With
out doing it by clicking on each line individually?
Hi. Check out Chip Pearson's site: http://www.cpearson.com/excel/duplicat.htm
Sincerely, Michael Colvin
> I have a about 25000 + codes in one column (A) some of the codes are
> duplicated 7 or 8 times. some 1 or 2. How do I remove the duplicates. With
> out doing it by clicking on each line individually?
...Out of Stack Space #2
I'm getting an "Out of Stack Space" error when using my forms. It does
not happen all the time (had the program running all day and it
I got it on a form.show...
Basically I have about 5 forms and only one will be shown at anyone
time onscreen so I do form1.hide form2.show etc so only one is on at a
time....Is this something that would cause memory to be used up?
I'm not an expert at VB...this is the first thing I have written...
The Zero ST
"Craig Coope" <email@example.com> wrote...
>...Rule that will BCC recepients
I'd like to build an Outlook rule for my profile firstname.lastname@example.org that
will allow me to do the following:
1) After any message arrives forward it to email@example.com (myself)
2) BCC firstname.lastname@example.org
Any suggestions would be greatly appreciated.
Forgot to mention, I am running Outlook 2003 on XP.
email@example.com <firstname.lastname@example.org> wrote:
> I'd like to build an Outlook rule for my profile email@example.com that
> will allow me to do the following:
> 1) After any message arrives forward it to firstname.lastname@example.org (myself)
Try looking at the ...Microsoft Exchange server 2007 #2
I Downloaded and used Exchange SDK,
There was a sample on VC++ named CreateAppointment,
I'll get error while I want to run the sample, I saw there error
occured on this lines:
// Set the provider to the Exchange OLEDB driver.
connection->Provider = "ExOLEDB.DataSource";
Please do me a favore and help me if yiu'd like.
I am getting follwing error :
The following calendar has been opened:
CreateAppointment threw the following error:
IDispatch error #...ver.2.
How much does ver.2 cost? Can anyone supply it?
You can buy it from any certified RMS Reseller. The price varies based on
where in teh world you are. In US the end use price is about US$1,400.
Afshin Alikhani - [ email@example.com ]
CEO - Retail Realm
= = = = = = = = = =
"dexter" <firstname.lastname@example.org> wrote in message
> How much does ver.2 cost? Can anyone supply it?
...Exchange 2003 Questions #2
I already have in place my forest root w2k3 domain and will be planning to
use Exchange 2003. Our company AD structures will contain chicd domains and
another other forest domains. With trust established between forest to forest;
a. can my child domain users be able to utilize Exchange easily?
b. How about between forests will users be able to utilize Exchnage of the
other forest domain?
Appreciate any replies.
a) Yes. Definetely. Any user in your forest can have a mailbox
b) Yes, though you'll need to provision disabled accounts in your forest for
every mailbox e...IF Statement with both AND and OR Criteria #2
I'm having difficulty creating an if statement that has both AND/OR
criteria. The following statement covers the OR part, but how do I
include the AND condition?
In other words, return the value in C2 if A1=TRUE OR A2=TRUE. In
addition, F2 must = "Include"
Any suggestions would be greatly appreciated. Thanks in advance!
> I'm having difficulty creating an if statement that has both AND/OR
> criteria. T...ODBC #2
I;ve got a flat-file database I'd like to be able to access using
odbc. So that would basically mean writing an odbc driver?
Can anyone help where to start, preferably code samples etc.
I have the specs to the flat file database, so all I need is the
If your flat file is dBase format or CSV text or something standard there
may already be a driver for it. Otherwise, you'll have to write one.
Something like this:
Maybe help you get started, but it's spendy.
"Daffy D." <x666nl@yah...print 8 page 8 1/2 x 11 booklet 1/2 size?
I have an 8 page booklet that I originally intended to print 8 1/2 x 11 & set
it up that way. I now would like to print it, instead as 5 1/2 x 8 1/2. I
know the proportions will not be perfect but they will be good enough.
I have played with this for hours to no avail.
I can't get the pages to come out right. i.e. 1&8 on one side of a sheet and
2 & 7 on the other etc.
Have you tried setting up two publications; your original and a new publication?
Copy/paste each page and adjust. Using the AutoFit Options in the Format menu
h...2 of 5 barcode
Hi one of our Clients started using RMS and used the default 2 of 5 barcode.
Now that thay have labeled all their inventory and bought a Symbol 2208
scanner (USB) it would not read the barcodes on labels. The scanner reads UPC
and many other codes right out of the box. Is there anything we need to do
with the scanner for it to read 2 of 5?
It came with a utility program that fails to communicate with scanner. The
utility program prints barcodes to program the scanner but the scanner fails
to read those codes. The programming codes in the manual however are easily
read by the scanner.
...- Millionaire at 31 ... on the Internet #2
Stephan Ducharme just became a millionaire on the Internet
... and he was caught on tape, revealing everything!
Click here : http://freeadguru.com/cgi-bin/i.pl?c=a&i=33977
Rush on the page before it gets banned!
MAF Anti-Spam ID: 20060831105137X1q7YbV9
...Standard or Enterprise #2
Can anyone point me towards the differences in xchange 2003 standard and
our current db is around 14g and has grown fast. I was thinking of creating
some seperate storage groups for individual offices or departments. I am
presuming i can only do this with enterprise version only.
In order to create multiple exchange databases would i create multiple
storage groups or simply create multiple mailbox stores.
What are the limitations of the different versions with regards to multiple
servers/storage groups/mailbox stores
advise is most appreciated as always
On T...bcc problem
I have a Mac (snow leapord) with entourage 08 and when I change the
"from" address, I can't send to anybody using bcc.
If I leave the from address as me, and put in a destination address
via bcc, it works fine. If I put an email address in the To: field
and one in the bcc field, and change the from address- the email goes
through to the To recipient, but not the bcc recipient. If I open the
sent message in the sent folder, I can see the bcc address.
Summary: I can't send any email bcc if the "from" address is
Anyone seen this?
Goes throu...Pivot Table from 2 worksheets
I thought I read somewhere that you can create one pivot table from two
worksheets. Does anyone know how to do this in Excel 2003? I need to create
one and don't know how. Thanks so much.
Take a look here
Post back to this thread if you are still having problems
> I thought I read somewhere that you can create one pivot table from two
> worksheets. Does anyone know how to do this in Excel 2003? I need to create
> one and don't know how. Thanks so much.
What is the best way to filter junk mail through webmail.
We are running exchg server 2003 with webmail installed.
I know that webmail has some built in functionality under
the options tab but we are looking for something more
> What is the best way to filter junk mail through webmail.
> We are running exchg server 2003 with webmail installed.
> I know that webmail has some built in functionality under
> the options tab but we are looking for something more
Use a server-side antispam solution such as Microsoft's Exchange Intelligent...convverting time 2:30 to 2.5
How do I convert times such as 2:30 to 2.5 hour
I am trying to calculte the number of hours between time in and time ou
Example time in 12:00 - time out 14:30 = 2:30 and I want it to say 2.5 so I can calculate total hour
Time is recorded by Excel as a decimal part of a day which is why you
multiply by 24 to get hours in a number format.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
There's no need to convert. Leave...Encumbrance #2
Does anyone know of a third party ISV encumbrance product which will tracks
budget used to date beyond items entered in Purchasing. This is to say that
within the standard product: at the time of Purchase order entry the amount
is subtracted from the budget available and if the budget available falls
below zero a notification is brought up, however if an item has been
re-classed in the general ledger or accounts payable the amount is not
removed from the budget available.
...curving text #2
I'm making an oval sign for my business and the text must follow the curve
of the oval. Can't seem to do it...
Give Word Art a try. The "A" icon on the left side of the screen.
Don - Publisher 2000
"Betty Boop" <Betty Boop@discussions.microsoft.com> wrote in message
> I'm making an oval sign for my business and the text must follow the curve
> of the oval. Can't seem to do it...
I have the an example on my web site. Scroll way down
http://msauer.mvps.org/wo...RMS 2.0 #2
Does anybody know what will be new with version 2.0? Allot of press about
Vista but nothing about RMS 2.0!
This is a multi-part message in MIME format.
They just released updated brochures to resellers last week and I expect =
them to be public near the end of December for either a mid January =
release or heard Friday, maybe February (because of Vista on Jan 30)
Check Point Sof...A few questions #2
Greetings Excel Gurus!
A few questions, please:
1. I have a spreadsheet with subtotals that appear every seven rows.
Every month I add another 7 rows. I'd like to come up with a formula
that would allow me to total the subtotal cells. In other words, if my
subtotals are, e.g., in cells C6, C13, C20, C27 etc., what's the formula
that allows me to total these cells without inputting all the cell
numbers manually. There must be a function I'm not aware of that
provides for referencing cells in this manner, isn't there?
2. How does one find the last active row in a spreads...Outlook 2003 unable to access menu by right clicking on message #2
This is a multi-part message in MIME format.
We have recently upgraded from Office 2002 to Office 2003=20
on Windows 2000 PCs. Two users are unable to right click=20
on messages to get the menu options (junk e-mail, etc.). =20
It was working for them initially but stopped=20
functioning. We have tried to uninstall and run Office=20
Clean but were unable to resolve. It seems to work if=20
they select multiple messages at one time but cannot right...etech #2
It would be nice if a user could add their own problem, cause, and repair
codes from Etech. It would also be good if the user could click on a call,
but not open it, and have the call stay hi-lighted. Then the user will know
which call the notes at the bottom go to. Right now if they move the mouse
the notes stay the same but the mouse pointer will be hi-lighting other calls.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the messag...Lookup question based on 2 columns per worksheet, 2 worksheets total
I have two worksheets in a workbook, sheets 1 and 2 respectively. Each
sheet contains a rather large table that are for all intents and purposes
the same except that one table (sheet 2) has more up to date information
than the one in sheet 1.
Each sheet contains an X labeled column (column A in both) and a Y labeled
column (column B in both). The values in these columns are geographic
coordinates. What I'd like to do is add information from sheet 1 to sheet 2
based on matching coordinate pairs. For example, if on sheet 2 I have A2 =
1234.567 (X value) and B2 = 4...Average #2
I am trying to calculate the average amount of time it
takes for payments to be processed.
In Column A I have date sent
In Column B I have date Paid
In Column C I have the formula Days360
In Column D I have the formula Average
The problem I have is in column C I have the formula
running from cell C1 to C102 when it works out the
average it counts the blanks and gives out the wrong
Any help Please