Remove macro is greyed out
I want to remove a sort macro that I made which is in a workbook that I
made. When I go Tools|Macro|Macros I see the macro but the delete button is
greyed. How can I remove the macro?
Sometimes, the project is protected by the developer. But if you created the
macro, then you know if you protected that project. Did you?
Do you get prompted for a password when you try to access the project (inside
> I want to remove a sort macro that I made which is in a workbook that I
> made. When I go Tools|Macro|Macros I see the macro but the delete ...Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...REQ: Can Someone Help Me With This Outlook XP Question?
I use Word to edit my e-mail msgs in Outlook XP. I had to reinstall Office
the other day and now whenever I want to start a new e-mail or reply to an
e-mail I get a warning that comes up:
"A program is trying to access e-mail addresses you have stored in Outlook.
Do you want to allow this?
If this is unexpected it may be a virus and you should choose 'No'"
There is a box that asks for the amount of time to allow the access: 1 to 10
Do I have to have specific settings for my Outlook address book? I use the
Contact area in Outlook for addresses.
I have ...Outlook 2000 doesn't respond after downloading MS update!!
Luckily, my Outlook Express seems to work, but my Outlook 2000 will open,
but if I click on a message or do Anything, it FREEZES.
HELP!! I rely on calendar functions, other things.
HOW could MS allow an update that screws up their own programs?
I did restore - to no avail. I lent CD to someone, so can't do "repair."
(Trying to get a hold of friend)
Please help! I'm in process of job hunt & really need Outlook to
Did you recently apply SP3 for Office/Outlook 2000 and is Outlook 2000
configured in Internet Mail Only mode? If yes, you...IWAN & IUSR bei Crystal Reports? *help*
my problem is that i can see the crystal reports, but when i open one i get
"more information is needed".
But till yesterday i could open reports!!
Now after some search i see that i have no IUSR_servane and no
IWAM_servername. how could this happen?
My system is AD, SQL, CRM and each of them is one a seperate 2003 server.
Please let me know if you have any suggestions.
sound strange with the IWAN and IUSR.
I offten have this problem. There are a techknowledge article with 13
resoluti...Please help..with a formula. I don't know code.
I have a long list of numbers - values in a file X, and I want to fin
and replace those values in a even larger list in a file Z an
highlight those values in Z
Message posted from http://www.ExcelForum.com
not really sure what you're trying to achieve. What do you
want to replace, etc. You may give an example (plain text -
no attachment please)
>I have a long list of numbers - values in a file X, and I
want to find
>and replace those values in a even larger list in a file
>highlight those values in Z.
>Message...Help With Strange Error When Trying to Save Any Record
I am getting astrane error happens when try to create any new record
(Customer, Item, Vendor or Account), the system gives me a message that "Save
Operation Failed" and when i click "More Info" the error message is "Could
not find stored procedure 'DYNAMICS.dbo.aagGetCompanyStatus'", although i
have created alot of items, customers, accounts and vendors before but
suddenly this error appeared.
Any quick help will be highly appreciated.
It would appear that the AAG has something to do with a product produced by
American Association of Geographers. I...Need a default email account for all users, need help.
I have a tablet PC running WinXP Tablet with Outlook 2003. This tablet
connect to our exchange server via VPN. How can I set it up so that
that logs onto their account can access one (the same) email account.
problem is that I dont know at this point all of the users however
using the tablet will use one generic email account. So how can I set
Outlook to default to this account so that no matter who logs on they
use this account?
...Outlook 2003 attachments.
When an email comes in with say a word attachment, i go
to open the attachment the only option i get is 'save to
disk' or cancel. It gives a message saying that this
file might contain a virus etc. etc. This happens with
How can i change it so there is a open button also.
The pc is windows 2000 sp 4 with Office 2003.
...Sending a workbook as a mail attachment
Is there an easy way to send a workbook via email based on the date an
time? Our company uses excel for some of our reporting and rather then
having the reps remember to send the workbook i'd like to have it send
itself automatically - say on Saturdays or Sundays.
Nel post news:firstname.lastname@example.org
*Gord* ha scritto:
> Hey Folks,
> Is there an easy way to send a workbook via email based on the date an
> time? Our company uses excel for some of our reporting and rather
> then having the reps remember to send the wor...Need help with formula 01-13-10
I am trying to adapt a formula in I2 from another spreadsheet that works
well, but won't in mine. I've traced the error, but I would need help to
understand the help it gives! My formula is this: =IF(J2="0-Jan-00","To be
advised",WORKDAY(J2,1,NWD)). I have a worksheet in the same workbook with a
list of non-workdays, and defined the column of dates with the name "NWD".
What I expect the formula to do is this: If J2 is Feb. 4, it would give Feb.
5 in cell I2 because Feb. 5 is NOT a non-workday in NWD. But if J2 is Feb.
5, and Feb. 6 and...help with preview pane and "read receipts"
Hi, I'm new to Outlook administration. We run Outlook on a server wit
Exchange. Is it possible to setup Outlook on client PC's so that th
preview pane cannot be activated by individual users?
Also, can the blocking of "read receipts" by individual PC users b
prohibited within Outlook, at the server level? If not, is there an
other way to do it?
My reasoning for wanting to do the above two things is to make th
"read receipts" function work more effectively.
Thanks for your suggestions.
~~ Message posted from h...Practice downloaded opened but instruction viewer encountered prob
HELP! I downloaded the free trial of 20007 Professional. After viewing
Windows Word 2007 Training 1st session, pressed practice session. 2007 word
downloaded practice screen but the instruction screen attempted to open but
received error message box "MS Office Help Viewer encountered problem and
needs to close." Could not get instructions to complete practice!! Trying to
get a job and need to review & practice 2007 software asap! Any suggestions?
...DEADLINE... PLEASE HELP! Stacked Bar chart?
I'm not even sure how to ask the question so here's what I have...
2003 2004 2005
Actual/Goal Actual/Goal Actual/Goal
Me 1009/1061 591/866 658/897
Comp. A 966/1012 633/811 624/808
Comp. B 699/744 450/593 480/607
Comp. C 957/1005 642/821 665/838
I wanto to show a bar for each competitor, for each year, so there will be 4
bars for each year. Each bar showing Actual performance & Performance Goal...please help with this query
Ost Ocity Dstate Dcity Carrier Price Rank Diff
A B C D X 1200 1 100
A B C D Y 1300 2 100
A B C D Z 1350 3 100
A B C D W 1789 4 100
A1 B1 C1 D1 X1 785 1
A1 B1 C1 D1 Y1 789 2
The rank for every carrier is based on the price . If rank1
is not a pariticular carrier(say if it is not X1 or
Y1 or Z1), then i want to calculate the difference be...Outlook Express Attachments #10
OE strips attachments containing Word docs. How do I
The blocking access to feature is disabled via the security tab under tools
| options. (its the second checkbox from the top.)
Neo [MVP Outlook]
Due to the Swen virus, all e-mails sent to this account will be deleted
"Jim Beam" <email@example.com> wrote in message
> OE strips attachments containing Word docs. How do I
> stop this?
Tools Options Security untick the second check box
"Jim Beam" <firstname.lastname@example.org&...Help with Do...Loop
I need a check to be done to see if column a has a number in it then to
check if column b has a number.
If column B doesn't have a number then I need it to stop and give a msgbox,
When column A doesn't have data then I need the loop to stop as we dont have
to check column b
The code below is what I have but when I try to run it it keeps saying LOOP
I hope someone can help me as I am not very good with loops.
mykeycode = Range("B32")
mysell = Range("N32")
mykeycode = mykeycode + 1
mysell = ...what is the name of a sub form download from microsoft website
i need to add a sub form to a form created in access. i tried to start the
the feature is not currently installed. i try to install but it is looking
for a disk for me to insert. i do not have a disk to insert. can i go to
microsoft website and download the sub form feature for access? if yes, what
is the name of the download.
Are you sure it is not installed? Open your main form in design view. Click
the Toolbox button in the menu at the top. There are two buttons at the top
of the Toolbox, an Arrow and a wand. Is the Wand highlighted. If not, click
on it then click on th...Help on Macro or Formula
i hope someone can help me. i need to create a formula that sits in a cell
and looks for data. ( obvioiusly ). however, the formula needs to be in place
even though the file from ehere the data comes from might not be there yet. (
i have to create a book that when a new file is created, the links are
already in place ). i think it could work with an IF type formula for ( if
B2="",""). here is my information.
A2 = Job no.
B2 = Client Name
D2 = Actual Spend on project
Register!D2 = Job Description
Register!H2 = Quoted Amount
my path is S:\Clients\...Need help with update sql plus filter
I have the following update sql (copied from the query design view)
UPDATE ListQry SET ListQry.ApprovalStatusID =
And (ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID)>300)) OR
(ListQry.ApprovalStatusID)>-1) AND ((ListQry.OtherStatusID) Is Null));
ApprovalStatusID is an integer
OtherStatusID is an integer
ListQry is the recordsource for my form. I would like to add the f...CRM 3.0 Email Attachments
I understand the attachments are stored in the DB iteself. I am able
to find out which table and fields. I see attachment NAME, MIME TYPE,
MIMEID but unable to locate which column in the
MSCRM.ActivityMimeAttachment table the content is stored ? Please
advice. I am trying to download the attachment from the CRM Database
into a folder as a file for a given activityid.
...Download of Money 2005
Downloaded 2005 and keep getting error message that Setup was unable to
install some of the components needed to run money. Try installing money
again. I tried and tried. It will not work. Called support-held for 30
mins.-no answer. What now?
...Rule to automatically mark header to download based on contact list?
Is there a way to do this, or an add-in?
On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> Is there a way to do this, or an add-in?
What version of Outlook are you using?
Ben M. Schorr, MVP
"Ben M. Schorr - MVP" <firstname.lastname@example.org> wrote in message
> On Tue, 26 Apr 2005 04:44:35 -1000, rmc <email@example.com> wrote:
> > Is there a way to do this, or an add-in?
> What version of Outlook are you using?
I have a user who is trying to migrate his .pst file from
one system to another. So he sent his pst file to
himself using OL2002 but when he opens his e-mail in
OL2003 the file is blocked.
I found a list of files that are blocked and according to
the list .pst isn't one of them. Does anybody have a
better list that includes .pst files. Sure would make it
easier to explain to the user
With the research I have done so far this appears to
cleary be a client issue and not an Exchange issue. I
have no problem seeing the .pst and downloading it in
OL2002. The only way so far that...Hyperlink File Help
I am needing some major help. I have a file with hyperlinks in column F that
link to a file on our server. I am needing to test to see if the file exists
and if it does, copy the file to a folder in my documents called
(CapturedFiles) and if it doesn't format the cell color to red. Can VBA do
this and if so how? Any help would be greatly appreciated.
Thanks in advance.
Fileserver or webserver ?
On Nov 23, 7:20=A0am, Aaron <Aa...@discussions.microsoft.com> wrote:
> I am needing some major help. =A0I have a file with hyperlinks in column =