ExcelBanter - excel and scrollbars

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - excel and scrollbars (https://www.excelbanter.com/excel-programming/386917-excel-scrollbars.html)

Christy

excel and scrollbars

I have made 8 or 9 scrollbars for an analysis. I need to lock and protect
all of the cells in the spreadsheets but still allow any user to change
scrollbars. Help??!!
--
Christy Roe

Norman Jones

excel and scrollbars

Hi Christy,

When you protect the sheet, try protecting contents only,
i.e. exclude objects.

---
Regards,
Norman

"christy" wrote in message
...
I have made 8 or 9 scrollbars for an analysis. I need to lock and protect
all of the cells in the spreadsheets but still allow any user to change
scrollbars. Help??!!
--
Christy Roe

All times are GMT +1. The time now is 05:32 PM.