Hiding Macro Buttons when right-clicking>Hiding Columns

B

Brooks

I've recorded a macro on a spreadsheet and assigned it to
a button. I'd like to hide that button along with several
columns using the right-click>Hide command. When I hide
the columns, the button is still there. Is there anyway
to hide the botton with those columns, maybe by embedding
the button in a cell?

Thanks --

Brooks
 
R

Richard Choate

For the button properties, check to move and size with cells. Then it will
hide when you hid the underlying column or row.
Richard Choate

I've recorded a macro on a spreadsheet and assigned it to
a button. I'd like to hide that button along with several
columns using the right-click>Hide command. When I hide
the columns, the button is still there. Is there anyway
to hide the botton with those columns, maybe by embedding
the button in a cell?

Thanks --

Brooks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top