ExcelBanter - restrict access to a column of a spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - restrict access to a column of a spreadsheet (https://www.excelbanter.com/excel-discussion-misc-queries/180466-restrict-access-column-spreadsheet.html)

James

restrict access to a column of a spreadsheet

Hello,

Is it possible to restrict access to only one column of a spreadsheet?
--
James

Gord Dibben

restrict access to a column of a spreadsheet

Yes.

Select all columns and FormatCellsProtection. Select the "Locked" option.

Select the one column and FormatCellsProtection. De-select the "locked"
option.

ToolsProtectionProtect Worksheet.

Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 12:00:03 -0700, James
wrote:

Hello,

Is it possible to restrict access to only one column of a spreadsheet?

All times are GMT +1. The time now is 03:02 PM.