Macro help #12
I am working on a macro in Excel 2003 Pro, and everytime I go to sort a
column of data. There are about 10 rows of data in about 200+ columns. I
can only get the macro to sort the column that I edited it with. How can I
create the macro, so each time I click on the first row of each column, click
the macro button I will assign to the toolbar, then that row will be sorted,
and do this for each column?
Any help at all would be greatly appreciated,
Jeff Garrett (firstname.lastname@example.org)
please post your current code and then we can suggest changes to it.
"...Message "class not registered" opening sheet with macros Excel 97
I have created a document with Macros and is password protected. I have sent
it to several people who are able to use it - the one who can't is using
Excel 97 SP2. They are getting error message "class not registered" - could
it be the version they are using and how do I make sure they are able to use
This could simply be a version issue if you developed on a later version and
used controls from that versions object libraries. You should always use the
lowest version to develop on.
If this is not the case look in the VBE on the faulty machine and check
Is there a way to change the color of a chart bar based on the value of the
cell that generates that particular bar? In other words, I have a chart
with 15 vertical bars and I want to change the color of one or more of the
bars if its value goes above 100% (but not all of the bars).
Jon Peltier has instructions for conditional charts:
> Is there a way to change the color of a chart bar based on the value of the
> cell that generates that particular bar? In other words, I have a chart
> wi...excel charts #24
Is it possible to freeze a chart in excel and then add another chart with
different column widths without having the changes affect the first chart?
Move off the chart, press the Shift or Ctrl keys and select the chart.
Then right-click it and choose Format Object
On the Properties sheet select Don't move or size with cells
> Is it possible to freeze a chart in excel and then add another chart with
> different column widths without having the changes affect the first chart?
I've got a left join query that I need a 0 to be included in the a specific
column that would normally be <NULL> in the left join.
I'm trying to write the query using SELECT ..., ISNULL(<COLUMN>, 0), but I
get a "Wrong number of arguments used with function in query expression
Is the ISNULL function defined for access 2003? And if so, what arguments
should I be passing to it. All docs that I've discover say to use the two arg
Thanks for the help in advance,
IsNull is the wrong function to use, it si...exchange 2003
I just set up a mail server at things are working fine in
the network where it resides. The issue is that I have 5
other buildings that are connected via a VPN, and they
can not connect.
Do I need to change settings at their locations? DNS??
It depends on type of client, but generally proper DNS setup is
required. Also make sure that no firewalls interfere.
> I just set up a mail server at things are working fine in
> the network where it resides. The issue is that I have 5
> other buildings that are connected via a VPN, and they
> can not co...Can I fade the edges of photos that I use?
I am trying to use photos in a publisher document that I want to fade the
edges of, is this possible to do with publisher?
> I am trying to use photos in a publisher document that I want to fade the
> edges of, is this possible to do with publisher?
Not really. You should use dedicated image manipulation software for
this, such as Photoshop Elements, Paint Shop Pro, or Microsoft Digital
Ed Bennett - MVP Microsoft Publisher
Are any of these programs typically come loaded on a computer?? I have
another question - ca...Macros #50
How do I move macros from one computer to another?
In the VBA editor, right click on the sheet name or module name (in the left
panel)that contains the macro and click on "Export File"
> How do I move macros from one computer to another?
Macros are always stored in workbooks, so you can simply copy the
workbook containing the macros from one machine to another.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Neal" <Neal@discussions.microsoft.com> wrote in mess...Using different form strings to filter
Hello. Is there a way to code a query to have it use a filter string
if a form is open, or ignore it if the filter is not open?
Query Name: Query1
Form: Form1 and Form2
Query fields: Field1 and Field2
I have a string in field 1 and 2
Forms!Form1!Field1 in the first field of the query, and Forms!Form1!
Field2 in the second field. Can I also have Forms!Form2!Field1 in the
query as well? I have tried this, but a box pops up and asks for the
information from form 2 when it is not open.
> Hello. Is there a way to code a query to...Using Ghost as OS Backup
I attended a class a while back where the exchange admins said they used
Ghost to clone the OS drive. I bought the product and it says that during
the clone process it temporarily removes the server from the domain. Has
anyone done this or had any problems?
On Mon, 21 Nov 2005 05:26:28 -0600, "Fred T" <email@example.com> wrote:
>I attended a class a while back where the exchange admins said they used
>Ghost to clone the OS drive. I bought the product and it says that during
>the clone process it temporarily removes the server from the domain. ...using beforeprint
I am trying to get an application to append a file on a sheet printout.
I am using Workbook_BeforePrint. It prints fine, but doesn't seem t
execute the sub. What's wrong
Message posted from http://www.ExcelForum.com
you may post your existing code :-)
Also check that you have put this code in your workbook module
> I am trying to get an application to append a file on a sheet
> printout. I am using Workbook_BeforePrint. It prints fine, but
> doesn't seem to execute the sub. What's wrong?...Do you need Access to use an Access Database for data entry only?
We have an Access database completed. Now we will use it for reading as well
as for data entry. Do we need to install Access for every workstation
needing the database for data entry or reading?
No you don't necessarily need Access on every computer. You CAN use the
Access Runtime and if it is in Access 2007 you can use it for free. If you
are using another version then you would need to purchase the developer's
edition to be able to legally distribute the associated Access runtime.
If you do have 2007 and want to use the runtime, make sure your Full version
of Access doe...DPM sometimes uses too many tapes
Hi, i have problem with DPM long term backups on tape. I have collocation
enabled so that is not a problem. Sometimes DPM uses too many tapes for same
protection group, sometimes it uses 1, and then sometimes 2 - 4. Amount of
data is always same. Can anybody help me please, what could be the problem?
Can you explain protection group configurations as well as tape usage in
detail, so that we can analyze on what is happening?
This posting is provided "AS IS" with no warranties, and confers no rights.
"Tornado" <Torn...Create interactive pivot table chart based on item selected
I'm trying to remember how to drag a chart object to the top left cell of a
pivot table thus displaying a charted image of the detail item selected. Any
...Auto expanding X Axis for Chart
I have a chart setup, currently with reference to 31 cells width.
The chart looks great if the user places a value in each of the 31 cells,
however if there are only say 20 values placed across the cell row, the
chart is displayed over to one side, with nil values displayed where no dat
values were entered.
Is there a way to have the chart automatically vary the width depending on
the amount of values entered across the refernced row of cells?
If there was only 20 values entered, then the chart would show 1-20 charted
and leave out the 21-31.
EXCEL 2007...Print Macro #2
Trying to write a macro to print a spreadsheet where the
number of rows of data varies.
What's wrong with this code?
Dim rng As Range
Set rng = Range("A1").End(xlDown).End(xlToRight)
.PrintArea = rng
Leave your PrintArea empty
Excel will print all cells with a value on the sheet
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
"Pam" <firstname.lastname@example.org> wrote in message news:email@example.com...
> Trying to write a macro to ...is there any way I can trap for the use of navigation buttons?
Is there any way I can trap for the use of navigation buttons, such as
Next, Previous and New record?
Probably. Trap what and when?
"Stapes" <firstname.lastname@example.org> wrote in message
> Is there any way I can trap for the use of navigation buttons, such as
> Next, Previous and New record?
On Wed, 16 Jan 2008 05:14:20 -0800 (PST), Stapes
No. And there shouldn't be a reason for that. There are plenty of
events in...Cannot stop using online services with First Tech Credit Union
My bank, First Tech Credit Union, recently upgraded their online banking
services. This upgrade also included a change to the user name and password
used for online banking in Money 2006.
Their upgrade instructions
(http://www.firsttechcu.com/help/help_guide_money.html) say to disable online
services for your Money file as the third step to upgrading to the new
services. The problem is that when I click on Stop Using Online Services in
Money nothing happens. I click on OK and Money hangs for a bit then comes
back with no change, clicking on OK again has the same effect, clicking on ...Using paste in macro but with variable references.
I am trying to use the paste function in a macro but it needs to be
I have split a list of data (team workloads) into the seperate teams
and by days of the week. I now need the macro to compile one book with
all the data in order.
The headings for each team are already set on a worksheet so the data
needs to be entered under each heading For example:
Team A Day 1 under the heading "Team A Day 1", Team B Day 1 under the
next heading on the same sheet "Team B Day 1".
I hit problems as the workload ammount will alter from week to week. So
of course asking...Publishing Microsoft Excel Charts to the Web
I routinely publish Excel charts to a web site for
viewing in a web browser. When I do so, the charts are
too large to fit on one screen without scrolling. Is
there a way to make the charts fit the size of the user's
browser window when you publish them?
Embed the charts in a worksheet (right click, Location, As Object In:
Sheet Name), and size them to fit before exporting.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I routinely publish Excel charts to a web site f...Using CComboBox embedded in CToolBar
I've derived a class from CToolBar and overridden OnCreate to replace 2
placeholder buttons with 2 combo boxes. The two combo boxes are also
derived from CComboBox, and populate themselves with appropriate strings.
My problem is that I'm not sure of how to inform my application when the
user has selected a new item in one of the combo boxes. I've added a
handler for the CBN_SELCHANGE message to the CComboBox, but I don't know
what to put in it. What is the best way to forward the message to the
Also, when I replace the placeholder buttons, can I reuse their ...How do I show a data table with legend keys in a line chart?
I am having trouble inserting a data table with legend keys into a line chart
that contains a horizontal target line. Can anyone help me?
I tried it in both 2007 and 2003 and had no problems. We need more
infomation, can you post a sample of the chart somewhere. The only issue I
have is that the target line is displayed on the data table, which I would
prefer that it not be.
> I am having trouble inserting a data table with legend keys into a line chart
> that contains a horizontal target line. Can anyone he...Excel Macro
I am writing a macro and cannot find any command that will
allow me to move the cursor in the Worksheet. Rather than
give a Cell address such as "A3" I want to be able to move
the cursor any given number of cells to the right,left, up
Can anyone help?
will move x rows down (if positive, up if negative) and y columns to the right
(if positive, left if negative).
Stephen King wrote:
> I am writing a macro and cannot find any command that will
> allow me to move the cursor in the Worksheet. Rather than
> give a Cell address ...is there a way of using a second monitor as a customer display
This is a multi-part message in MIME format.
Does anyone know if rms works with 2 monitors. What I mean can you use a
second monitor as customer display or something similar.
A lot of pos systems out there use a second monitor as customer display,
I m not sure if rms supports that option or not but any help would be
Content-Transfer-...Modifing data to show up better in chart.
My Y1 axis is from 0-250 my Y2 axis is from 0-9000
When graphing percentages the line shows up at the very bottom since 99% < 1
is there a way I can multiply these percentages by 100 to show them as 9900%
Normally you would just make then a 2nd axis but as you can see I already
have a second axis of 0-9000
In article <A9E6F75B-7307-4291-BC7D-729F9DF88D50@microsoft.com>,
> My Y1 axis is from 0-250 my Y2 axis is from 0-9000
> When graphing percentages the line shows up at the very bottom since 99% < 1
> is there a way I...