Hide Unhide Buttons

  • Thread starter Microsoft Communities
  • Start date
M

Microsoft Communities

This is a two fold question:
Q1

I have a situation where a button resides in 2 of 4 columns that hidden
until needed.
When I hide the columns it appears that the button is sized where when I
unhide the columns the button does not show.
Is there a way in a macro that I can size and place the button where I want
it.
Example the button is called "Reset" and it calls a reset macro. It reside
in columns H and J, Columns G through L are hidden until needed. The button
takes up the cells H20 through J21.

Q2
I would like to be able to Hide or Unhide a button using the Text Label Not
the button number.

Thanks for your help
 
×

מיכ×ל (מיקי) ×בידן

Move but don't size with cells'.
Right(!) click the button > 'Format Control...' > 'Properties' tab > select
'Move but don't size with cells'.
Micky
 
D

Dave Peterson

Check your other post (posts???).

Please decide where you want future responses. Then add a message to the posts
that tell us (at least me) where we should look for followups.

I'd hate to waste my time finding out that you had the solution you wanted in a
different group.
 

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