Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a business spreadsheet. I want each new row of data to be made
unchangable (read-only) when the file is closed so entries will be permanent when the spreadsheet is opened the next time. Changes need to be able to be made during the session. If the information is entered in rows 10 through 20 and columns A through M, I want only these rows and columns to become read-only when the file is closed. Anything outside of this range cannot be made to permanently change. Most of these entries will reflect values from formulas. Can it be done? Thank you for any help you might offer. Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spread sheet calculating/not calc from opening file differently | Excel Worksheet Functions | |||
can not open spread sheet file not recognised | Excel Discussion (Misc queries) | |||
Mail merge a spread sheet omitting some entries | Excel Discussion (Misc queries) | |||
How can I transfer a Lotus 123-9 data spread sheet file to Excel? | Setting up and Configuration of Excel | |||
Psswd protect a sheet automatically upon closing file | Excel Programming |