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

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Hide (limit viewers) to column(s) on a protected worksheet. (https://www.excelbanter.com/excel-worksheet-functions/49896-hide-limit-viewers-column-s-protected-worksheet.html)

RAINCITY.1788

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

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.

Henrik

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

"RAINCITY.1788" wrote:

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.

All times are GMT +1. The time now is 03:45 AM.