Buttons disappear when rows are hidden/unhidden

Hi,

In an Excel 2010 worksheet the buttons set to group and then hide and save the workbook and close the work book.
when you reopen the workbook and unhide the buttons got disappear, please help me out.

Thanks,

Murali

right click on the button - go to properties
There are options to move and resize with cells (this is the default) uncheck that

Thanks for your reply,

There is no option to uncheck, by default we need to use any one of the below three.

I have tried the below three options,
1. Move and size with cells - Button hiding but appearing when reopen the workbook and unhide the rows
2. Move but don't size with cells - Button not hiding when hide the rows
3. Don’t move or size with cells - Button not hiding when hide the rows

Thanks,
Murali

Sorry,

1. Move and size with cells - Button hiding but not appearing when reopen the workbook and unhide the rows

choose 3. Don't move or size

Hi,

I have used the third option but buttons are not hiding when I hide the rows. Please help out any other options.

Thanks,
Murali

I generally try to put buttons at the top of my sheet if the rows are going to change, that way the buttons don't move around or obscure anything.
What are your buttons for? and how many are there

Hi,

Here is our user requirement. We have four buttons in each sheet; there may be multiple sheets,
The buttons are used to connect the other system to Pull , Save and undo the data.

Before user send the file to the Field user they want hide the top section “Secured area” (say top 5 rows which includes buttons). When the file comes back from field user, we need to unhide the buttons from the sheet.

Thanks,

Murali

Hi,

Can any one help me out on the above issue. Thanks.

Hi,

Can any one help me out on the above issue. Thanks.