shstrating
Board Regular
- Joined
- Sep 8, 2009
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
Excel 2016
Is it possible to make a Shape object unselectable but visible without Protecting the Worksheet/Workbook?
The reason I'm asking is that I've encountered the issue in which ActiveX controls such as Command Buttons, Text Boxes, Check Boxes, etc. change their size if a user is editing a workbook while having their computer connected to multiple monitors where at least one of the monitors is running non-native resolution (such as projecting to a conference room screen).
I've searched high and low across the web and discovered that this is a known issue. I've not been able to find a fix that is reported to work 100% of the time for 100% of the users.
Rather than fight a losing battle, I am now trying to find a way to mimic the look of an ActiveX Text Box and an ActiveX Check Box, and have the underlying Cell be used to enter either text content or an "X", respectively.
To mimic a Text Box I've created a Rectangle Shape (formatted with No Fill and a Border) as a 'picture frame' around a cell. I want the user to be able to click in the cell and type a value.
The problem is that the Shape is selectable and makes it difficult, if not almost impossible, to select the underlying Cell directly. They only sure way to get to the underlying Cell is to click into an adjacent Cell and arrow or Tab over to the desired Cell. This is a user annoyance and results in lots of complaints of the Form being unusable/unfriendly/piece of sh*t/etc.
Back to the original question:
Is it possible to make a Shape object unselectable but visible without Protecting the Worksheet/Workbook? (A VBA solution is fine, although I am not knowledgeable in VBA other than knowing enough to be EXTREMELY dangerous.)
Thanks for any help/hints/suggestions,
Steve
Is it possible to make a Shape object unselectable but visible without Protecting the Worksheet/Workbook?
The reason I'm asking is that I've encountered the issue in which ActiveX controls such as Command Buttons, Text Boxes, Check Boxes, etc. change their size if a user is editing a workbook while having their computer connected to multiple monitors where at least one of the monitors is running non-native resolution (such as projecting to a conference room screen).
I've searched high and low across the web and discovered that this is a known issue. I've not been able to find a fix that is reported to work 100% of the time for 100% of the users.
Rather than fight a losing battle, I am now trying to find a way to mimic the look of an ActiveX Text Box and an ActiveX Check Box, and have the underlying Cell be used to enter either text content or an "X", respectively.
To mimic a Text Box I've created a Rectangle Shape (formatted with No Fill and a Border) as a 'picture frame' around a cell. I want the user to be able to click in the cell and type a value.
The problem is that the Shape is selectable and makes it difficult, if not almost impossible, to select the underlying Cell directly. They only sure way to get to the underlying Cell is to click into an adjacent Cell and arrow or Tab over to the desired Cell. This is a user annoyance and results in lots of complaints of the Form being unusable/unfriendly/piece of sh*t/etc.
Back to the original question:
Is it possible to make a Shape object unselectable but visible without Protecting the Worksheet/Workbook? (A VBA solution is fine, although I am not knowledgeable in VBA other than knowing enough to be EXTREMELY dangerous.)
Thanks for any help/hints/suggestions,
Steve