How can i move a macro from one computer to another
i would like to move a macro from one computer to another i Excel
Macros live in excel workbooks.
So you can just copy that workbook with the macro to the other pc and open it
> i would like to move a macro from one computer to another i Excel
Or you could export the module containing the macro as a *.BAS file, email it
to other computer then import to another workbook.
Gord Dibben Excel MVP
On Wed, 08 Sep 2004 07:05:48 -0500, Dave Peterson <firstname.lastname@example.org> wrote:
>Macros live in excel workbooks.
>So ...Can't display all text in cell
I'm trying to display text in a cell. I've got Wrap Text on, and I hav
several paragraphs of text. All of it appears in the formula bar, bu
not in the cell displayed on the screen. And yes, I increased the ro
height, but it still doesn't show.
Message posted from http://www.ExcelForum.com
I am having the same problem. Apparantly there is a 1024
character limitation per cel in excel. The only advice I
have received so far, which does work, is to press
alt+enter to create a line break. If you find another
work around, I would be interested.
besid...Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or
Query into specific cells of a Worksheet. The table I'm importing will
always contain a single record only. For example, I'd like to export data
from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc.
Any sugestions would be most appreciative.
...Pivot chart: get rid of zeroes?
I have created a pivot chart using a pivot table.
However I want the zeroes to be NULLs so they are displayed on the graph.
Unfortunately I cannot see how to do this; could someone please help? I
have tried the Table Option checkboxes in the bottom right corner to no
Sorry, that should read NOT displayed on graphs
"Phil Davy" wrote:
> I have created a pivot chart using a pivot table.
> However I want the zeroes to be NULLs so they are displayed on the graph.
> Unfortunately I cannot see how to do this; could someone p...How do I get the document to align with my labels?
I keep trying to print these labels, and they end up wasting because the
alignment is off. I am using the right number labels along with the
application, but for some reason it's not working. My printer is a F335
All-In-One. Please advise. Thank You.
Extremely difficult without seeing them. But 99% of the time it is because
normal.dot has been modified by adding a Header or Footer or similar and
labels are based on normal.dot. So try starting Word in Safe Mode and create
a sheet of labels to see if that works. If it does, rename normal.dot as
normal.bad and start Word agai...File Sharing between XP Pro and XP Home
I have a few questions concerning file sharing between XP Pro and XP Home in
a Workgroup environment. I would really appreciate any help.
1)From what I'm gathering on the internet (I've read multiple articles) you
cannot even connect a Windows XP Home computer to a domain. I'm I
interpreting this correctly?
2)I have a new server with XP Pro and 5 other computers with XP Home. I
only have 3 computers (which includes the new XP Pro server) that really
need access to everything (or the main folders) on the server. The other 3
computers need limited access. If I purchase X...Conditional Formatting
I have a row of cells that calculate the totals for their columns but I
force to be blank via IF statements until certain conditions are met.
Once these conditions are met, the total appears. I'd like to also
highlight these total cells via conditional formatting. My conditional
formatting input is simply "If Cell is Greater than 0, format". For
some reason all the cells format as though they are all > 0 yet they
don't display anything. Are there some internal rules that specifiy
when a cell is really 0? Is there another way to do this that won't
care what the for...counting same text from different cells
Hi I was Trying to count text such as "p" for pass from different cell in
excel but i am not sure what is the formula for that.
It will be really helpful if u could send me the solution
"om" <email@example.com> schrieb im Newsbeitrag
> Hi I was Trying to count text such as "p" for pass from different
> excel but i am not sure what is the formula for that.
> It will be rea...pulling cell "value"
in the cell C4 i have the formula =now() and I have that cell formatted to
custom mmmm so that it displays as January.
I am now trying to write some VBA code to look at cell C4 and take the
January and then do a vlookup on the array that i have named months.
months is the cells D14:E25 column D has a list of the months and column E
has a list of numbers that corresponds to these months. This is a custom list
so I can not use the standard numbers that excel uses for the months.
The vlookup in vba should take the January and find the number in col E that
corresponds to it th...windows xp home op system viewing options
I've been running windows xp, home & pro, for some time now. In that system,
pics that you have in your comp can be displayed in thumbnail form like a web
My ancient monitor just blew up, and I FINALLY got a flat screen 20"
monitor, but now the thumbs are MICROSCOPIC!! I've used the display settings
to enhance the view to 150%, but it only affects text. Also, Explorer 8 has
zoom features, but many of the programs, and my big want, the thumbnail pics
are so tiny they're hurting my eyes to see them.
Can we adjust the size of displayed files in the hard ...To get user training manual for Microsoft CRM 3.0
I am implementing Microsoft CRM 3.0 for an health care company in Michigan.
Right now I have experience with installation, customizing and CRM
application functions for 2 years.
In the future I would like to pursue my future as a Microsoft CRM
consultant. Thus, I would like to get all 3 of certificates of Microsoft CRM:-
3. Installation and Configuration
The problem I have is I work for a company which I am not permanent
employee, and this company is not Microsoft Partner also. So If I would like
to have user manuals for preparation to ...Getting Combo boxes to change options based on other Combo boxes.
Using Excel 2007. I am trying to create either Form Control Combo Boxes or
ActiveX Combo Boxes that will change the selectable options based on
selections made in previous combo boxes. I am having a hard time finding any
information that will work for me. Can someone tell me how to make 5 combo
boxes change available listed options when specific options are selected in
another combo box? Please? I've been working on this for a very long time
without success. I've tried using Data Validation, but my formulas are too
long for all the different possible combinations.
You are...Formatting Cells #13
If you want something from cell (A) to appear in cell (B) and change when the
contents of cell A changes, how do I do that?
Acurran, =A1 ???
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 2000 & 2003
** remove news from my email address to reply by email **
"Acurran" <Acurran@discussions.microsoft.com> wrote in message
> If you want something from cell (A) to appear i...Can I use Rule to move digitally signed messages to separate folder?
Is there a way to move digitally signed messages to a separate folder using
a Rule? Other options for segregating digitally signed messages?
Thanks in advance.
deko <firstname.lastname@example.org> wrote:
> Is there a way to move digitally signed messages to a separate folder
> using a Rule? Other options for segregating digitally signed
I don't see that as a selection criterion in the Rules wizard.
...Need help with cursor spacing problem
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="ISO-8859-1"
I�m trying to fill in a form that�s MS Word based. I�m using MS Office X on
a Mac G4 with system 10.3.4.
When I type, the cursor seems to have an extra space between the last letter
and the place where I want to put a new one. In other words, I�m unable to
align the cursor exactly where I want it to go. It makes typing almost
imposs...Highlighting a cell
I would like to highlight a cell for data entry, but I do
not want the color to print. Is there a way to acheive
this in Excel 2000.
<File>, <PageSetup>, <Sheet>tab,
Under Print, check the "Black & White" box.
Please keep all correspondence within the NewsGroup, so that all may
"Sandi" <email@example.com> wrote in message
I would like to highlight a ce...Hard return in wraptext cell?
Is there a way to place a hard return(carriage return) in a cell with wrap
so as to align text in the way user wants rather than what excel places?
Sure. Where you want a new line just press Alt+Enter. To remove that just
place the cursor at the end of the line before the new line and press Delete
"MP" <NoSpam@Thanks.com> wrote in message
> Is there a way to place a hard return(carriage return) in a cell with wrap
> text format
> so as to align text in the way user wants rather than wh...setting up Vista-microsoft mail-getting POP3 server error message
What am I doing wrong?
Trying to set up my MSN-Vista-Microsoft e-mail. Get an error message about
the POP3 server. I give my incoming and outgoing mail server as POP3 and
service provider TWC or Time Warner Cable and the error message comes up.
What should I do? Can you help me?
On Tue, 7 Aug 2007 19:27:09 -0700, "asilocreo" <firstname.lastname@example.org>
>What am I doing wrong?
>Trying to set up my MSN-Vista-Microsoft e-mail. Get an error message about
>the POP3 server. I give my incoming and outgoing mail server as POP3 and
>service provider TWC or Ti...How can I get data from an entity via java script
How can I get data from an entity via java
I have a new entity with alle zipcodes and cities/countries.
I want it to be so that if a person enters data in the zip code on account
or contact that city and state automatically is filled with corresponding
data from the new zip code entity.
How can I do this, java script ?`
Any ideas appriciated !
Jeg beskyttes af den gratis SPAMfighter til privatbrugere.
Den har indtil videre sparet mig for at f� 13991 spam-mails
Betalende brugere f�r ikke de...moving files
How do I move files from publisher 98 to publisher 2000? The programs are
If you are talking about the documents you created, you wouldn't have to.
But if you wanted to - copy and paste.
MVP Microsoft [Publisher]
"dunefarm" <email@example.com> wrote in message
> How do I move files from publisher 98 to publisher 2000? The programs are
> installed separately.
...in MS EXCLE how we can protect only one cell?
plz do repl me soon
First select all of the cells in the
Sheet>Format>Cells>Protection>remove the check mark form Locked.
Next select the single cell you want to be
Tools>Protection>Protect Sheet (optionally provide a password - remember
to write it down somewhere of you do)
anu khan wrote:
> plz do repl me soon
This assumes that you wish to protect cells D 83 to D 85.
If you wish to protect just one cell replace D 83 to D 85 (below) with the
cell ...Selecting Cells with Shift Key
When I am selecting cells in Excell, I use the shift key and the arrows on my
keyboard. If I pause at all, the selection is lost when I continue with the
selection. Why? Can anyone help me?
If you have removed your finger from the shift key then Windows will think
you are starting a new selection. Just be sure that you don't touch the
arrows without the shift being held down.
"Jaymndad" <Jaymndad@discussions.microsoft.com> wrote in message
> When I am selecting cells in Excell, I use the shift key...Merge Cells, but keep backgrounds
In excell 2003 is there a way to merge cells so the text spans them
all, but keep the current background of the cells (which are not all
the same color)?
Try Center Across Selection and avoid merged cells whenever possible.
Gord Dibben MS Excel MVP
On Sat, 30 May 2009 09:16:12 -0700 (PDT), "firstname.lastname@example.org"
>In excell 2003 is there a way to merge cells so the text spans them
>all, but keep the current background of the cells (which are not all
>the same color)?
Is there a way to center across selection vertically or just
horizonta...Why would m_pSiteFocus get corrupt?
I have an app with a view that hosts windows media player (CWMPPlayer4).
The player is occasionally removed from the screen (using
ShowWindow(SW_HIDE) and MoveWindow(CRect(0,0,0,0), FALSE) and then put back
(using the same functions as during the removal but with different param
On odd occasions I get access violation in the view's OnWndMsg(). When
this happens I can see in the debugger that m_pSiteFocus of the view
(control container) is not valid ( the pointer value seems to look OK but
its content is simply garbage).
Would anyone have any idea why this happens?
Thank...Data Entry to a Cell Range
Can I set up a data entry form, so if every time I enter a value in a cell,
it updates the next empty cell in a range? Thanks
Lets assume that the form is used to update cell A1. We require that
everytime A1 is updated the new value will be recorded in column B. Put the
following event macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim A1 As Range, t As Range
Set A1 = Range("A1")
Set t = Target
If Intersect(A1, t) Is Nothing Then Exit Sub
Application.EnableEvents = False
n = Cells(Rows.Count, "B").End(xlUp).Row...