If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Hide Unhide Buttons
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 |
#2
|
|||
|
|||
Hide Unhide Buttons
Move but don't size with cells'.
Right(!) click the button 'Format Control...' 'Properties' tab select 'Move but don't size with cells'. Micky "Microsoft Communities" wrote: 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 |
#3
|
|||
|
|||
Hide Unhide Buttons
Regarding your second question:
Make use of the buttons CAPTION Property. Micky "Microsoft Communities" wrote: 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 |
#4
|
|||
|
|||
Hide Unhide Buttons
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. Microsoft Communities wrote: 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 -- Dave Peterson |
#5
|
|||
|
|||
Hide Unhide Buttons
|
Thread Tools | |
Display Modes | |
|
|