Returning cursor to first cell, next line down
I am using a handheld scanner to record asset/serial numbers of hard ware. I
scan 4 cells worth of data (across) and I would like to find a shortcut or
macro to return the cursor to first cell, next line down. Any ideas ?? I have
scoured the Excel help on the web etc. with no luck. I am using Excel 2000.
Make sure you save a copy of the file to try this as I am not sure what else
you are doing... right click on the sheet tab and select 'View Code' and
paste the code in the window that pops up.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersec...Using Delivery options to forward email to outside address
NT 4.0 Domain. Exchange 5.5. How can I configure an
account to forward email to an outside email address such
as a users home address.
Thanks in advance
Set up a custom recipient for the external address. Use alternate delivery
on the mailbox properties to deliver to the custom recipient. Then hide the
custom recipient from the GAL if you wish.
James Raaymakers wrote:
> NT 4.0 Domain. Exchange 5.5. How can I configure an
> account to forward email to an outside email address such
> as a users home address.
> Thanks in advance
Thank you very much.
>...No options for bottom status bar in portfolio manager
I am not sure when this started but I am running Money 2007 Deluxe under
Vista Business and I see that I no longer have any positions in the bottom
status bar when I view the Portfolio Manager. I used to be able to pick
three items to display such as Total Return, Daily Change, and how the SP500
did that day. Now it is blank. If I go to Tools - > Settings ->
Investments -> Portfolio Manager... and then the Status Bar tab I can check
whether to display or hide the status bar and then select three Positions.
However each position had a drop down menu that is completely empty. ...Pulsating Cursor #2
Can someone tell my how to eliminate the on - off pulsating which occurs
when my cursor is in either of the Address Windows and the Subject Window
of a new message? I am not speaking about the Insertion Point, which should
be pulsating, but does not interfere with my typing.
I think this would be best posted in an Outlook Express news group since that
is the news reader you are using for this posting.
Gord Dibben Excel MVP
On Thu, 6 Jan 2005 14:29:54 -0500, "Bernie Beal" <email@example.com> wrote:
>Can someone tell my how to elimi...Cursor flickers
I change the Cursor of my mouse in WM_SETCURSOR handler. That doesn't cause
any flicker in XP, but causes a flicker in 98. Moreover the flicker is
strange, I don't see the arrow cursor in between, It is just that my new
cursor disappears for a few (fraction of) seconds, before reappearing. Any
I tend to work in the model of
HCURSOR cur = GetCursor();
if(cur != desired)
cur = desired;
which minimized flicker. The problem with SetCursor is that it &qu...How to select a non-default printer ?
I am using VC++ 6.0 with MFC.
I would like to print on another printer than the default one.
Here is my code :
// This is a dialog where user select his printer
CPrintDialog Imprimante( TRUE,PD_RETURNIC );
// eg : the user select the non default printer ...
// so i try to select it :
Later, when in my Mainframe, i send :
pGridView->SendMessage( WM_COMMAND, ID_FILE_PRINT_DIRECT );
but it prints always on the defa...Setting cursor for Disabled Button
I have created a custom button control class derived from CButton.
Everything works fine. I want to change the cursor of control when it is in
disabled stated. I am handling WM_ENABLE message to handle changing the
cursor. I set my custom cursor there. but it has no effect. Am I doing
>I have created a custom button control class derived from CButton.
>Everything works fine. I want to change the cursor of control when it is in
>disabled stated. I am handling WM_ENABLE message to handle changing the
>cursor. I set ...ms office excel 2007 cell selection issues
when you click on a cell, and then hold shift and click on some other cell,
it will select a "path" of cells from the first to the last. the first cell
(i will call this the "primary cell") is special in that if you hold shift
down again, and click on another cell, it will change the path of selected
cells as well as the last selected cell. however, when you move the entire
group of selected cells, excel will change the *relative* location of the
primary cell. how to prevent this from happening?
also, suppose your spreadsheet, for some reason, h...Cursor
Why is my cursor jumping all over the page and putting in the letters at
places not designated? Annoying.
Laptop? Disable the touchpad or reduce its sensitivity.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
wrote in message news:CF344F8E-7805-476F-A13B-FCC32D0A75C4@microsoft.com...
> Why is my cursor jumping all over the page and putting in the letters at
> places not designated? Annoying.
...Outlook 2007: Mail merge does not work in "plain-text" mode...
I'm using MS Office 2007 Pro (with all updates and SP2) on Windows 7 Pro 64
Today I tried to generate mail merge e-mails (20 recipients) using the mail
merge function for e-mails in Word 2007 (using Outlook contacts as recipient
Before sending the e-mails I am asked for the sending mode (HTML, plaintext
If I use "HTML" everything works fine and like expected.
But I want to use "plaintext". In this case the common outlook access
security warning is displayed (in HTML-mode this was not the case). I gra...Allowing Multi-Select Lists
In 'Working with Dynamics CRM 3.0', I found code to allow for mult-select
lists in a form. I have tried this and it does not seem to work. It does not
pull the selected item into ntext box. Has anyone else tried this code,or can
MS people answer this?
need to modify. :)
Crowe Chizek and Company
On Mar 14, 4:45 pm, Onetreeup <Onetre...@discussions.microsoft.com>
> In 'Working with Dynamics CRM 3.0', I found code to allow for mult-select
> lists in a for...About Cursor
I create two views using splitter window in MFC, while the left one is used
to set options and the right one draw the scene according to the command of
the left one with openGL.
Now I want the cursor of the mouse is visial in the left view and unvisial
in the right one.That means when the cursor falls in the rect of the right
view it disapeared and in other field it works all right! How can i do that?
Have any ideas?
Probably the simplest way is to have an OnSetCursor handler in the RH window and do a
SetCusor(NULL) to hide the cursor.
On Fri, 24 Jun 2005 09:44:27 +080...Greyed out signature options
I have a problem with my Outlook 2003 where the option to select a signature
is "greyed out". I cannot edit the settings from within Word 2003. Is
there a registry setting where I can reestablish this option? Has anyone
seen this happen before? It is not a user policy problem. Thanks in
If you uncheck Word as the editor in Outlook's Mail Format Options, you =
will regain the option to create, edit and delete signatures.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to m...How to print only selected columns from a worksheet
Is there a best way to set up a Worksheet so that it will only print
For example, I am using a spreadsheet to allow multiple users to enter
data. However, they only need to print six of the 52 columns in which
they are entering data. The columns are NOT adjacent to one another.
Any suggestions would be appreciated.
One way is to hide the other columns before you print.
You could also record a macro to do this for you and maybe
a second macro to unhide after you print.
"Mike C" <firstname.lastname@example.org> wrote in message
news:673cade2-be...Cursor disappears 11-25-09
Today installed Office 2010 Beta. Am running Windows 7. While using Word from
this suite (which I understand is actually Word 2007), if I hold down the
spacebar the cursor disappears while it is advancing. I can't tell where it
is until I release the spacebar. Very troublesome and I can't find a way to
Word in Office 2010 is Word 2010, but its behaviour in this regard is the
same as it was in 2007, which was a change from earlier versions. The cursor
does not disappear, but it does not stop flashing and, so, is not always
If you must do ...Expression builder in a select query
I want to determine the qualifying % of commission based on Margin $ as follows
>75 and <149.99 8%
>150 and <249.99 10%
>25 and <349.99 12%
My expression below do not produce correct results.I need help.
,IIf([Net_Margin]<149.99,"...Sorting Options in the Enquiry Windows
The Financial Detail enquiry window sorts transactions by open year then by
account index then by transaction date then by period id and finally by
DEX_ROW_ID. In this window you can look only on one year and one account at a
time. If you restrict your view to one day only it seems that this window
sorts transactions by the order in which transactions were posted (by
dex_row_id only, because the rest of the fields remain the same). If you have
over a hundred transactions on the same day it is very time consuming to find
the transaction you are looking for.
There should be a way of so...Select Case testexpression
I would like to understand the Select Case method to use instead of if -
As I understand this structure, the Select Case line should have a
testexpression where I have put ???.
I don't understand what that means and I can't get the following to work
without that. Can someone please explain how to get the following code to
Select Case ???
Case ActiveCell = Range("R25").Value
Case ActiveCell = Range("S25").Value
ActiveCell.O...Window always opens too small to view new mail
I recently upgraded to XP. Since then whenever I open
new mail in Outlook Express the window it opens in is
quite small and I always have to maximize it. Is there
any way to configure OE to open new mail in a maximized
...Switching from Mixed to Native Mode
I have an Exchange 5.5 server (mail) and an Exchange 2003 server (mail03).
All mailboxes and distribution lists have been moved. 2003 runs fine with
the 5.5 server shutdown.
What steps do I need to take to remove my 5.5 server so I can switch 2003 to
Thanks in advance!
"Acoustix" <Acoustix@discussions.microsoft.com> wrote in message
>I have an Exchange 5.5 server (mail) and an Exchange 2003 server (mail03).
> All mailboxes and distribution list...The cursor in Word
Operating System: Mac OS X 10.6 (Snow Leopard)
THe cursor in Word is white. How can I change it to black
...remove tiled mode in outlook 2003
I can't seem to get rid of tiled mode in outlook 2003 when creating a
stationery. I'm trying to create a good looking email that is not too large
a file in outlook.
you need to put the image in a table to keep it from tiling.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOF...Outlook 2007, proofing options greyed out in Editing Options dialog
I've just uninstalled the Office 2007 trial and installed a retail copy of
Outlook 2007. For reasons I won't go into I've reverted to Office 2000,
with the exception of Outlook, which didn't work with Vista.
While the Outlook editor still autocorrects spelling mistakes, I noticed it
isn't underlining unknown words in red any more. When I go into the Editor
Options and select Proofing, all the options in the Microsoft Office Section
are available to me, but the Outlook specific ones are all greyed out.
Moreover, in neither of these sections is there a "Hide spe...Cursor
When using my keyboard shortcut keys in a Word document, I accidently pressed
ALT+CTRL+Hyphen and this resulted in my cursor changing to a short thick
black line. Repeating the action did not change it back to my normal cursor.
The only way to get rid of it was to Exit from the document. How can I
change this shortcut key so that it doesn't happen again?
O/S is Windows Vista
Office Small Business Edition 2003
The keystroke triggers the command for removing an item from a menu. It can
be cancelled by pressing the ESC key or you can go to Tools> Customize &
either ...Select count(*) in SQL
has anyone an idea how to manage a query like "SELECT COUNT(*) from xyz
WHERE ...." with ODBC and ACCESS. From what i read in the documentary i
think i have to switch to MySQL.
That is a valid SQL query that Access will honor. What seems to be the
"Matt" <Matthias@monarch.net> wrote in message
> has anyone an idea how to manage a query like "SELECT COUNT(*) from xyz
> WHERE ...." with ODBC and ACCESS. From what i read in the documentary i
> think i have to switch to...