Automatic Display of ApproveIt Menu upon Excel Opening

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel Misc
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - is this filter possible? I have a list of customers on sheet 1 cell A1. I need a filter that will display specific cells for specific customers. For instance, when the list in A1 reads ABC Lumber Co., I would like to see cells columns A through F lines 601 through 622 directly below the list cell. Is this possible? -- bob Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784085
  - 2
    - calculate moles in excel HELP! How in Excel do I work out how many moles are in 1kg of water. Desperately need an answer for Monday morning. :) Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784083
  - 3
    - Disabling Automatic Date Thing When i type '5-10' for example, and then press enter or leave that box, the '5-10' i typed automatically changes to '05-Oct'. It's really irritating and it happens with others, such as '10-15', basically anything that looks like a date. How do I turn this off? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784079
  - 4
    - Disabling Automatic Date Thing When i type '5-10' for example, and then press enter or leave that box, the '5-10' i typed automatically changes to '05-Oct'. It's really irritating and it happens with others, such as '10-15', basically anything that looks like a date. How do I turn this off? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784078
  - 5
    - Row-Entire row changes color (and stays) selecting first entry I have a sheet with 63 rows and 30 columns. I would like the row to change color and stay as I slide across columns. Freeze panes works almost but to change color would be better. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784077
  - 6
    - Numeric formatting Hi, I need to format numbers as 10E-3, 10E-5, or 10E-6. I need to maintain the 10E-x format. Not scientific or engineering notation. It's for recording Bit Error Rate measurement results. Any ideas? Thank you for your help. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784074
  - 7
    - Excel "If" Function formula Hi I need some help figuring out if it is possible to create a formula. I'm trying to link information from different pages in a spreadsheet that contain id's for people and prices they are paying for some items my church is selling. We have a main worksheet that lists their names and the ids and then we have another worksheet that lists all the items they can buy with it's price. Is it possible to create a formula in the name page that says "If you find id #1 in column A, then sum the prices from column D". The ids will be spread out throughout column A so we need a formula to locate each instance of the id and then grab the price listed each time in column D and sum those prices up. Is this possible and if yes can someone tell me how to do it. Thanks Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784068
  - 8
    - Min Sumproduct formula returns a zero. I have a spreadsheet. Which can be viewed on my public box link http://www.box.net/shared/movk8u3cws My headings are A3 Date, B3 Name, C3 Contribution E3 12/08/07 Date=A3 Name=B3 Contribution=C3 12/8/2007=E3 Andy=F3 12/8/2007 Andy 1 12/8/2007 Andy 40 12/8/2007 Andy 3 12/8/2007 Andy 4 Date=A11 Name=B11 Contribution=C11 12/8/2007=E11 Andy=F11 12/8/2007 Andy 1 12/8/2007 Andy 40 12/7/2007 Andy 3 12/8/2007 Andy 4 In E3, I entered 12/08/07 and in F3 I entered Andy. I want my formula in J11 which is =SUMPRODUCT(MIN((B6:B9=F5)*(C6:C9=G5)*(D6:D9))) to return the minimum contribution that Andy made on 12/08/07. When I substitute Min for Max, the formula works with no problems at all. As soon as I switch to Min the formula returns a zero. It will work if all the dates and all the names are the same. But as soon as the Date or Name changes I get a zero fpr the Min formula. I even entered it as an array but it won't work. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784062
  - 9
    - vba programming in excel 2007 how i can use vba programming in excel 2007 to sort in column in ascending order give me reply as a i am beginner. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784058
  - 10
    - Count after given condition is met Hi all would like your help for the following Need to count which and how many numbers appear after a given number ie After After After After After After 1 2 3 4 5 6 1 2 1 1 3 1 1 1 1 4 1 2 3 1 1 5 2 1 6 1 this was obtained from data on column c, that is displayed as follows: 3 5 4 5 3 4 4 2 4 3 4 4 3 5 6 4 4 3 3 4 2 3 2 Tks in advance Antonio Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784053
  - 11
    - Excel - how to autofill thousands of cells quickly I have a spreadsheet with 35000 rows. Is there an easy way to autofill a formula for all of the rows instead of dragging down all 35000 rows? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784040
  - 12
    - Pivot Table % Calculation Issue I am bringing in the data below from SQL Server. I cannot add a calculated field because it is removed when it is refreshed. The issue is with the SUM of the GP% ((GP $/Sales)*100). I manually added another column to the right for only the ones that are wrong and what it needs to be. Spent too many hours trying to resolve this one. Data Store Order No Description Sales GP $ GP% GP% Needs to be BR 00000231 SPRING RED 11.99 6.49 54.13 00000231 Total 11.99 6.49 54.13 00000232 SPRING RED 11.99 6.49 54.13 00000232 Total 11.99 6.49 54.13 00000233 BALL RACK 49.99 24.99 49.99 00000233 Total 49.99 24.99 49.99 00000234 BLUE PUP 39.99 19.49 48.74 00000234 Total 39.99 19.49 48.74 00000236 BLUE PUP 39.99 19.49 48.74 SPRING RED 11.99 6.49 54.13 SPRING YEL 11.99 6.49 54.13 00000236 Total 63.97 32.47 156.99 50.76 00000237 READ RACK 14.99 7.49 49.97 BLUE PUP 39.99 19.49 48.74 SPRING RED 11.99 6.49 54.13 00000237 Total 66.97 33.47 152.83 49.98 00000238 BALL RACK 49.99 24.99 49.99 00000238 Total 49.99 24.99 49.99 00000239 SPRING YEL 11.99 6.49 54.13 00000239 Total 11.99 6.49 54.13 BR Total 306.88 154.88 620.93 50.47 Grand Total 306.88 154.88 620.93 50.47 Any suggestions would be greatly appreciated. Jeannette Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784035
  - 13
    - comparing from two worksheets Hi all, I am trying to compare from two worksheets. What I have is the inventory that my headoffice is telling me I have and the other is the actual inventory I have I want to compare the two by product number and discription giving the head office total per item, my total per item and the difference between the two. I have a general knowledge about this but I thinking its over my head. Help required. Thanks Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784032
  - 14
    - display specific next highest value from a column containing multi Just cant seem to get it. I am working with data in F10:F100 that contains numbers like (1,2,3,4) as well as lettered numbers like (C1,C2,C3,C4). I can not come up with a formula that will index this column and return the next highest C number. F9 needs to display the next highest C number. I can get this to work with the standard numbers only (1,2,3,4). Any suggestions Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784030
  - 15
    - e mail same body different subject Hello I copied the code below. Now is it possible to change the line Subj = "Your Annual Bonus" Here is the thing, the body of the e mail will be the same for everyone but the subject will be different. How do I do that? thanks Sub SendEmail() Dim cell As Range Dim Subj As String Dim EmailAddr As String Dim Recipient As String Dim Bonus As String Dim Msg As String Dim HLink As String For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants) If cell.Value Like "*@*" Then 'Get the data Subj = "Your Annual Bonus" Recipient = cell.Offset(0, -1).Value EmailAddr = cell.Value Bonus = Format(cell.Offset(0, 1).Value, "$0,000.")V Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784025
  - 16
    - working with graphics and formating them how to create amortization tables Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784022
  - 17
    - Validation malfunction I'm using Excel 2004 11.4.1 on Mac OSX 10.4.11. On a page with several columns of cell validations, randomly, one cell will control the input to a different cell or shows a double pull down arrow on the right and will not clear or delete. What's going on? Is there a fix for the software and the affected files? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784021
  - 18
    - Customize a macro button I would like to create my own symbols so that when I add a macro button to the command line it's easier for me to understand. Is there a way that I can create my own symbol so that it's available in the modify button dialog box? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784016
  - 19
    - Where did MS hide it in 2007 ?? In 2003 -- View > Toolbars > FORMS Where is the above in Office 2007? Bob Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784012
  - 20
    - Compatibility Checker Where is the "FIND" in the Compatibility Checker. Some of the formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of excel without opening the linked workbook, character beyond the 255 character limit can not be returned. The help portion of excel instructs to do the following to resolve! In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid #VALUE! errors. Can anyone walk me throught the steps so that I can correct and remove the links - how do I find where the links are> Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784010
  - 21
    - Deleting and Copying Marco code Hi, Can any one please help me with writing a code in visual basics? What i am trying to do is this: I want to create a button called 'close' in row 1(sheet 1) and when I click this I want a marco to run which will delete the entire row that the button is on and then paste that row into row 5 in worksheet 2. I want to repeat this for the next row however, when the second row is pasted into worksheet 2 i want the second row to be pasted in row 5 and the first row move down to row 6... I hope this makes sense and would really appreciate any assistance from anyone as i am not to familiar with writing up codes...THANK YOU in advance! Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784007
  - 22
    - Help, please Worksheet is sorted by dates in Col. A. Dates have varying number of rows; i.e., 5-6-08 may have 29 rows of data; 5-7-08 may have 14 rows; and 5-8-08 may have 42 rows. How can I automatically transfer to another worksheet the values in the last row for a date? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 784004
  - 23
    - Popup Input Box Hi, I'd like to have a message box popup whenever the word INPUT appears in a certain cell. Cell A1 have a formula to lookup another cell. If that cell does not have a value, cell A1 will show the word INPUT. Whenever A1 shows INPUT, i want a message box to appear to request for user input. I know how to create the form for the input and i know how to place the input value into cell A1, but I just do not know how to get the message box to popup. Also, I need excel to automatically monitor row by row, ie, users will key in row by row. So, if A1 shows INPUT, the message box will appear. then after they key in the INPUT and go on to the next row, if A2 shows INPUT again, another message box will appear. Thanks. Dolphin Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783998
  - 24
    - Creating a code for a macro Hi, Can any one please help me with writing a code in visual basics? What i am trying to do is this: I want to create a button called 'close' in row 1(sheet 1) and when I click this I want a marco to run which will delete the entire row that the button is on and then paste that row into row 5 in worksheet 2. I want to repeat this for the next row however, when the second row is pasted into worksheet 2 i want the second row to be pasted in row 5 and the first row move down to row 6... I hope this makes sense and would really appreciate any assistance from anyone as i am not to familiar with writing up codes...THANK YOU in advance! Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783997
  - 25
    - Creating Amortization tables in excel 2003? how do I create amortization tables in excel 2003 Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783995
