ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   move cursor on limited cells. (https://www.excelbanter.com/excel-worksheet-functions/187051-move-cursor-limited-cells.html)

Invisible

move cursor on limited cells.
 
Hi,

I have a sheet which have dozen of cells and rows but i want that
someone who ever is using that workbook that could move only on
limited cells e.g. only on C3, C15, C48 and E55 the user can edit as
well and if a user try to click on any other cell cursor or mouse will
not be able to select that Cell.

I have already protected that worksheet by password.


Please let me know.


Thanks
F1

Gary''s Student

move cursor on limited cells.
 
1. unprotect the worksheet
2. protect all cells
3. unprotect only the "free cells"
4. re-protect the worksheet
--
Gary''s Student - gsnu2007h


"Invisible" wrote:

Hi,

I have a sheet which have dozen of cells and rows but i want that
someone who ever is using that workbook that could move only on
limited cells e.g. only on C3, C15, C48 and E55 the user can edit as
well and if a user try to click on any other cell cursor or mouse will
not be able to select that Cell.

I have already protected that worksheet by password.


Please let me know.


Thanks
F1



All times are GMT +1. The time now is 07:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com