ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cells that contain data--unclickable (https://www.excelbanter.com/excel-programming/431761-cells-contain-data-unclickable.html)

dgold82

cells that contain data--unclickable
 
I am trying to protect a worksheet but want to make certain cells unclickable
and other clickable. All cells are going to be locked under worksheet
protection but it would be nice to make cells that contain data or text
unclickable to better the appearance for my users.

The only thing is that they need to be able to be active cells since some
hyperlinks point to them from other worksheets. I just don't like the black
border that excel puts around an active cell when it is clicked or activated
via a hyperlink. I just can't figure out how to hide it so I thought I would
try this different angle.


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com