I know the code is long, and bad, but I'm including it anyway in the hopes that it will give some clue. The activeworkbook.refreshall refers to a bunch of queries on other tabs of the workbook using VisualFoxPro ODBC if that matters...
View 9 Repliesis there any way to hide the comment box associated with with red triangle in the cell.when mouse is on the cell having comment (red triangle) the yellow colour box should not appear.
View 8 Replies View RelatedSuppose a name is typed in a cell as the First name in the front and the Last name following it e.g. Jupiter Jones.
Can it be reversed in the same cell so that it appears as Jones Jupiter i.e. with the last name in the front and the first name following it.
How do I input an IF Formula to prevent Zeros appearing in the TOTAL cell ....
Example: TOTAL Cell (A10) =sumA1:A9
ALSO difference between two sums
Example TOTAL Cell (A20) =SumA10-A19
I have a range of cells and I would like a warning message to pop up if a value over 0.1 is entered. I'm sure it is pretty easy to do, just can't find any info on here and I'm not great with Excel.
View 2 Replies View RelatedI am trying to create a formula that will change the cell color in a range of cells in the row. I want the color to change based on the information in a particular cell appearing on a different sheet. What sheet the information is on determines the color the cells change to.
Example: I have 4 sheets I am working with. We will call them A; B; C; and D. I would like the color of cells A5-I5 on sheet D to change to red when the information in cell A5 from Sheet D shows up in any cell in column A on sheet A. If the information from cell A5 sheet D appears in any cell in column A from Sheet B then the color will be yellow, etc.
I have a table listing certain values (Column C) and their respective probabilities, based on normal distribution (Column D). As these probabilities are dependant only on values from Column C, I'd like to list all the values from that column into another fragment of the sheet, say F6 and below, but each value should appear there only once, no matter how often it occurs in its original Column C (I listed them manually in Column F in the enclosed example). Moreover, if a new value appears in Column C, it should be also included in the new place and sorted in increasing order.
View 7 Replies View Relatedi wanted to know if there is a way which i can so that would tell excel if a certain cell value is lower then another it would give a msg
for example
Cell A1 - 5
so if cell A2 is less then five and a macro is clicked then the macro would give a warning msg hence ending the macro
I am trying to create an Excel spread sheet that keeps track of employees safety tickets and the dates they expire. Is there way to have a cell highlight to a color warning me 30 days prior to the due date listed?
I tried a conditional formatting as suggested in
[url] but that does not work.
I am using Microsoft Office Excel 2003 (MS Office Standard)(SP3)
I need a formula that will give a warning if the date entered in cell is a weekend day.
View 2 Replies View RelatedI want to have a warning message appear when a particular cell function result is a specific number, probably very simple to achieve.
View 9 Replies View RelatedI am trying to find some VBA that will allow protected cells to be updated when a user enters or selects data in other cells.
For example:
Cell 'A1' starts out blank.
Cell 'B1' has a drop down to select specific items.
Cell 'C1' is the date of the order and is a locked cell.
Cell 'D1' is the date of completion and is a locked cell.
The worksheet is protected to prevent direct changes to cells C1 and D1.
If a user enters any information in A1, then C1 displays the current date.
If a user selects 'Complete' from the drop-down list in B1, then D1 displays the current date. Both of these actions are independant of one another. This format is the same for every cell in the 4 columns indicated above. I thought I was able to do this in another spreadsheet I created a year or so ago but I have not been able to figure out what I did and I do not have the spreadsheet to look at.
we have one excel sheet. I want to write or edited data in specific cell. For example anybody can write in coloum : C1, c2, c3, c4, k6 and m6 (highlighted in green colour) and remaining all cell range protcted no one can change data. Also they didn't know formula which i m writing in others cell for example fom l6 to l33 or n6 to n33. We are attach file for ur ready ref to know easily.
View 2 Replies View RelatedI want the user to press a button on the spreadsheet and this should then result in a popup box appearing on the screen asking the user one question ie "what is the current rate"
The user will then enter for example 20%. I then want to transfer this number to cell A1 on sheet 1.
I have a workbook given to me by a coworker who password protected it. I generally use the tab button to navigate when adding information to cells with the number pad. I am unable to use tab when navigating his sheet until the protection is removed. How can I fix this so that I can tab through it when protected?
View 1 Replies View Relatedi had a situation where i import data from web.The sheet contains date & other columns.Whenever,i copy the data and paste it in my worksheet Using Paste Special >> Values i get some numbers instead of Dates.How would i correct the numbers to date format with out loosing the original date format(DD-MM-YYYY). Also the dates are aligned irregularly when i paste them to column.
View 3 Replies View RelatedI have a workbook with several drop-down lists. The names for the lists are on a seperate sheet in the same workbook. I have used data-validation and allow list in all the cells with drop-downs. I have used =NAME in the source. I opened the workbook this afternoon for the first time in a couple of days and I am no longer able to select from a dropdown. I can type in the cells, but if I type something not included in the list, I get the "The value you have entered is not valid" error. So I feel like the validation is working on the cells, I'm just not able to select from a drop-down list. "In-Cell dropdown" is selected.
View 9 Replies View RelatedI have a work sheet with multiple columns and rows. In one column there is unique number which is appearing in multiple rows but it is appearing in different rows more than once like this:
ColumnB
KA0012
KA0012
KA0013
KA0013
KA0013
Now i want to calculate this e.g KA0012 appearing twice as one number similarly KA0013 appearing thrice as one number how can i do it?
I have my results in cells B2:B55 consisting of three signs which are 1, X and 2.
AB1DateResult218-08-131325-08-132401-09-13X508-09-132615-09-132718-09-132822-09-13X925-09-1311029-09-1321102-
10-13X1206-10-1311313-10-1321420-10-1321523-10-1321627-10-1321730-10-13X1803-11-1311906-11-1312010-
11-1312117-11-13X2224-11-1312327-11-1312401-12-1312508-12-13X2611-12-1322715-12-1312818-12-1312922-
12-1323005-01-14X3112-01-14X3219-01-1423326-01-1423402-02-14X3509-02-1413616-02-1413719-02-1423823-
02-14X3926-02-1424002-03-14X4109-03-1414216-03-1414323-03-1414426-03-1414530-03-14X4606-04-1414713-
04-1424820-04-14X4927-04-1425004-05-1425111-05-14X5218-05-1425325-05-1415401-06-1415508-06-1415611-07-14?Sheet1
Is there any way the next falling sign can be predicted in cell B56? And if so, what would be the measures to guess the next sign?
I am joining two columns of data. first col. has size in fraction format: 7 3/8
second column has text string:
HABITAT CINCY POD HAT ERA BLK/RD
Concatenate= HABITAT CINCY POD HAT ERA BLK/RD 7.375
Changing fraction to decimal, needs to remain fraction.
I have played w/ the formatting to make Number w/ zero decimal places and then selected Fraction, but no luck there.
Something seems to have happened to my Excel. When I make changes and close the workbook or application, the pop-up box asking "Do you want to save the changes you made to [Book1]?" no longer shows up.
So far I've tried running a macro with Application.DisplayAlerts = True, but that only seems to work while the macro is running.
I am trying to open a workbook, testt.xls, through visual basic. Below is the code I am using, but when I execute the code, no workbook appears. Excel itself does not even appear. What am I doing wrong?
Workbooks.Open FileName:= _
"C:Documents and SettingsRaMy DocumentsPortfolio Documents estt.xls"
I have a timesheet from which i need to calculate the number of hours put in by employees on a weekly basis.The timesheet can vary with months and number of employees can also change.
Part of code is below:
Dim i As Integer
Dim j As Integer
Dim c2 As Range
Dim startday As Integer
Dim tempnd As Double
Dim tempdys As Double
Dim weekndsum As Double
Dim weekdysum As Double
Dim store_date As Date
m = 12
store_date = thisDate
For i = 20 To 400 Step 5 "value hardcoded
In this i have hardcoded the value,I need it search auto and run till the last used cell.It should replace the number 400 {in my code above}with the last row used.
Have wrote the following code to enable 7 sheets to be unprotected, the pivot tables and charts housed within them to be refreshed then the sheets to be protected. However, once the macro has finished I need to be able to still use the filters on the pivots to flick through data. I also need the data table to be protected with the exception of a cell range that can be edited (preferably password protected.
Sub Refresh()
'
' Refresh Macro
' Refresh Pivot Tables/Charts
[Code].....
when the user tries to enter data into Ranges E25:E26, G25:G26 OR I25:I26 I want to have my own customised prompt that says: "You are using Imperial Units. Enter drafts in the Imperial range by clicking the Imperial button on the left".
To make it more interesting, the cursor should go to the range that I have named 'Imperial', when the user clicks on the 'OK' button of the above prompt.
I have a worksheet where parts of it is locked with a password. I have a data validation cell with a drop down list. I want to set a password to select and change only that cell.
I don't want the list in the cell to be shown without the password
I'm trying to create a worksheet with only one unprotected cell (simple enough!) and I want to base calculations in other protected cells on a running total of how many times a value has been entered in my unprotected cell. Re-entering the same value would need to be counted.
First enhancement would then be a means of resetting the counter.
Second enhancement would be to check for a valid entry and only then increment the counter.
I know that there is a lot on locking cells but it is confusing to me. I am able to lock a worksheet but that is not what I need. I have an Excel document that has thirty to thiry-six names on it. I do not want anyone able to edit the names. But I do want them to be able to add a name.
Example:
There are 30 students in the classroom. A new student comes in. I want the teacher to be able to add that student to the roster but not able to edit the names above. What do I need to do?
I have locked some cells on my Spreadsheet so other people can not change them. What I would like to know is how do I change the colour of the font? I also would like to Bold/unbold the font.
View 6 Replies View RelatedI created an addin with CUSTOM tab (used custom UI editor) to manipulate the ribbon xml.It works fine at home computer and @ work I distributed and install in user> addin directory and activated using excel options> addin>
But the ribbon I created does not appearing (tried on couple of computers) no luck