You know when you go to open a spread sheet and someone else is in it you get the message saying "open read only" "Notify" etc.
I have a spread sheet that isn't showing that message. So users are opening it, editing away and then finding that they can't save it because it's opening in read-only. How do I get that message to show?
I want open particular sheet in a workbook after showing warning Message .
View 5 Replies View RelatedI have a spreadsheet set up to automate calculations and control data input for in process quality control checks. The spreadsheet is basically a series of input boxes requesting information from the user. To control the input of part numbers I have some code for a userform which populates listbox within the userform from another closed spreadsheet (opens & closes without updating screen) & enters the selected data from the listbox into a selected cell in the spreadsheet
all the input boxes and calculations are working well, the userform works well, BUT when I include the userform within the code I get the following problem, an error saying that I am trying to change data in a protected cell where data has been entered and then protected by the VB code, even though the code is not trying to change the cell.
I have tried just loading and unloading the userform and everything works well, it only fails when I actually use the userform, and then close it. from this I am fairly sure the problem lies within the form so I have been through the form code line by line and deleted anything that is not vital and the problem persists. Here is the form
Private Sub CommandButton1_Click()
Dim Msg, Style, Title, Help, Ctxt, Response, MyString
Dim Part As String
Part = ActiveSheet.Range("B1")
Msg = "Are you sure you want Part No" & vbNewLine & Part ' Define message.
Style = vbYesNo + vbDefaultButton2 ' Define buttons.
Title = "SELECT PART No." ' Define title.
Response = MsgBox(Msg, Style, Title)
If Response = vbYes Then ' User chose Yes.
Set_Data_1 ' Perform some action.................
I have a spreadsheet gathering information on vehicles. One of the pieces of information is a 'Date Off Strength'. For the vehicles still on strength I have the symbol '#N/A' showing,, this is linked to a sheet using a VLOOKUP formula, is there a way to stop this symbol showing
View 4 Replies View RelatedDoes anyone know the code I would use to input a message box into a spreadsheet that says "Do NOT click on this cell" when a user clicks on cell C5? I only want this message to come up if the user click on cell C5.
View 9 Replies View RelatedI have a question related to Userform and/or Message box. In case a macro solve and displays the result as in Userform and Message box then is it possible to write (type) the values to the excel sheet without closing the Userform or Message box ?
View 2 Replies View RelatedI Have a tool which will be used online & offline.
I would like a box to appear on the opening of the spreadsheet which asks the user "Are you online?", with options "Yes" & "No", if the user selects "Yes" then a macro (which i have already written) refreshes the spreadsheet.
if the user selects "No", the sheet is not resfreshed.
What is the best way to do this?
get the code for sending multiple emails as per the spreadsheet list. Assume the spreadsheet has 100 line items and each columns specifies the name of the person, value, recipient email address ("To" and "CC") and sender name.
And the Body of text is :
Hi "Name of the person" Please find the value of "Value" to be paid for the moth of xxx and kindly let me know for further clarification.
How do you add icons into a message box. ie a warning triangle etc.
View 3 Replies View RelatedWorkbook 1 has 2 spreadsheets. Spreadsheet 1 contains Item and Pass/Fail Columns. under the item column is the serial number of the item tested. the Pass/fail column has the serial number duplicated if it failed tested. what is the formula is to have spreadsheet 2 pick the items from the pass/fail column on spreadsheet 1?
View 4 Replies View RelatedI have attached a document paralleling a document I am working on. The dollar amount in each spreadsheet represent sales. I have entered in values into the candy, soda, and chips spreadsheet. I have also linked values for candy into the total spreadsheet. My question is can I somehow type something or drag the formula down to populate the other cells in the total spreadsheet?
The idea I am thinking but which I don't know how to implement is to list all the items (as in column G) and list all of the relevant cells (e.g. B1 in the Candy spreadsheet) as in columns H and I (Note that all items will have the same cells but the cells will have different values...e.g. all three items have a cell B1 and B2 in their spreadsheet but these cells contain different values). I then try and fail to create a formula in cell B3 of the Total spreadsheet. I am trying to create a formula of the following nature:
='(Spreadsheet Name From Column G)'!(Cell Name From Columns H and I)
The Second half of the formula doesn't really concern me (i.e. the cell name from column H and I). However I am perplexed as to how to achieve the goal in the first parentheses above.
I have two spreadsheets, one gives me the beginning and end of civil twilight as a measure of day vs. night. The spreadsheet has Date/Time in the first column, and the value 45 in the 2nd column when it is night. The second spreadsheet has also 2 columns with date/time and body temperatures of a squirrel. I want to get basic statistics (mean and standard deviation) of the squirrel's nocturnal body temperature, that is for times when it is night (value 45). The tricky part is that Date/Time of both spreadsheets are different. The procedure has to recognize that the date/time of body temperature lies between the beginning and end of the value 45 blocks of the first spreadsheet.
files: twilight sheet squirrel temperature
I have a spreadsheet that I have a lot of macros that are attached to a customized toolbar saved in the same spreadsheet. I saved this is a read-only file. When I open as read-only and run my macros (testing), I save it as another file. When I then open the "template" to do the same thing, the toolbar/buttons now reference the file I previously saved as something else. Help please? Is there a macro that would delete all macros before saving the file as something else?
View 9 Replies View RelatedOften I need to add data from one spreadsheet to the appropriate places on another spreadsheet. For example:
Sheet A has 10,000 records with these fields: id#, name, address, place of employment.
Sheet B has 5,000 records these fields: id#, GPA, college major, type of degree.
Some of the records in B contain information for the same id#'s as sheet A. I want to add this information together so that a Sheet C will have these fields: id#, name, address, place of employment, GPA, college major, type of degree.
I have noticed that the basic problem I have is a common one on this forum with different varibles for different people. I have attached a dummy copy of the spreadsheet that I am using.
I need to copy cell information for one spreadsheet to one of 2 other spreadsheets depending on a dropbox condition. The master spreadsheet is the Issues spreadsheet, and depending on whether the user chooses Transferred Complaints or Transferred Offences (in Column K) I need to transfer certain cells to the Complaints or Offences spreadsheets.
The information I need to transfer from Issues is: .....
I have 2 sheets in my excel spreadsheet. One tracks data for a number of projects five different employees are working on. The other sheet is where I want to total up the number of minutes each employee has worked on their individual projects. I tried writing an IF statement like below but I am only getting the total in the first field even if the employee's name is not Employee 1....
[Code] .....
How I can write this so their totals show up in the correct row?
I have a Main Customer Spreadsheet. I want to Auto Populate FROM the Main Customer Spreadsheet to a New Spreadsheet. I want to be able to key in a customer name on the New Spreadsheet and take the info for that customer from the MAIN Spreadsheet and fill in the blanks. I need to be able to do this several times a day.
View 3 Replies View RelatedIt also renames the CommanBarPopop with the new filename.This allows the user to open both Projectworkbooks/files (If required) and load each CommandBarPopup for different filenames .Therefor opening the Userforms and worksheets for the CommandBarPopup clicked ...
View 9 Replies View RelatedWondering if there is an easy way to compare 2 spreadsheets that should have identical data on them? The first spreadsheet (Before) has the output data from 'before' a code fix was applied. The second spreadsheet (After) has the output data from 'after' a code fix was applied. The spreadsheets have 7 columns of data and almost 500 rows.
I've already copied the data from the source datasets provided by my IT folks into Notepad (.txt) files and then used Excel to open them as fixed width spreadsheets. I have 1 workbook with 1 spreadsheet with 'before' data. And, I have 1 workbook with 1 spreadsheet 'after' data. And, I have another workbook that contains both worksheets. So, I'm ready to go whenever I get hints of what to do next. :-)
I need to be able to show my client that we did not impact the data with the code fix that was applied. I want to be able to show my client contacts (business folks) an end result via Excel that confirms that I actually compared the 2 sheets and there were no differences. In other words....I can't just show them a formula with '0' as it end result (even tho that's basically what I'm trying to prove).
I need to write a macro that will import data contained in another spreadsheet, but am unsure how to do this. I have several (about 15) spreadsheets that contain data. I need to import key bits of this data into one central spreadsheet that will be used for reporting purposes. I only need 2 cells worth (values) from each source spreadsheet, to be pasted into the destination spreadsheet, into designated cells.
The source spreadsheets are usually closed down and kept on a file server, which my PC has access to. Ideally I want to activate this macro with a control button - i.e. I press the button once and the macro goes off and collects/updates each field with the latest data stored in each of the source spreadsheets.
I have a tab within a workbook where i want the user to copy a different spreadsheet into and then press a macro button to run some code, however after this button has been pressed i want this one tab to show any changes that have been made to it, i.e make the cell red or something just so i can keep track of manual adjustemnts.
I am trying to write a UDF that uses the TRANSPOSE and MMULT functions, but I keep getting #VALUE! errors...
View 3 Replies View RelatedI wish to Automatically copy the TEXT that is written from Spreadsheet 1 cells D5 to F5 to Spreadsheet 2 cells F5 to J5 .... a similar range of cells.
Is there a formula I can use or do I need to venture into the programming side of things.
I am currently having an issue with the formula below showing a zero when there is no data, now i am referencing from this cell to another sheet but even with the IF(ISBLANK inside the formula on the other page it still shows a zero which is messing up what i am trying to do on another page.
This is what i am using
=(MAX(P5:P47,P60:P102,P115:P157,P170:P212,P225:P267,P280:P322,P335:P377,P391:P433,P447:P489,
P503:P545,P559:P601,P615:P657,P671:P713,P727:P769,P783:P825,P839:P881,P895:P936)
This is the cell number that has this formula which it is telling me the max number for the column - P938
I am referencing to another sheet like this =IF(ISBLANK('sheet 2'!P938),"",'sheet 2'!P938)
How i get this to stop showing a 0 if there are no data for it to search for the max?
I have a cell that contains the =Day1!G4. It reveals what is on another worksheet, but I want to be able to have the next cell be: =Day2!G4. Is there any way that I can code this without having to physically type in every cell? I tried, =Day1+1!G4 but it didn't like that.
View 12 Replies View RelatedThe formula that I came up with perfectly works well with clear values. Everytime there's a #NUM!, #VALUE! in my array, the result I want wont show up.
=(SUMPRODUCT(--($B$17:$B$22=C4),--($C$17:$C$22=$D$3),--($G$17:$G$22)))/D4
When I tried average+if and it still gave me the same error!
=AVERAGE(IF($B$17:$B$22=$C$4,IF($C$17:$C$22=$D$3,$G$17:$G$28)))
I am creating a spreadsheet system for storing school grades, and I have a sheet on my system which shows graphs of the students data, and on this sheet there are rather a lot of graphs, and its sort of a visual overload to see so many graphs on one sheet. Im just wondering if there is any thing which I could insert which would give the person using the system a choice of which class's graph they want to show.
View 1 Replies View RelatedI have a column in which all cells do a vlookup. how can i not show the #n/a ?
View 9 Replies View RelatedMy mind is going, I can not remember how to use the background color to show the highest number in a group of cells automatically.
View 9 Replies View RelatedI can't get the zero's to show up in the part number formula in the wooksheet. Also how do you get the zero's to stay when you type numbers such as (03,04,ect.) the zero always disapears. I need it to stay as a number and not text.
View 6 Replies View Related