Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

Hi,

Right click the button, Properties Tab and select 'Don't move or size with
cells'.

Mike

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

Sorry,

Right click the button 'Format Control' then follow my previous post

Mike

"Mike H" wrote:

Hi,

Right click the button, Properties Tab and select 'Don't move or size with
cells'.

Mike

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

Hi Mike,

I tried this already but the problem still persists. I missed to mention
this in my earlier post.


"Mike H" wrote:

Sorry,

Right click the button 'Format Control' then follow my previous post

Mike

"Mike H" wrote:

Hi,

Right click the button, Properties Tab and select 'Don't move or size with
cells'.

Mike

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

Hi Mike,

I tried this already and it didn't work out. I missed to mention this in my
old post.

"Mike H" wrote:

Sorry,

Right click the button 'Format Control' then follow my previous post

Mike

"Mike H" wrote:

Hi,

Right click the button, Properties Tab and select 'Don't move or size with
cells'.

Mike

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

is the button linked to a macro?

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.

Yes the button has a macro assigned to it. But the VBA code in the macro has
nothing do with the positioning of the button or anything of that sort. It
simply opens up a form to show some text.


"Patrick Molloy" wrote:

is the button linked to a macro?

"Santa" wrote:

Hi,

I'm using Excel 2003-SP3.

I have a button (Form button NOT a Command Button; I chose it from
"View-Toolbars-Form" controlbox) placed in a worksheet. I also have a list
in a few cells in the adjacent column which is populated from a Range of
values defined in the same sheet.

When I click on the cell that contains the list to pick a value, the button
moves to that cell and resizes itself to that cell's size.

If I make any other cell in any other column to use that list, and click on
them, the same thing happens.

There is no macro written to move the button anywhere. I tried, locking the
cell and protecting the sheet - nothing works out.

This issue looks peculiar.

Can any one please he me address this issue? Please let me know if you need
any further information.

Thanks.