Excel

[Former Member]

Hello,

I don't know if this is the best place to put this topic but i don't know where to put it.

It's like this, i have a planning function in SAP BW that shows some data in a excel worksheet. i pass a month and he makes that worksheet. What i want is to in the excel sheet i have a line that says all the months and in lhe line under i have a value for each month. I want to lock the cells of the values that are associated to the months that have passed.

like this:

i pass to the planning folder the month 4(Apr) and i want that when the excel sheet shows up, the values corresponding to month 1(jan),2(fev) and 3(mar) appers locked.

[daniel_carvalho]

Ricardo,

In Microsoft Excel, there is an option, called "Freeze Panels" (Congelar painéis). Try to see the help for the application to understand how to get this functionality (I think you will be able to do what you are thinking about).

I hope I had helped you.

Daniel Carvalho.

[rahulkavuri]

automatically disabling cells according to time may not be possible in excel

If u want to disable inout in cells then here's the answer

http://pcworld.about.com/news/Apr062001id15849.htm

<i>Contents of a hidden cell don't appear in the formula bar when the cell is selected. By default, every cell is locked and not hidden. But it's important to remember that these attributes have no effect unless the worksheet itself is protected. First, to change the attributes, select the appropriate cell or range and then choose Format, Cells.

In the Format Cells dialog box, click the Protection tab and select Locked or Hidden (or both). Unlock cells that accept user input, and lock formula and other cells that should stay unchanged (such as titles). To prevent others from seeing your formulas, lock and hide the formula cells: The results of the formulas will be visible, but the formulas will not.Now, to protect the worksheet, choose Tools, Protection, Protect Sheet to bring up the Protect Sheet dialog box. Make sure the Contents box is checked. You can enter a password to prevent others from unprotecting the sheet. Locked cells in a protected sheet cannot be edited, and other worksheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts.</i>