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

Similar Threads

Hiding columns 1
Hide Unhide Buttons 3
Hiding Columns 1
macro showing and hiding detail 1
hiding forms button 1
filters for selective columns? 2
Macros - variable columns 1
hiding the cell and the formula bar 2

Top