allow data editing

  1. B

    Lock Cell range(Defined Names) but allow editing of cell content?

    Hey gang, I have developed an excel template that my company can use to calculate and format their KPI stats. My company desired that the presentation include a header and footer that were Word specific and outputting to PDF. So originally this process involved copying the cells from the Excel...
  2. B

    Open new doc, collect data and save as separate file while remaining linked to original

    Hoping someone can advise me. Firstly for some advice. Can I do this in excel. Secondly: how do I go about it. This is for collecting data for a non-profit org. I have a "Client Analysis" spreadsheet that collects data. 1. I would like the Carers to be able to click on a client name, this...
  3. K

    VBA to Protect ALL sheets with given name but allow editing of unlocked cells.

    Hi Im new to this forum so hope this is the type of question. I have monthly workbooks which i use to verify data from a number of sources, most i have macros to import from supplier spreadsheets. My problem is one field has to be manually added by someone in another department. They need to...
  4. S

    Allow entry only once

    Hello all, I have requirement wherein each cell should be allowed to edit only once. This has to be done for a range of cells. For eg. A1:A10, C1:C10. I have found the below code but it is not working as desired. The second time when you enter in the same column (any other cell) it doesnt...
  5. S

    Locking formulas while allowing data editing

    Hi, I am new to Excel and finding the other answers unclear as to this distinction. This is URGENT as our accounts info is overdue to our tax agent & I still have to enter it all. I have created an income property accounts workbook with 12 worksheets, one for each month of the year. I have...

Watch MrExcel Video

This Week's Hot Topics

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
Top