ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I lock the position of a textbox? (https://www.excelbanter.com/excel-discussion-misc-queries/125872-how-can-i-lock-position-textbox.html)

Cynthia

How can I lock the position of a textbox?
 
I have placed textboxes in my spreadsheet as a solution to needing to have a
section of cells with different column sizing. How can I prevent other users
of my spreadsheet from moving the textboxes? Is there a way to anchor or lock
these textboxes in position?

Bob Umlas

How can I lock the position of a textbox?
 
Protect the worksheet. Make sure the propteties of the textbox include
Locked.

Bob Umlas
Excel MVP

"Cynthia" wrote in message
...
I have placed textboxes in my spreadsheet as a solution to needing to have

a
section of cells with different column sizing. How can I prevent other

users
of my spreadsheet from moving the textboxes? Is there a way to anchor or

lock
these textboxes in position?





All times are GMT +1. The time now is 09:01 PM.

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