password for command button?
Is there a way to code a command button in its on click event that will
prompt the user to enter a password to perform the command button's
On Jan 4, 11:34 am, Debbie S. <Debb...@discussions.microsoft.com>
> Is there a way to code a command button in its on click event that will
> prompt the user to enter a password to perform the command button's
> Thank you.
Yes, but you'll need to delve into VBA. Attach a click event to the
button and in the code:
Public Function Button1_Click()
...Letter Writing assitant to be used with Prospects
Would like to see Letter Writing Assitant to be extended to be used with
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=73b8a531-e5c3-4d8b-91ae-5b1758b9f1a5&...Customize Current View: Filter Problem
Using Outlook 2002, I have created a category called "Hidden" i
outlook. In my calendar, I put all the appointments I don't want t
appear in this calendar (i.e. daily reminders).
I then filter out all these "Hidden" items by selecting --
Customize Current View-->
Hidden (the category I created)-->
Edit these criteria directly-->
And then I change:
("DAV:isfolder" = false AND "DAV:ishidden" = false) AN
("urn:schemas-microsoft...Can E-mail recipient policy be linked to the OU membership?
Running Exchange 2003 (mixed mode) and Windows 2003 server (Windows 2000
I'd like to create a e-mail recipient policy that is linked to the different
OU's that are created on the system.
Is it possible to link the policy to a specific OU or do I need to create
groups on the AD to control which recipients a policy applies to?
Yes, you can create a recipient policy that looks to just a specific OU. It
is done through LDAP queries. Here are some references to articles and
whitepapers that discuss how to work with recipient policies.
HO...Outlook Send/Receive mail SLOW
When I receive/send email, it loads sends/receives
extremely slow. The percentage indicator when
receiving/sending starts at 3-5% and stays that way for
awhile. After several minutes, the mail eventually comes
Any reason for this?
...Using mouse wheel in VB editor
Just tried using the mouse wheel to scroll within visual basic editor in
excel but it wont let me. How can I turn this feature on. I am using Excel
Thanks in advance.
This is a known problem with the latest MS mouse drivers. You
can either install version 4 of the drivers (current version is
5), or use FreeWheel, and freeware program at
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"fullers" <firstname.lastname@example.org> wrote in message
ne...Send to certain person using specific email account
I send an email to a certain receipient but don't want to use the
default email account.
Is it possible that when I send to them (plain text) , that it will
choose the other account I want to use to send it? Please advise how I
set this up.
I do not believe that this can be achieved automatically through standard
use of Outlook as you need to manually specify the name of the account to
send from if different than the default.
However, it would be possible using the Outlook object model. An Addin would
need to be developed that monitored each mail item prior to sending. If the
d...Word2007. Checkbox. No Form
We have a document (not a form) that we would like to use checkboxes in.
This document has a couple of sections where it would be useful if the user
could check if something is applicable. We can't protect the whole document.
Thank you for your help!
I actually used this feature in a form this morning. Although you don't say
what version of Word you are using, you can access the Control Toolbox
toolbar in Word 2003, or in Word 2007, it is on Developer tab.
To show the developer tab, click the Microsoft Office Button and then click
Word Options. S...Unable to click customizing outlook today button
Unbable to click the customising outlook today button for
Outlook 2000 install in the windows xp profession
machine. I have updated the office 200 patch 3. But it
seem remain the same problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;820575 might be
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"Clarence" <email@example.com> wrote in message
> Unbable to click the customising outlook today button for
> Outlook 200...how to match the color of a button with its background?
I have a owner draw push button. I associate it with two bitmaps, one
is down and the other is up. Is there a way to make the bitmaps's
background color match the color of the window where the button is
located. I manually choose the best matched color but still the result
is not good. I can even see a white border line (not drawn by me) when
the button is pushed. Please help. Thanks.
May Young <firstname.lastname@example.org> wrote in message news:<408473...Setting up a new e-mail account
I'm trying to set up my yahoo account so that I receive
my e-mail messages in my Outlook Inbox. I went to
Accounts, and servers, and put in mail.yahoo.com for
incoming mail (POP3) and smtp.yahoo.com for outgoing mail
(smtp). When I click on the send/receive button I get an
Dave <email@example.com> wrote:
> I'm trying to set up my yahoo account so that I receive
> my e-mail messages in my Outlook Inbox. I went to
> Accounts, and servers, and put in mail.yahoo.com for
> incoming mail (POP3) and smtp.yahoo.com for outgoing mail
&...Receiving POP3 mail into Outlook without Send/Receive
I want the POP3 mail to be received into Outlook (If open) when the mail
arrives in POP3 account. Is that possible?
Set an Automatic Polling Interval.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, delanda asked:
| I want the POP3 mail to be received into Outlook (If open) when the
| mail arrives in POP3 account. Is that possible?
...Replying to an Outlook e-mail
When replying to e-mail in Outlook, everything works fine. But when I try to
reply to an e-mail that has an embedded picture in it, Outlook won't send it.
I get the message that the e-mail was sent, but it stays in the outbox and
"Jack Johnson" <firstname.lastname@example.org> wrote in message
> When replying to e-mail in Outlook, everything works fine. But when I try to
> reply to an e-mail that has an embedded picture in it, Outlook won't send
&...Use exchange from a trusted domain
I have domain a and domain b. Domain a is all set upp with exchange etc.
Domain b was bought, and they don't have exchange. I have trust between the
domains and file sharing and authentication are ok.
What we want to do is, make users on domain b and let them use the exchange
(on a seperate storage) on domain a.
The users on domain b must logon to domain b, but need to have mailbox on
Domain a are running on win2003 and exchange 2003. Domain are running on
win2003 with forest and domain ready for exchange.
thanks in advance,
Thi...I would like to know how to set up a 'fill in the blanks' form?
I would like to set up a templet of sorts to fill in the blanks for
...Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the
database from Access 2007, but when I try to use Access 2003 it wants me to
save the database to a location. The Access 2003 has the compatiblity pack,
but it seems to not work when I download it.
So the question is using Sharepoint 2007 and posting the Access 2007 format
to it, can a user go to the sharepoint site and use a 2003 Access database
that has the compatibility pack and open without having to download it?
Message posted via http://www.accessmonster.com
Send check for $500.00 to: David A Jenn...VBA to put a copy of worksheet on the desktop 05-13-10
In my workbook XYZ I have a sheet ABC. With a button on sheet DEF I can
refresh sheet ABC. When the code finishes it job I want to add the actual
date (short European notation dmyy) and time (f.i. 241110 16.31) to the name
of the sheet (which becomes ABC 241110 16.31) and after that make a copy of
that sheet in a separate workbook and put that workbook as an icon on the
desktop of my computer. Is this possible? If so, please help me with the
necessary code. Thanks in advance for your assistance.
...I want to add a mail account without setting a SMTP server. Is it possible?
I want to add a second mail account that is outside my company.
Since the company firewall does not allow us to connect to SMTP-servers I
to add this account without setting the SMTP propertiy.
I cannot specify the company server as it is an Exchange server and the
outside one an IMAP one.
Currently I have specified the outside SMTP server since outook does not
allow me to add an account wihtout setting this.
I keep getting annoying error messages as my computer can't connect to the
Any one know a way around this?
The company server has SMTP enabled, u...How to add a button to restore all altered cells original values?
I want to add a reset button to an excel spreadsheet that will restore the
values of all changed cells to the original saved ones.
Any help would be appreciated.
this would require quite some VBA code as you somehow have to store the
original values for example on a separate hidden sheet
"Dawnybros" <Dawnybros@discussions.microsoft.com> schrieb im
> I want to add a reset button to an excel spreadsheet that will
> values of all ...How Use ShellExecute with a CMemFile
I need to store files of various types (such as .doc, .xls, .jpg, .pdf,
..wmv, ...) in a database. Upon retrieval of such a file I have the file as
data in memory in a CMemFile. I need to then "display" the file in the
aproriate application. If I were to write the CMemFile to disk and create
an actual file I could then, of course, use ShellExecute() to launch , say
Word to display a .doc file.
However, I would much prefer to avoid the overhead of writing the data to an
actual file and then dealing with having to detect when the User is done and
cleaning up the file I had ...Need to add to current formula
I have this formula that will cause values to change based on the mont
that is referenced in the formula ($L$1). Currently the formul
I need to add August, September, October, November, & December to thi
formula but excel is not allowing me.
Does anyone know how I can get around this? Oh by the way
November thru April =2, May and October=4 and June thr...Saving e-mail & attachments when upgrading
I'm upgrading from NT4 to XP Home and the only data I need
to keep are the emails & attachments. I have to format the
hard drive to eliminate the partitions. This machine is on
a network and I can save to the other machune.
Look here for all the information you need on backup and restoration of
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Mike" <email@example.com> wrote ...Can i use conditional formating on a cell when it contains a formula?
I am trying a "conditional formatting" on a cell that contains
formula, but it didn't work.
"If cell value is equal to 0 then font - white" This doesn't work,
If i use this condition on a cell without formula it works just fine.
sit's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=262
View this thread: http://www.excelforum.com/showthread.php?threadid=26784
are you sure your formula returns an exact zero?. Could you post the
formul...how to install Microsoft Mail to Outlook 2003
I found 'this' (http://www.outlook-tips.net/howto/msmail.htm) on
I don't know if it works...
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Search for answers: http://groups.google.com
Most recent posts to the Outlook newsgroups:
...Using INDIRECT within functions
I learned a bit from JLathman in a previous post but tried to use the same
methodology with this formula (also learned from this Group to get the last
entered value in a column) without much luck.
The original formula was this with 2009 sheet being static:
Trying to make it dynamic I tried the following without success:
=LOOKUP(INDIRECT("2,1/(" & O1 & "!$H$3:$H$65536<>"")," & O1 &
Did I miss something or are...