Hyperlink on longer automatic
Word 2007 and Excell 2007, e-mail address no longer a hyperlink
(automatically) as I type. Why? Also in 2007, where I go to to change the
color and format of the hyperlinks (i.e. customize).-
learning keeps you young
Click the Office button, and then click Word Options. In the Proofing
category, click AutoCorrect Options. On the AutoFormat As You Type tab,
under "Replace as you type," select "Internet and network paths with
hyperlinks." Click OK twice.
To change the color of hyperlinks, modify the Hyperlink and
Stefan ...Combo box or list box
I can't figure out why the linked cell only returns a # value of the
selected cell in the range. I just wanted it to return the actual text
of the selection. I would think this would be the default, but I know
Please help this is really frustrating.
famdamly's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29382
View this thread: http://www.excelforum.com/showthread.php?threadid=500004
Well, that's how they work! You can use a Match or Lookup formula to...Transparent Text Box Over Another
I am trying to place a semi-transparent text box over a
document. The problem is that the text in the underlying
boxes moves around the new box rather than staying fixed
where they are. How can I fix this?
I'm curious - what do you mean by "semi-transparent"? Do you mean something
like a watermark?
JoAnn Paules - MVP Microsoft Publisher
"Cindy" <email@example.com> wrote in message
> I am trying to place a semi-transparent text box over a
> document. The problem is that...Using Count Formual with checked boxes
(2nd Posting -- just in case the first request did not Post correctly)
I have a form in Excel that has boxes within cells F8:F27. When you click
on the box, it inputs a check mark. I would like to use a formula to count
all boxes that are checked (actual check mark)
Can anyone help me, please?
If the boxes have been created through the option in the Forms menu, then
one can supply a cell link cell in the Format control box. The cell link
will display as TRUE when the box is checked. Then one can use the
=countif(range,true) to count ...Message Box 01-12-10
I have a form but need it to have a pop up box with certain conditions.
Example: The message box will only pop up if reason code =1, platform= QL
I would like the message box to pop if all of the above are true and say
Please check elegibility on another platform.
Is this possible if so please send me in the correct direction.
This should certainly be possible. The part I'm not entirely clear about is
this statement: "Please check elegibility on another platform". Do you want
to disallow the combination of reason code =1, platf...template no longer blank
At some point I must have saved over a template so now when I open a "new"
document the template appears with language. How can I delete this and
return to a blank template? I've tried saving this to another file but have
had no luck.
Microsoft Word MVP
"baffled" <firstname.lastname@example.org> wrote in message
> At some point I must have saved over a template so now when I open a "new"
&...URLs in Outlook 2007 no longer active
Using Windows Vista Business Edition with MS Office 2007 / Outlook 2007.
A few weeks ago, Outlook was working fine ... notification messages from
PHPBB included a clickable URL.
Clicking the URL (blue & underscored) would open a PHPBB webpage containing
the PHPBB message itself.
Then after removing expired Anti-Virus program and installing AVG Free
Anti-Virus ... the notification messages from PHPBB are no longer active,
but still present and it still works on other PCs with the same Software
If the URL string is copied & pasted into an IE7 address bar the correct
...Changing Data In a Drop Down Box
Okay, I'm very new to buttons, drops downs, etc.
Here's my beginners question. I have a spreadsheet with a drop down box.
I want to add an entry to it. How do I do this?
Thanks SO MUCH for your help!!
Is this a dropdown menu in one of your menu bars, or is it a dropdown
list in a cell?
If it's a data validation dropdown list in a cell, choose
Data>Validation, and see what the list source is. If the list is typed
in the dialog box, add another item to the typed list.
If the list is in a worksheet range, add your item to the worksheet
list, and change the cell refe...Filter Combo Box Listing
I have a form with the first four fields named "FirstName", "LastName",
Phone", and EmailAddress". The field "EmaiAddress" is a combo box. The row
source for this CBO is a table named Email.
The table Email has five fields: "EmailID (PK), "FirstName", "LastName",
"FullName" (first and last name concatenated), and "EmaiAddress".
When I first open the form to enter NEW information, I key in the FirstName,
LastName, and Phone fields. I then tab to the fourth field called
EmailAddress (the CBO). I&...vs toolkit
hi, I'm using visual studio toolkit, vb is my language. i have created a
local field that is a drop down list in a modified form in GP. I'm trying to
access the selected value of the field in visual studio add in by this code:
This both returns the selected index of the drop down field, how can I
retrieve the selected value just like in win forms like:
This is causing error, it dex bridge does not recognize method selected item.
...Scanner & Camera Wizard no longer works
Whenever I'd plug my camera into my pc, the wizard would start and made
downloading the pictures & any video files I had very simple. I have NO idea
what has happened or what I did but all of a sudden the wizard no longer
starts when I plug my camera in. I've tried the following;
Open Explorer, found the camera, r/click and selected Properties, then
selcted Event Tab and selected Start Microsoft Scanner and Camera wizard.
Plugged my camera back in, turned it on and nothing... the program did not
Opened Control Panel, Scanner & Camera, plug...Publisher Templates no longer availiable for selection?
This has been going on for a few months... I need a solution though.
When I create a new document, I no longer have the option to select a
template... unless I do it from the 'change' template method once the Blank
document is created. This in itself I can live with.
But MY Templates.... ones that I created are no longer available. I can
browse to the template directory... but that's not a real solution.
Have I checed a wrong option somewhere?
Why would MY Templates disappear and how can I get them back?
It was on fire when I sat down on it...
That's my sto...Need Help with drop down list with conditions...
I need help.
I'm having a very difficult time creating a sequence of list which change based on the item selected on the main list, lets call it the index:
The Index list, the first list, would define vendors. In this case Hotel Companies (e.g Hilton, Marriott, Sheraton).
The following list, the 2nd list, would define properties, but the properties would vary based on which hotel company is selected (e.g. If Hilton, then "The Plaza, the Waldorf Astoria. If Marriott, then Marriott Marquis, Marriott Convention Center etc etc...) on list #1.
And Last but not least, the 3rd list would...Landed Cost
Even though this may go against the intent of the Landed Cost feature in
Microsoft Dynamics GP, I would like to suggest including the ability to add a
Landed Cost to a drop ship PO.
The landed cost feature is a potential workaround for adding other costs to
an item, like use tax, but it isn't currently available with drop ships.
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 t...WLMail no longer signing in automatically
I can no longer sign in to WLMail automatically after start up.
The sign in box appears with my e-mail address entered when I open WLM after
a reboot (with remember password ticked). After entering password and
signing in, I can then open WLM automatically without problems, until the
Using CCleaner as a cookie manager, I have made sure that anything relating
to "live" is in the "Cookies to keep" column.
Similarly, my .net passport is removed in the same way (although
passport.net is a retained cookie).
Had a similar problem before ...make box not visable
I need a code for
box 35 not visiable.
Me.[Box 35].Visible = False
"Chey" <Chey@discussions.microsoft.com> wrote in message
>I need a code for
> On click
> box 35 not visiable.
In the 'Onclick Event' add
> I need a code for
> On click
> box 35 not visiable.
...Missing payees in drop down list
I'm using Money Plus and I can't bring over new payees to the drop down list
when adding a transaction. All payees are in the payee list in "account
tools/catagories&payees" but they don't show up in the drop down list.
However if I manually start to type them in, auto complete will show them.
I've tried changing the name, deleting, and adding as new, but neither option
brings them to the drop down list. Any help is appreciated.
I've managed to discover my error. When looking in my Account Register and
seeing Payees in question I noticed as I right c...can't resize a text box basic
I am creating some software flow diagrams. I add a box and try to add
some text. I want the text to be on the box but it ends up being
really long and I can't figure out how to re-size it. It ends up
being too long. It disappears when I go back to working with the
box. When I go to text mode then the text box is too long but I can't
figure out how to delete it or resize it to fit on my box. Then I go
back to the shape mode and the text box disappears.
Have a look at this post:
If you haven't come a...Word 2007 - Windows 7
We generate reports that contain still images of AVI animations. It used to
be that we could drag and drop the AVI file into the document and a graphic
image would appear; now all we get is an icon. I believe this occurred as
the result of an upgrade to Window2 7 form XP SP2.
We'd like to retain embedding the video as it can then be activated by a
click should the reader decide to do that, but what happened to the still
image? I expect it's something really stupid that I've forgotten, but you
...No longer going into Hibernate.
I am running a Windows 7 Professional x64 system that used to go into
Hibernation without any problems.
However, since replacing my system drive with a SSD, my computer will no
longer go into Hibernation. Rather, it just goes to the lock screen.
The SSD is the drive on which Windows us located.
The SSD is seen as a removable drive. Could this be the issue?
My complete system settings are included in my signature.
OS: Windows 7 Professional (64-bit)
Office Suite: Microsoft Office 2003 Professional SP3
---------------------------...Can no longer load Outlook 2000
I have Windows 98 and have been running Outlook 2000, with
no problems, for a year. Now, all of a sudden, the
Outlook startup screen comes up and then it freezes.
Don't know that my computer specs matter, but: 160 MB RAM,
Cyrix II processor
Have you done a Detect/Repair?
Tried closing any other running apps?
"Claudia" <email@example.com> wrote in message
> I have Windows 98 and have been running Outlook 2000, with
> no problems, for a year. Now, all of a sudden, the
> Outlook startup screen comes up a...cannot get dialog box to disappear
I continue to get an hour glass and cannot get dialog box to disappear. I t
continually asks to grant access or not.
"bud" <firstname.lastname@example.org> wrote in message
>I continue to get an hour glass and cannot get dialog box to disappear. I t
> continually asks to grant access or not.
What dialogue box? What version of Outlook? What account type? What are you
trying to do? What is asking? Rather a lack of details here.
Brian Tillman [MVP-Outlook]
...user form drop down box
I am creating a user-form for data entry into a particular worksheet.
For one of the fields I'd like to have a drop down box (which I can figure
out how to get there) with two choices to pick from (which I can't figure
out how to get the choices to show up).
Can someone please tell me how to get the choices to show up in the drop
down box of a user form?
Private Sub UserForm_Initialize()
.Style = fmStyleDropDownList
.ListIndex = 1
HTH. Best wishes ...Display cell contents in a text box (shape) and linking
below macro grabs the contents of cell B7 and displays it in a text
box (shape, not a control!). How do I have to re-write the code to
have the contents of the cell linked to the contents of the shape.
That is, whenever the cell contents changes, the contents of the text
box is to be updated as well.
Help is much appreciated. Thank you very much in advance. Regards,
28.5, 96.75 _
Selection.Characters.Text = Range("B7")
With Sel...Forms Combo Box
Does anyone know haw to make the Forms Combo box font
No can do.
You could try the Controls toolbox one, but not recommended if usin
several controls because these ones are very buggy. More properties
Message posted from http://www.ExcelForum.com