editable

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...

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...

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...

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...

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...

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...

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?

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...