Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.

Excel 2003 - Button moves along with the cell selection
 

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.