I just found this site and the questions and answers are great! Here is mine – we are using a spreadsheet to load financial data into an accounting package. Users in different countries will enter their balance sheet and income statement figures into their own version of a spreadsheet. The activity is referenced on a different page and formatted in “flat file” version that will allow the upload. We don’t want to allow the users to change activity that has already been loaded.
To be more clear, there are 12 columns – one for each month – under which data is entered for various accounts on the rows. The spreadsheet calculates the difference from the last month to the current month giving us the net activity. The difference is referenced on a separate worksheet that is formatted to our flat file requirements. What I would like to accomplish is that once a column has been completed – let’s say 5 days into the next month – that the column is locked and the data cannot be changed by the user. It would be an added bonus to have a password on the column so an administrator could change the figures, but in a controlled fashion.
Any assistance in resolving this would be appreciated.
To be more clear, there are 12 columns – one for each month – under which data is entered for various accounts on the rows. The spreadsheet calculates the difference from the last month to the current month giving us the net activity. The difference is referenced on a separate worksheet that is formatted to our flat file requirements. What I would like to accomplish is that once a column has been completed – let’s say 5 days into the next month – that the column is locked and the data cannot be changed by the user. It would be an added bonus to have a password on the column so an administrator could change the figures, but in a controlled fashion.
Any assistance in resolving this would be appreciated.