When I am in one cell highlight another
When I am in one cell highlight another. Lets say that if my cursor is in
A1 I want D1 highlighted or with another cursor on it.
Then if I move to A2, D2 should be the one with another cursor or highlighted.
Thank you for your help,
Jose Juan Diaz
hi, Jose Juan !
> When I am in one cell highlight another
> ... if my cursor is in A1... D1 highlighted or with another cursor on it.
> ... if I move to A2, D2 should be the one with another cursor or highlighted.
'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' wh...user created shapes non printing
I started have a problem with vision 2002 that I have not noticed
before. When I create a new shape, by default, it assumes the
non-printing properly under FORMAT � BEHAVIOR. Also if I group a set
of "printing" shapes the group will become non-printing. Can I change
How are you creating the new shape? Also are you using layers in your
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert" <email@example.com> wrote in message
news:9ec427f7.0409231005.576...Copy field data to multiple places
Newbi here.... I have a access 07 file of about 1000 records (rows) and a
field (column) I'll call the "project number". All the records do not have
the project number inserted as of yet. Is there a simple means to insert a
project number in say 50 records at a time, another project number in
another 75 records etc. Copy/Paste will do it but may take months to enter.
Any suggestions appreciated. TIA
On Wed, 27 Feb 2008 15:31:05 -0500, "Meebers" <firstname.lastname@example.org> wrote:
>Newbi here.... I have a access 07 file of about 1000 records (rows) and ...Process all cells in a (user) selection
I am using this code to give me cell by cell access to a code defined
Dim aCell As Range
For Each aCell In Sheet4.Range("A4:A34")
' Do Stuff Here
which processes every cell in the A4:A34 Range
How do I do the same thing for a selection drawn by the user before
pressing my 'Process' button ?
On 05 May 2010 11:10:21 GMT, Isis <isissoft@NOSPAMbtinternet.com> wrote:
>I am using this code to give me cell by cell access to a code defined
>Dim aCell As Range
>For Each aCell In S..."All users" "Programs" create/modify shortcut from app...
I've created two shortcuts into "Programs" folder for "All Users"
It lets me to get them available for all user.
Application running in "User" context needs to delete and re-create such
links but it fails due to an "access denied" ...
Settings correct permission to such links it starts working as well
I've created links using the IShellLink/IPersistFile sehll interfaces.
So, I actually need to have link under "programs" for "All Users" which
might be modified by application running in "Users"...How to filter to show only one message from a specific sender/subject
I would like to filter out all but one email with the same subject
line from a specific sender.
I subscribe to a message board that sends an email every time a
posting is made to a thread, instead of just the first posting after I
have read the thread. Is there a way for filter out the duplicate
messages and just keep the oldest email?
...User status in Sharepoint 3.0
I see there is a user status that works with Office Communicator. Is there
away to do this with out office Communicator or free software to do this? We
are a small company with about 10 users.
Nothing I'm aware of. This is built in integration with the OCS platform.
Daniel A. Galant
Imagine what we could be... if we could just imagine.
"todd" <email@example.com> wrote in message
> I see there is a user status that works with Office Communicator. Is
> away to...Accounts and Contacts 01-30-04
I have installed the 1.2 version on a test server to look at and have a
I can allocated contacts to accounts, and I can allocate quotes to accounts
or customers. However, if allocate a quote to a contact, I cannot see the
quote from the contacts associated account sales screen. If I allocate the
quote to an account, I do not know which contact in the company that I sent
I assume I have missed something obvious here. In other CRM packages I have
looked at, the links between contact and company (account) would allow this.
Our customers are all hospitals in the UK with ...Change color of multiple autoshapes
I need to change the color of several autoshape based on different cells
I know how to change one autoshape using a worksheet_change event
but i can't just copy and paste this and change the object name + cell name.
is it possible to have multiple worksheet_change events in the same
You have only one worksheet_change event, but in it you can test to see which cell was
changed with something like
If not Intersect(Target, Range("A1") is nothing then
' do range A1 stuff here
If not Intersect(Target, Range("A2") is nothing then
...How do I add multiple times together
Hi does anyone know how I can add multiple times togther and get the anser in
hours and minutes. I have formatted the cell for time however when I atosum I
keep getting an answer that is incorrect. Any help?
Maybe it was just a formatting problem.
Try a custom format of:
Playhouse pm wrote:
> Hi does anyone know how I can add multiple times togther and get the anser in
> hours and minutes. I have formatted the cell for time however when I atosum I
> keep getting an answer that is incorrect. Any help?
...Problem with printing listbox bigger than one page
I created form "Invoice". It contains few list boxes (like: Brand,
Product, Price, etc.). Each list box is big enough to display 50
items. It works in this way: user is chosing product from table
Products_tbl and clicks on "Add to invoice" button which adds to each
list box new item containg apropriate information about chosen
product. At the end, user can print the form. Before it was limited,
and user could put max. 50 products on one invoice, but I wanted to
get rid of this limitation. I did it in this way: after 50th item,
with each added product I extend list boxe...Combine part of text from one col to another
I'm trying to combine only part of a string from one column with all th
text of another column.
For instance I want to create usernames to log into a network. If col
has Bill and col2 has Smith I want to get just the B from col1 an
combine it with col2 to make smithb in a new column.
Thanks in advance
Message posted from http://www.ExcelForum.com
Please keep all correspondence within the Group, so all may benefit!
"epac135 >" <...uploading 2 or more mailboxes on 1 user account
I was able to reconnect 1 mailbox to 1 user account, but what i'
looking is the way wherein i can reconnect 2 or more mailboxes into
user account because instead of giving a 1:1 user account to eac
person we will be replacing it and giving them an account per area
Hence they already have their own personal account we will b
deleting it; How can i put all their messages from their persona
account into the single account that we wil be giving to them
More than one mailbox per account is not possible in Exchange 200x. You can
do that with Exchange 5.x
Menko den Ouden
...multiple instances of IE on same site
I have winxp and use IE 8. My problem is that I have 2 usernames on some web
forums. I used to be able to login using both usernames and have both
instances running simultaneously. Now I can't. Everytime I'm logged in and
try to initiate another instance the username just changes. It does not allow
me to open 2 IEs with 2 usernames at the same time. I'm pretty sure this is
just a setting but I don't know where it is. The reason I think it's an IE
setting is that when I try to login with a competitor browser as the 2nd
user...it allows it. Any help would be gre...Multiple entries in CRM Contacts when viewed from Outlook
We have an odd problem going on here with this.
When we create a new E-mail in Outlook, select the To button and the CRM
Contacts, it brings up the list of contacts from CRM that we can select
from. All good so far.
The problem is that each contact appears several times and it's different
for different users.
For example, every contact appears 6 times for me. It makes for a very long
list. All of them are valid and any one of those 6 can be selected and the
address will be correct and it will track against the correct contact.
Other users have anywhere from the correc...replacing a credit card account with a new account with same institution
My credit card was just replaced causing some credits and debits on
the old account and transferred to a new account. Do I need to merge
these accounts? When I update the accounts I only get a balance on th
enew account and no transactions. Any advice would be appreciated.
In microsoft.public.money, firstname.lastname@example.org wrote:
>My credit card was just replaced causing some credits and debits on
>the old account and transferred to a new account. Do I need to merge
>these accounts? When I update the accounts I only get a balance on th
>enew account and no transactions. Any advice...Importing One Period
Our company operates on a 13 period year instead of 12 months. However, the
budget import process appears to be the same for periods or months.
We would like to import a budget for just period 13. We tried leaving
blanks in the period 1 - 12 accounts in excel and imported to a test company
and that deleted all budgets, we also tried zeros, which did as we expected,
The budget file used to import existing budgets for periods 1 -12 has become
corrupt and we do not have a backup for this file. In this file, we created
formulas that allow us to use %'s to update ...adding another user on same computer
Hi, I have made amew user on my computer so that the woman I live with=20
may use my computer without the danger of corrupting my files=20
When we go to the dock on her side - and that is the side from which =
am emailing you - there are two question marks where the icons for 'word =
and excel would have been. How can I get this corrected?
Just drag the question mark to the desktop and you will find them vanish.
Next drag the Word and Excel programs to the dock and you will find it
"email@example.com" <anonymous@dis...Excluding multiple checking accounts from budget totals?
Running Money06, and I have two checking accounts synching through Bank of
America. Everything there is working well, but one thing that I dont like is
that the totals for BOTH accounts are added together.
I have two accounts, 'personal' and 'class', and both accounts are shown in
the net balance statements, the 'spending by catagory' chart on the home page
I would like to keep synched with my class account, but want it excluded
from all of the balances.. any suggestions?
"Raichean" <Raichean@discussions.microsoft.com> wrote in mes...Multiple recipients for one address
Total newbie question.
I work for a company with a dedicated service department. I need for up to
5 people to be able to get a copy of a message that comes in to the address
"firstname.lastname@example.org". I tried adding this address to each of the users,
but I can't give one address to multiple users. I don't want to create a
"Service" user and have them check that account. I just want the emails to
be routed from the service@ address to each users' inbox.
Total newbie, so detailed answers would be appreciated.
Thanks in advance.
Create a mail-enabled Grou...Problems Sending Messages to domains w/ multiple MX records
Got a question for the Exchange experts out there. We have a wierd situation
occuring where e-mails we send to domains w/ multiple MX records either do
not get through or the recipient receives the message multiple times until
we manually delete the message in the ESM/Queues. All other messages get
through fine. We have come to this conclusion (problem is with multiple MX
records) by testing the domains we are having problems w/ using
www.dnsstuff.com DNS Lookup tool for MX records. All of them come back w/
multiple MX records.
Here is what has changed recently: We moved to a new locat...Download imports into wrong account
A while ago i incorrectly selected an account to download into and cannot get
rid of it for the life of me. The association with the wrong account sticks.
What happens, I download from institution A. I selected that should be
institution B and it always puts that download into the account for
institution B. I'd like to break the link to institution B so it will
correctly put it into the account for A.
I've tried going through and renaming accounts to no avail. I've downloaded
the OFX files and played with changing account numbers in them, also no luck
Any help much appr...Multiple SMTP connectors in the queue for exhange system manager 2k3!
Starting today I�m getting reports from the monitoring service on SBS2k3
SMTP Server Remote Queue Length Alert
A large number of messages are pending in the e-mail server send queue.
Verify that you have Internet connectivity. If you can view Web sites
normally, contact your Internet service provider (ISP) to determine if there
is a problem with their e-mail server.
You can disable this alert or change its threshold by using the Change Alert
Notifications task in the Server Management Monitoring and Reporting
Well, off I am into the queue in exchange systemmanager...I'd like to do a mass update of salesperson ID against multiple c.
I'd like to do a mass update of salesperson ID against multiple customers.
My customer is manually updating the salesperson ID against each customer.
They are replacing the existing ID with a new ID. Same IDs occur against
multiple customers. To speed things up they would a mass update feature. Is
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 sugg...Deleting inactive accounts that have zero balance for entire year
How do you delete inactive accounts that have a zero balance for the entire
year? We have an account that is inactive that carried over into 2008 that
will have no postings in 2008 that we would like to delete. Thanks for all
help in advance.
From GP - Cards|Financial|Account>>>type in the account you want and click
the delete button.
That is the cleanest way out.
"Dave Christman" wrote:
> How do you delete inactive accounts that have a zero balance for the entire
> year? We have an account that is inactive that car...