ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   labels, comboboxes, etc (https://www.excelbanter.com/excel-programming/303933-labels-comboboxes-etc.html)

Delali

labels, comboboxes, etc
 
hi,
i have a couple of comboboxes, labels and commandbuttons
in a spreadsheet but they tend to scatter all over the
sheet anytime i close and open the file.
is there a way to make them fixed at all times?

thanx

nath

labels, comboboxes, etc
 

-----Original Message-----
hi,
i have a couple of comboboxes, labels and commandbuttons
in a spreadsheet but they tend to scatter all over the
sheet anytime i close and open the file.
is there a way to make them fixed at all times?

thanx
.
Right click on them in the design mode, click format

control. On the properties tab, click "Dont move or size
with cells"

Nath


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

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