Hi,

I have few columns which require manual data input. And few other columns, which calculates value from the data columns. The workbook will be used in shared way. So I want to protect the formula columns, from any manual data entry.

I have tried the locking cell and protecting sheet utility of excel. But there is a problem. Whenever i used the protecting sheet utility, the "Ctrl+PageUp" keyboard function becomes ineffective for that particular sheet.

As there are large number of sheets in that particular workbook, it is essential that "Ctrl+PageUp" keyboard function works. Because various users require to work on various sheets and "Ctrl+PageUp" keyboard function makes the work faster. So i want to enable it.

Is there any other way to resolve the problem??