Thread: restrict access to a column of a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote