Hide (limit viewers) to column(s) on a protected worksheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there away to hide columns & limit the number of viewers that can unhide
the columns (& edit the info) within a protected (read only) Excel
spreadsheet.
 
Make sure that all cells are "Locked" (alt + a --> ctrl + 1 --> protection tab)

Then go to 'Tools' menu -> Protection -> Protect Sheet or Protect Workbook
and assign a password. This will protect the integrity of your workbook/sheet.

Good luck,
Henrik
 
Back
Top