- Next
  - 1
    - excel doubts i would like to know if the following 2 procedures are possible and, if possible, how to carry them out- 1) for example, if i type the name of a month, say may, and in the next cell i type a no., say 5, it should automatically fill out like this-'05-05-2008' 2) if i've prepared different sheets regarding different customers but i would like to type the whole data in 1 sheet the data pertaining to different customers should automatically transfer to their respective sheets waiting for your reply mehvish Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783989
  - 2
    - Linking I am using Excel97 and want to know how to change links to another worksheet in the same workbook? For example, I have worksheet OTB DEC and OTB JAN in workbook OTB1. In a separate workbook, I have linked the values from worksheet OTB DEC in column A. In column B I need the same exact cells linked, but from the the worksheet OTB JAN. How can I do this without having to either relink column B or type over "OTB DEC" with "OTB JAN" in every cell? I cannot use change source because they are both from the same workbook, OTB1. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783970
  - 3
    - Reverse Pivot-type Data (that's not a pivot table) Data is not in an actual pivot table (so it can't be reversed to get what I want), it's just entered in a crosstab format: June July August Andy 2 3 4 Dave 3 6 2 Any easy way to convert it to this format? Name Month Sales Andy June 2 Andy July 3 Andy August 4 Dave June 3 Dave July 6 Dave August 2 TIA. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783968
  - 4
    - sum if with multiple criteria how can I use multiple criteria and the sum if function. how could I sum for "red apples"? ColA ColB ColC red apples 5 green apples 2 baby carrots 1 red apples 3 Thanks -- djk Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783959
  - 5
    - Saving Formulas when addin rows I have a ss that I need to keep track of 12 weeks on information. Each week I need to add a new row either by moving the remaining rows down or deleting th lar row and insert another row. Either way I do it I lose my formulas for the new row. Example Row 2 has formulas in columns F, G, H I now move the data in row 2 down, the formulas in F, G, H are gone as well. On the bottom of the SS I have formulas to add certain rows together. Before I move row 2 all columns have correct formulas. I add the new row which no becomes Row, the formula is no longer in row 2 and I have to edit every row to include row 2. Sorry to be so wordy but I need help! Thanks Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783958
  - 6
    - PivotTables and Sum/Count 2 columns I have an Excel worksheet with four columns; Relationship ID, Account Name, Summary of Market Value and Account ID: Realtionship ID Account Name Summary of Market Value Account ID SEAR Sears $3250 20010 SEAR Sears $5345 20010 PENN Pennys $3236 20011 MARS Marshalls $4444 21222 MARS Marshalls $3244 21222 What I would like is to find the total count by Account Name with their Individual and Total Revenue I have created a PivotTable using Account ID in the Data field, and the rest of the fields in the Row field, Relationship ID, Account Name, and Summary of Market Value. The PivotTable displays almost all of what I am looking for with the Relationship Code - Total, Account Name and Sum of MarketValue per Account name and then the final column contains the count of the Account ID. What I am missing is the total of the Sum of MarketValue for each Relationship ID. Is there a way of adding this? Thanks Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783949
  - 7
    - HELP! In desperate need of a formula I'm working on a settlement statement that is 112 pages. Column G=the attorneys' name and Column F=rates for the different attorneys. Different attorneys have different rates. At the end of my statement, I have a section that needs to tally each attorey's fee for a total. I can't come up with a formula that will calculate this. Please help! I'm up against a hard deadline! Thanks in advance! Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783945
  - 8
    - formula fill down =IF(DataInput!D3="Standard",R4+R4*19.25%,IF(DataInput!D3="Recommended",R4+R4*Q4,0)) how do i reference a cell in a formula and not have it change all down the columns? Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783938
  - 9
    - Inconsistent Cell Functions I have a template that we use for financial reports. When we input data we sometimes hit enter and sometimes use the arrow keys. Although I am not aware of any template changes, all of a sudden when we hit the down arrow, EXCEL adds that line to the formula. Example. CELL B4 input 143 then hit the down arrow and B4 will read 143+B5 This is not true on every cell. We have other Excel Documents that the down arrow juts moves to the next cell. This is new and we are wondering how to make it consistent. When we hit down, it should just go to the next cell. Please advise. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783935
  - 10
    - Pivot Table question or a simpler suggestion Hello, I have a group of data. Among the data fields are the following: Name Group/Association Number of rankings The number of rankings are either 0, 1, or 2. I would like to be able to know for a given group, how many members of the group have at least 1 ranking. My first thought was a Pivot Table but if I use the count field setting, it counts all populated cells. If I leave the cell blank, that works instead of using a zero but I would prefer not to leave it blank as it may cause confusion to others I pass the sheet on to. I thought about writing something in VBA but this seems a little advanced for my vba skills. Is there a way to count only non zero values with a pivot table? Is there a simpler solution that I may be overlooking? Thanks. -Mike Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783934
  - 11
    - XIRR - Function Missing Hello, I used XIRR many times in the past but today when i tried to use it, i couldn't. I checked the Data -->AddIns and the ATP is clicked so i don't understand why it's not working. I'm using Excel 2003 and as mentioned before - used XIRR many times in the past. I also tried to check and uncheck the ATP and even restart the computer, and I still can't find the XIRR.... any ideas why this is happening and how I can fix it? HELP!! Thanks! Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783932
  - 12
    - Conditional Formatting for Excel 2003 D2 has start date( Goods ordered) 02/06/08 E2 has end date (Due date) 16/06/008 F2 is for order confirmation =96 either blank or Yes G2 is a date for Goods Received Please help. In F2 or G2 which ever is convenient, I don=92t even mind having helper columns. I want Color Formatting based on following criteria: If F2 & G2 are blank & its 7 days before F2, I want to show Brown color for chasing order confirmation. If F2 or G2 are blank from 2 days before due date and until the F2 or G2 are populated, I want to show red colour. I hope this makes sense. Regards, Lee Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783929
  - 13
    - Sort in a Pivot Table Greetings, Need help as I can't seem to get my pivot table to Sort. Want to sort by ascending or descending based on value in total column of data. I try the Pivot Table/Sort and Top 1 but only seems to give me option to sort the first column. Any help or direction is appreciated. Thank You! Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783928
  - 14
    - Protecting a sheet and keeping grouping Hi all, attached is template I am using for a VB program. I need th grouping function and filter function to remain, but need to lock dow the formatting on the doc. The VB program open and populates populate about 80 of these templates every time it runs, so I really can't d this on a one by one basis. The filter function is working, but no luc at all with the grouping. I would like to be able to password protec the file as well. I have tried little snip-its of code hear and there but nothing seems to work. Help +------------------------------------------------------------------- |Filename: FRED_111.zip |Download: http://www.excelbanter.com/attachment.php?attachmentid=115 +------------------------------------------------------------------- -- TommyD Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783926
  - 15
    - Macro Dialog Box Hi, Is it possible to create a dialog box that would allow me to enter the following information in and have it placed on each tab in a workbook? Piece Name - Text Field Year Made - text field Edition - text field Picture/File - browse button to find the file to create a hyper link and a seperate option to have a screen tip Status: dropdown Notes: large text Field Mold Y/N - Radio button Location of Mold - Dropdown list Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783916
  - 16
    - Unable to save modified Excel 2003 worksheets using Excel 2007 I am using Excel 2003 and have about 80 users filling out worksheets that are linked to a master workbook to collect the data. Everything has worked fine until 3 users received new laptops that are using Excel 2007. They can open their spreadsheets and enter their data but they are unable to save the changes. They tell me they receive an access denied message. Our IS director says that there shouldn't be any problem using the two different versions of Excel together. Any feedback will be greatly appreciated. -- vkeller Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783913
  - 17
    - PivotTable Sums I have an Excel worksheet with three columns; Account number, Account Name and Total. The Account Number and Account Name can have a one to many relationship and so can the Total. For example: Account NumberAccount Name Total Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783910
  - 18
    - how to calculate a credit card Hi all Iâ??ve got Excel 07,but am stuck . I used the PMT function to calculate to pay off a credit card by entering the APR and how long i wanted to pay and the balance that was on the card to tell me how much to pay each month. Am now want to calculate if i paid off a SET AMOUNT EACH MONTH with the APR how long this will take but i donâ??t know the function to use. Any help from you guyâ??s and galâ??s would be much appreciated. Paul. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783907
  - 19
    - Improting Excel into Outlook I have never had a problem importing excel files into Outlook. The original source is Access. Today, I keep getting the same error message and I do not know why it is doing it now or how to solve the problem. The Error message is: >>>File name has no name ranges. Use Microsoft Excel 97-2003 to name the range of data you want to import. I have never had to do this before in exporting from excel to Outlook contacts. I would like to have it so I do not have to do this everytime I import from excel. any words of wisdom would be greatly appreciated. Christine Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783906
  - 20
    - Excel opens but does not open file When a try to open a Excel file the application opens but not the file until I go to Open. It just started doing this, and only Excel has the problem. -- Dianne Griffin Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783903
  - 21
    - Making Lists of numbers Hello I need to fill Column aye with the numbers 0001-3000 obviously it will make me very unhappy if i have to type each number in the field. is there any way that excel just fills in the rest of the values? (and leaves the extra zeroes on the front?) thank you. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783898
  - 22
    - Referencing a cell's data & format in Excel 2004 for Mac I am referencing a cell from one worksheet to another. The formula I am using is =Sheet2!A2 The problem is, that it is referencing the data in the cell but it isn't referencing the format of the cell. Is it possible to reference both the data & the format? I don't want to do this one time, I want Sheet1 to automatically update each time the data or format on Sheet2 changes. Thanks Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783897
  - 23
    - Data Validation/Cell Protection Question I distribute a worksheet to many users to supply standardized data inputs and it includes a lot of validation and cell protection to prevent creativity. Someone beat my data validation rule for a cell by simply copying & pasting another cell over it. In simple terms: Valid entries for Column A (using a list/dropdown) are odd numbers 1, 3, 5, 7, 9 Valid entries for Column B (using a list/dropdown) are even numbers 2, 4, 6, 8 Copying and pasting cell A1 into B1 allowed someone to get an odd number into B1. Additional cell protection in A&B keeps jumping into my mind, but each time I think about it, I realize protection runs contrary to allowing data input. Or does it ? Any suggestions for keeping copy/pasters from getting invalid data into Column B? TIA. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783896
  - 24
    - Conditional Format I would like to make a conditional format for column B, I would like the cell to turn red if it is todayâ??s date and yellow if it is 3 days from today. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783894
  - 25
    - games on excel 2003 program I have several games that were loaded to excel 2003 that functioned properly. now none woek at all. iI can open the file but they will not load up. i have also tried having a file sent by email attachment but those will only have a line of small boxes accross the top. What has happened to my files and how do I fix them?? I originally recieved them all as a email attachment, if that makes any difference. Tag: Automatic Display of ApproveIt Menu upon Excel Opening Tag: 783892

How do I eliminate the ApproveIt Menu from automatically appearing every time
I open Excel?
--
Bonnie

Re: Automatic Display of ApproveIt Menu upon Excel Opening by Jim

Jim
Sat May 10 17:30:56 CDT 2008

ApproveIt appears to be a third party utility, so your best bet may be to just ask at... http://www.silanis.com/index.html
--
Jim Cone
Portland, Oregon USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"Bonnie" <Bonnie@discussions.microsoft.com>
wrote in message
How do I eliminate the ApproveIt Menu from automatically appearing every time
I open Excel?
--
Bonnie

Top

Re: Automatic Display of ApproveIt Menu upon Excel Opening by Bonnie

Bonnie
Fri May 16 09:30:00 CDT 2008

Thank you. You may be right. As I recall I don't have the ApproveIt menu on
my Excel program at home, but I do on the office PC.
--
Bonnie

"Jim Cone" wrote:

>
> ApproveIt appears to be a third party utility, so your best bet may be to just ask at... http://www.silanis.com/index.html
> --
> Jim Cone
> Portland, Oregon USA
> http://www.realezsites.com/bus/primitivesoftware
> (Excel Add-ins / Excel Programming)
>
>
>
> "Bonnie" <Bonnie@discussions.microsoft.com>
> wrote in message
> How do I eliminate the ApproveIt Menu from automatically appearing every time
> I open Excel?
> --
> Bonnie
>

Top