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.
"...How do I prevent "Help" from opening when I open Excel?
Whenever I open Excel 2003 the Help feature opens on the right.
How do I pevent this? I only want Excel to open with a new sheet.
Help or TaskPane.
For Help, you should be able to close it using the "x" and next time open
Excel should not display.
If TaskPane, go to Tools>Options>View and uncheck "Startup Task Pane"
Gord Dibben Excel MVP
On Mon, 12 Dec 2005 13:05:29 -0800, "Lee P" <LeeP@discussions.microsoft.com>
>Whenever I open Excel 2003 the Help feature opens on the right.
>How do I pevent this? I only want Exce...Date Range Formula Question
Hello, I'm having trouble with a formula and I'm hoping someone can
help. :confused: Sample Data Includes the following:
Pay Period Start Pay Period End Pay Period #
12/16/01 12/29/01 26
12/30/01 01/12/02 25
01/13/01 01/26/02 24
01/27/02 02/09/02 23
02/10/02 02/23/02 22
The pay periods continue until there are 26 pay periods for the entire
year....Time Zone / Incorrect Dates Displayed to User
When a user in the Central Time zone closes an opportunity and someone in the
Mountain Time zone views it, the Actual Close Date is 1 day before the date
the person in the Central Time zone selected.
If someone in the Central Time zone closes an opportunity and selects the
Actual Close Date as 6/2/2007:
-- Users in the Central Time zone see: 6/2/2007
-- But users in the Mountain Time zone see: 6/1/2007
This is a big issue when running monthly reports as it makes some
opportunities show in the wrong month... and will put that revenue in the
It would make mo...HELP!!! 08-30-03
please elp me. my mom is a medical transcriber and she has
a dictionary she uses through windows 98. and her comp has
no memory, so we need to update her operating system
inoder to put more memory on there. she needs her
dictionary and i was wandering how to access it and if
possible how to save it on to a cd. thank you for ur time
Dear jason you have to have a dictornary corect i have one i could email you
if you like just email me back i mean i use this dictornary really well and
it works for 95-Xp so if you want give me a hollar ok
"jason" <jasonr_206@hotm...help with installation isue
Hope this is correct NG
When I try to run `Karens replicator` (for external backup) My PC
automatically runs an installation for publisher 2003 and then gives error
require file SKU019.CAB
then asks for original CD to be inserted.
Publisher still works ok
I can`t see what the relationship between the 2 are, how do I stop this
trying to install?
Rent a villa in Turkey
I would suggest aksing the folks over at karenware.com.
http://www.karenware.com/powertools/troubl...How do I send my Outlook calendar to my desktop?
I would like to see my calendar created in Microsoft Outlook on my desktop.
I have found information that says it can be done but I cannot find any
instructions to accomplish this task.
Post link to said info?
> I would like to see my calendar created in Microsoft Outlook on my desktop.
> I have found information that says it can be done but I cannot find any
> instructions to accomplish this task.
"Dan" <Dan@discussions.microsoft.com> wrote in message
>I would like to s...getting added to other peoples meetings in shared calendar
I opened shared calendars in my group by choosing their name and then the
email messages went out giving them access to my calendar and requesting to
view theirs. Ever since, I have been copied in as a "required attendee" on
all meetings for everyone. I get the calendar items on my calendar and
emails requesting Accept or Decline in my inbox. When others view view thru
their outlook, they do not see me as a required attendee? What am I doing
are you adding them as delegates or just giving them permission to view the
calendar (by right clicking on the calendar fold...HR Help menu
The Help menu is not available in the Employee file screen. Also there is not
at this time any french version help menu available with HR.
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 suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/de...How do I turn off the reminder bell on my calendar?
I have a lot of items in my calendar. However, the constant pop-ups and
ringing bell are very annoying. How do I turn these off but leave my
calendar entries intact for when I wand to pull them up. Thank you.
Open them and change Reminder to "None".
> I have a lot of items in my calendar. However, the constant pop-ups and
> ringing bell are very annoying. How do I turn these off but leave my
> calendar entries intact for when I wand to pull them up. Thank you.
See http://www.outlook-tips.net/archives/2004/20041130.htm - this will turn...adding date/time picker to inputbox control
Hi all,is there a way to add a date/time picker control to inputbox?...Barcodes Code
I am trying to print a barcode in the 128 code. Though it seems the
public domain/GPL ones of the truetype do not print a scanable barcode.
Is there any suggestions... Or if anyone can point me into the right
direction on how to do this or point me in direction of one that will
work with access or excel 2000 or 2003. Much appreciated.
Or help me figure out WHY it isnt producing a readable one in 128..
Perhaps the problem is with the resolution on your printer.
Try printing the barcode larger. Perhaps even turn off print to fit under
print, page setup.
David McRi...Help please #8
This is a multi-part message in MIME format.
I'm having this error message.
Event Type: Error
Event Source: MSExchangeAL
Event Category: Service Control=20
Event ID: 8231
Time: 4:39:10 PM
Permanent failure reported by policy group provider for 'CN=3DSystem =
,...Create Calendar mtg invite template to avoid retyp'g conf no's?
I want to create a calendar template so that I can avoid retyping my
conference call details in the location field everytime I create a new
invite. How do I do this?
In what version of OUtlook?
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
> I want to create a calendar template so that I can avoid retyping my
> conference call details in the location field everytime I create a new
> invite. How do I do this?...Re:Help with verifying the signature of enveloped -message using x509 certificates.
Re:Help with verifying the signature of enveloped -message using x509
I have an xml given by our partner trying to integrating with us and i have
their certificate with public key installed in both personal and trusted
when i am using the following code to check the signature of message signed
by my certificate i am able to verify the signature but when i am trying to
check the signature of the message of our partner using the same following
code i am not able to verify the message. the message sent by our partner is
right below the code.I wou...Email link to update Outlook --- Calendar
Anyone knows how to send an link within an email, inwhich
the Recipient can click to have the their
Outlook "Calendar" automatic updated with appointment
information. I have seen this work, can't find
inforamtion on how to create this link. Thanks
...Date & Time file was last saved
Is there away to display in a cell the date & time the file was last saved?
I know you can do this in word but is it possible in Excel 2002?
Here is an UDF
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties(prop)
DocProps = CVErr(xlErrValue)
Now you can use the following formula in one of your cells:
=DocProps("Last save time")
Obviously, the file has to have been saved.
... looking out across Poole Harbour to ...Add working hours to date field
We offer computer support based on a certain response time in hours. I want
to have a date field, on the case form, to automatically set x WORKING hours
ahead, usually 8 hours. The actually hour value will be pulled from a
Does anyone know if this is possible or am I shooting way too high?
Thanks in advance for helping. I would like to run a
macro on a user form to take the date of report and see
if the date is on or past the 26th and send the report to
the its designated worksheet. looped.
example: IF the report is anywhere created from 26th of
the previous month to 25th of current month to go in to
spreedsheet of that current month and continue on till
project is finished. starting with the first day of
contract to be awarded. the problem is i have to use
thier form on excel. the thing is, the report will only
have a "todays date" and the data to follow...Caculating Columns Between Certain Dates
I have a spread sheet with for simplicity 4 columns
Column 1 is a Date Column,
Column 2 is a Company Name,
Column 3 is a Payment amount X
Column 4 is a Payment amount Y
The amount due is the sum of X+Y between the relevant dates.
The entries are in date order and the Company names random.
The number of entries per company varies also.
I want to be able to calculate the amount due for each company over a thee
month period between certain varied dates.
1. Is there a way to enter the dates to calculate between.
2. What is the best way to perform the calculations for each company?...Post Exp Date in Master Rcd (row) from trans record
I'm using Access 2003 via Xp Office Pro.
I'm working on a annual membership database. Each member has to renew each
year if they want to stay a member. I want to keep a history of their
I have a membership table and will have a renewal table where I create a
record / row each time a member renews. Key to both tables are automatic
When I post the renewal transactions, I would like to change the expiration
date that is on the master record. I realize that I would have the same data
in both records, but for simplicity of the r...Help needed please
I am running Exchange 2003 with Outlook 2002 as the client
connection. On a couple of machine it has not been
possible to send mails. When mails are sent to this
machine from the Internet, they are received but those
sent from the internal exchange do not get delivered. When
the user connect through Outlook Web Access, the mails are
sitting there. I have tried to reinstall Outlook a number
of times but all I get when I click Send/Receive mail from
the exchange server is this error message:
"The operation failed due to a registry or installation
problem. Restart Outlook and try ag...Extracting the month that a date refers to in another cell
In cell A1 I have the date 3/15/2003 (no formatting).
In cell B1 I have the formula =year(A1). The year shows correctly as 2003.
In cell C1 I have the formula =text(weekday(A1),"ddd"). The text shows as
"Sat" which is correct.
In cell D1 I have the formula =month(A1) which correctly shows '3'. I
attempted to use =text(month(A1),"mmm") in cell D1, but it shows as "Jan".
Can someone tell me what I am doing wrong?
=TEXT(A1,"mmm") for 3-letter month name and
=TEXT(A1,"ddd") for 3-letter day name.
where A1 houses a...Advanced Filter help
I'm trying to filter a list using advanced filter. The problem i'm having is
that i'm picking up records i do not want, even if i use the unique record
check box. let me give you an example!
My record i want to pick up is code: 009/04025, however it seems to give me
all codes starting with 009/04025 eg 009/04025C, 009/04025CG, 009/04025SD
etc. The only item i want filtered is 009/04025. Is there maybe a wildcard
or something i should be using??
Set up a criteria range, say X1:X2, where
X1 houses the label heading the codes and
X2 the formula:
="=009/...sync calendar Outlook 2007 exchange 2010
I have got the following problem. We have Clients with Outlook 2007
connected to an Exchange Server 2010 SP1. In case somebody give access
to the calendar with the option "free & busy" the followig strange
Client a => can see the entries with Place an Reason
Client b => has got no access to the calendar
when we sign on via OWA all entries with both users are correct. It
shows all entries only "blocked", which is right.
Has somebody an explanation for this strange thing ???
Thank you in advance for any help on this