protecting sheet with combox
i'm trying to protect a sheet with a combo box in it. the combox list a
bunch of values. each value you pick is linked to a formula which
changes a price value in a different cell. i would like to protect the
sheet so that the money value that appears in the cell can't be changed
by the user. whenever i try to protect the sheet i then can't change
the values in the comb box . i want to be able change the values in
the combo box but have the formulas and automated cells protected. any
~~ Message posted from http://www....Password Protect Two Sub-contact Lists
I have a regular contact list, and within this list I have two
subcontact lists. One is personal, and the other is personal business.
How can I password protect the personal and personal business lists?
Thanks for any help!
Sorry, I just realized that there's a newsgroup dedicated to contacts.
I'll post this there.
> Hi everyone!
> I have a regular contact list, and within this list I have two
> subcontact lists. One is personal, and the other is personal business.
> How can I password protect the personal and...Multiple hyperlinks from drop down box
I am an excel beginner and this is my first time posting on this site.
I have no experience with macros, and am only just starting to learn
the ropes of other basic functions.
Currently I have multiple worksheets set up. I want to create a drop
down box in a worksheet that has 5 car dealership names. From this
drop down box i want to be able to click on each one of these names and
have each one be a separate link to a different spot on a different
I have a worksheet called "Brand Names". On this worksheet i want to
create a drop down b...Passwords #5
I would like to password protect a workbook so that when
the workbook is selected to open a dialog box pops up
asking for the password and after the password is entered
correctly the workbook will then open. Thanks for the the
Todd, do a save as and look under options, depending on what version you are
using and set a password to open
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address t...Outlook 2007 mail Icons and their meaning
How do you get a list of the mail Icons and their meaning
"GrahamAIC" <GrahamAIC@discussions.microsoft.com> wrote in message
> How do you get a list of the mail Icons and their meaning
...Checking Outlook mail from other locations
What is the URL for accessing Outlook mail from another
> What is the URL for accessing Outlook mail from another
> computer? Thanks!
No such thing.
Stacy <firstname.lastname@example.org> wrote:
> What is the URL for accessing Outlook mail from another
> computer? Thanks!
If you actually mean what you wrote above, then you'll need a program like
VNC, pcAnywhere, or gotomypc to access your PC from another location. If
you mean you want to access your mailbox, if your mailbox is on an Exchange
server, you can use Outlook Web Access to read your...E-mail link in Outlook message
Typed "email@example.com" in an HTML Outlook
message. It looked fine in the message but when
recipients clicked on it, the e-mail address was changed
to "firstname.lastname@example.org"--just one character
different but of course their e-mail was returned
undeliverable. I looked at the source code in the
original message and it was
Does anyone know why or how this would happen and how to
prevent it? Thanks.
Yes, the link did exactly as it was told to d...Passwords
Hi, I have a password field in a database. How do I set it so that a
user can only type in 7 characters for a password. and if they type
more an error message will appear?
> Hi, I have a password field in a database. How do I set it so that a
> user can only type in 7 characters for a password. and if they type
> more an error message will appear?
You may use the ValidationRule and ValidationText of the field in the
table design view. Setting ValidationRule to Len([YourField])>7) will
raise an error in your case.
--> stefan <--
...Problem receiving mails using VPN
I have a problem updating my folders in Outlook 2003 when I'm using th
VPN at home to connect to the Exchange server. I can however send email
with no problem.
Outlook states that I'm connected. When it tries to update the folde
showing the status "Waiting to update this folder" the Outlook icon i
the system tray tells me that "Outlook is requesting data from th
server" but nothing happens.
I can ping the IP address (and server name) of the Exchange server.
When I create a new message and try to look up the recepient from th
addressbook outlook freezes. So...Enforce Combo Box Selection
I've got this code in the RowSource property of a combo box called cboLocale.
It restricts the choices in Locale based on the users selection in
SELECT DISTINCT LOCALE, CLIENT_ID
The problem is, in the On Exit event of cboLocale, I have this code:
If IsNull(Me.cboLocale) Then
Cancel = True
MsgBox "You must select a locale!", vbCritical, "Error Notice"
In many cases...Recipients problem in received mails
We're using Exchange 2003+SP2 in mixed mode with Exchange 5.5 SP4.
Most of the user mailboxes already moved to new Exchange server.
Since the move some of the people started getting mails that do not have in
To: field the real recipient name but another user name from the
organization. We started thinking how come the user gets another user's mail
because there was only one recipient name in the "To:" field. When I checked
the Exchange server, I saw in Message Tracking Center the message that came
to that user was actually intended for couple of users but the Outlo...Combo boxes #12
I have a combo box in a form that lists all of the countries. I am
trying to set it up so that if the user presses the first letter, it
goes to the name of the first country with that letter and then if they
press the same letter again, it goes to the next country that begins
with that letter. I have the first part working, but the second part
is not working. I press a letter once and it goes to the first country
beginning with that letter, but when I press it again, it doesn't go to
the next one. Is there a property to set in the form for that combo
box to make it do this?
...How do I import e-mail files into Microsoft Publisher 2003?
I receive files thru the internet that I need to get into publisher and
change the size, or add data. How do I save them to get them into Publisher?
How do I get Word files into Publisher for editing?
"Publisher Fan" <Publisher Fan@discussions.microsoft.com> wrote in message
>I receive files thru the internet that I need to get into publisher and
> change the size, or add data. How do I save them to get them into
> How do I get Word files...please help: pop3 connector does not deliver mails
hello, i have trouble with sbs2003 server and exchange. everything was
working fine about 3 years (until last week problem occured). i searched for
any help on internet but still can not solve.
my problem is with pop3 connector. it recieves mails from isp but does not
deliver to the user mailboxes. event log reports 1060,1061 and 1062 errors.
(error id 1060 is talking about smtp server does not working, but exchange
can send-recieve mails between inside users)
what am i missing? please help...
You may want to start with this KB article about troubleshooting the ...Keep user passwords
We've just finished installing a new Exchange server and connecting it to a
separate DC. We used to have everything on the same server but we'd like to
be able to scale our solution better in the future - therefore the new
setup. Users are primarily connecting to Exchange by means of RPC over HTTP
from clients that are not part of our AD.
The old setup allowed users to save passwords if they configured their
clients to use NTLM authentication and followed the directions in this
This worked both for RPC...How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the
password. Is there any way that I can gain access to my worksheet?
There are tons of FREE good Excel password 'cracking' tools. Your favorite
search engine should get about a gazillion hits on a phrase like "crack excel
password" or "excel password cracker".
A good one that many report great success with can be found at:
> I password protected an Excel spreadsheet and now can't remember the
> p...how to find a single word in Live Mail ?
I am having this problem : since a few days, I'm receiving the same spam
mail by hundreds per day. In the subject header, it reads : "hi" (without
the brackets). Since my spamfilter does not stop the mail and I am not able
to construct and use a message rule (this is message seems to protect itself
against that), the only thing I can do, is receive the mails and then filter
them out, using the search function.
But when I type in the search box for header : "hi", it returns not only the
spam messages, but also all the messages that contain "hi"...Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help
You can prevent un authorised access by giving a password to open the
workbook itself, so that no one else can open it (Go to Tools, Options and
then Security Tab). You can do it there if you have already saved the file,
or you can go to "save as" then "Tools" and "General Options" where you can
On the other hand you can protect work sheets and ranges for different
people by using "Tools" and then "Protection" Tab
M Imran Buha...How to protect cells?
I would like to protect a range of cells (A2:D24) with a password for a
group of users that would make changes to cells in this range. Then on
the same sheet, also protect a range of cells (E2:E24) from everyone but
me. Is this possible?
Please don't multipost.
See the thread in .programming.
"Mark F." <email@example.com> wrote in message
> I would like to protect a range of cells (A2:D24) with a password for a
> group of users that would make changes to cells in this range. Then on
> the same she...Outgoing mail server reset
I have three pop3 accounts configured on my outlook 2003.
Each of the uses a unique outgoing mail server. i.e.
mail.server.com; pop3.server2.com; emailserver.com.
Since yesterday, every time I close outlook all outgoing
servers are resetting to "localhost".
I am not aware of any changes made on the computer, no
viruses found by AV, no other strange behaviour.
Your virus software. Turn it off. I had the same problem drove me nuts.
"Ran" <firstname.lastname@example.org> wrote in message
>I have three p...remote users sending mail through Exchange
I have 5 users who travel frequently and need to send outbound mail through
our Exchange Server. I have SBS 2003 premium/Exchange 2003.
Is there a simple way to setup the Outlook clients to be able to send mail
through the Exchange Server? I know that it can be done with RPC over HTTP
but that requires XP Pro, Outlook 2003. These clients are running W2k Pro and
Outlook XP (2002).
Any help is greatly appreciated!
Chris Linscheid wrote:
> I have 5 users who travel frequently and need to send outbound mail
> through our Exchange Server. I have SBS 2003 premium/Exchange 2003....Password
I am working with publisher 2007. I finished my site last Dec. and went to
It is not letting me make changes because it does not like my password. I
can not figure out how to go in a reset everything from my provider.
I was also trying to see if I could find web publishing wizard, which
doesn't seem to exsist with 2007.
If you are saying you forgot your password then contact the ISP Tech Support
and they will reset the password to something like 1 2 3 4 or something
other that is very simple. They will also instruct you to change it to
somethin...windows mail blocked senders list
How can I pull up the list of blocked senders on my computer
Tools | Junk E-mail Options | Blocked Senders.
Imperial Beach, CA
"RB" <RB@discussions.microsoft.com> wrote in message
> How can I pull up the list of blocked senders on my computer
How to send a group mail to all the addresses in address
book and I want to display only their address in their
mails. I dont want to show entire list of all addresses.
Please let me know.
...format combo box list
I have a combo box list in a form, I was wondering is there a way to
change the color of some of the records listed in the box. Like I
want to flag certain records as closed and change the color to red
leave the rest of the list in black font.
Already answered in another newsgroup to which you posted the same question.
If you feel you need to post to more than one group (HINT: it's seldom
necessary), please have the courtesy to cross-post (send the one message to
all groups at once), rather than multi-post (send individual messages to
each group). In this way, all ...