editable

  1. T

    Open file in MS Teams for editing ?

    Hi I want to open a sort of Back-End-file (.xlsm-file) stored in MS Teams, edit some data and close the file with av macro from a Excel “master file”. But I can’t find out how to do it. Everything I do will open the BE-file as “read only”. Please help! I think it is the same if stored in...
  2. E

    How to restrict user to stop editting a formula in a cell but can enter any value if required.

    Hello, I am not sure if this is possible but I have a situation, where, few cells have formulas in them. I want the cell to be editable by the user where they can overwrite the formula with other numbers but at the same time I dont want them to give the ability to edit the formula inside the...
  3. B

    Chart with retail hour coverage

    Hi folks, very new to Excel and need to do a chart that im not too sure how to do, although im sure its possible with how exceptional of a program this is. Basically, I need to do a chart (bars probably easiest), that would have Sunday to Saturday along the top and opening hours along the Y...
  4. sparky2205

    Delete data in selected cells of a filtered range

    HI folks, I have a protected spreadsheet which has every second row editable. At the end of the year I want to be able to delete all of the information from the editable rows of the sheet. When I filter on the editable rows, select all and press delete, I get the error telling me the sheet is...
  5. C

    lock a cell with specifications

    I want to lock a cell which has date in row column, it should be not editable on the row, if the date is in past date and only the present date & Future date row should be editable. If the A1 row date 07-Mar-2018 - the entire row should not be eidtable and it should editable with a password...
  6. J

    VBA Excel. Delete time stamp in protected cells using event code.

    Good morning to all, I wish to delete values in editable rows in a protected excel sheet. I have the following code event Private Sub Worksheet_Change(ByVal Target As Range) ActiveSheet.Unprotect Password:="avalon" If Target.Column = 2 Then Application.EnableEvents = False Cells(Target.Row...
  7. R

    Editable Text Based on Drop Down List

    Hello, I would like to have a drop-down list in A1. Based on the value selected in the drop-down list in A1, I would like a specific parage of text to pop up in A2. I would like for this text in A2 to be editable so minor things can be changed as needed. Is this possible?
  8. R

    Is a pop up, editable text box possible?

    Hi, I wonder if you may be able to help me - I would like a pop up text box (similar to data > data validation > input message) to appear when you click on a cell, but then I want the user to be able to edit it by clicking on the box (rather than going into data validation again...) So not...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top