editing

I have separate text files that need separate editing at the same time always. I would like to find a way to have Excel open each file in a downward column so that I can edit each line side by side. Example would be, I need to go to line 40 in row one, change some text, tab to row 40 on next...

Dear Team, I have an excel sheet which is filled by the employees. Range "B" and "C" have data validation as list set to Yes/ No. If "B" and "C" are marked as "NO", Range "D:F" should be protected from editing. The event should be triggered on Cell value change. Can this be achieved?

Hi there! I have a workbooks which contain 24 sheets. I want to disable the formulas on all sheets (All the formula cells should return zero, blanks, error or any other), If the date in sheet1 cell A1< today(). Manual editing the formulas on all sheets required a lot time. Because there are...

Is it possible for a macro to open a comment box and leave the comment box open for further editing? I want to be able to select the cell then click a button to open the edit comment dialogue box for further editing Currently, any code I tried the box remains closed? Please advise

Picture Question does anyone know how to fix this? Even when I have selected no border, these editing lines still show up. Help!

Dear Friends. I have this option (aloow editing...) deactivated, which allows me to jump directly to the cell in the formula (as you probably know) Let's assume this formula: " = Sheet2!F5". If i double click, i'll go directly to this cell I also have the following code: Private Sub...

Hello. I have a workbook that uses a web import with parameters and it works just fine, however I have rearranged the workbook and need the destination location of the imported data to be in a different location. The only options I see are for either editing the parameters or editing the data...

HI I have this userform whereby I am capturing information that a has a 1. Unit price 2. Quantity 3. Value When I edit the data on the userform to update information, the Value Column in the Spreadsheet returns # Value. This happens for all records. I am not editing the value...

I have the following code which is supposed to loop through all open workbooks which are currently in "Protected View" (the yellow bar where you need to click "Edit" to be able to use the workbook) and it only loops through one or two, then stops and I don't know why. 'protected view fix Dim...

Hey gang, So I've noticed that I am evidently doing something incorrectly when I am invoking a particular bit of VBA code within a source.XLSM file. Here's my program file flow. script.BAT calls script.VBS which calls "ProcessCVS" subroutine within script.XLSM. Here are the pertinent...

I have several formulas that I use in data validation or other instances where the entire formula is not visible in one glance. If I want to update the formula, I need to navigate through it. ( no problems so far). The inconvenience arises when I try to navigate around with the arrow keys to a...

Hello everybody I have a form with an spreadsheet control on it, I need to disable cell editing and if possible selecting and removing... basically all forms of interaction with said form.. I only put it there for viewing however I'm feeding the control some code via the form_initialize sub...

I am using Excel to link to a dynamic database and produce a network map or sorts, but I'm having trouble easily editing the formulas. This is because when I select a cell with the formula I want to edit, the longer formula often covers adjacent cells making them unavailable for selecting. I'd...

Hello, I would like to enable the recording function while I am editing a macro. Sometimes I have no idea what, or cannot remember, particular programming language such as Paste Special stuff. Is there a way to record an action while you are in the process of editing a macro to add in extra...

I have a worksheet in which a cell has 4 lines of data. Each bit of data is put on a new line within the cell using CHAR(10). Sometimes only 2 of the lines are TRUE and therefore only 2 text lines appear within the cell. However, the CHAR(10) function still inserts line breaks between the...

Hello, I have a spreadsheet that multiple people use and it has a button to access another spreadsheet. If that sheet is open by someone else and another user tries to open it, the macro opens it read-only and presents a message box stating that someone else is in the file and that they won't...

Hi all Please may I have some advice on editing the following formula =SUM((C2:C47="Y")*(W2:W47={"N",-1,-2,-3,-4})) I forgot to add some extra conditions to column C These are to ensure either "Y", "P", "S", "A" are met in column C (I'm not changing column w) many thanks once again all...

I'm currently working on sorting a column of data from a PDF file into separate columns to later compare to another sheet. I'm having a few problems getting the data into a workable format, and also don't know how to compare to the other file. These are the specific issues, if someone can help...

Hey! I have a lot of data on an excel spreadsheet which has many columns for different required fields of pieces of data. New data can be input using a user form, and this works well. However now i would like the user to be able to search for a row of data and update/edit the details of this...