ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide and unhide (https://www.excelbanter.com/excel-discussion-misc-queries/17109-hide-unhide.html)

Marcel

Hide and unhide
 
Hello,

When unhiding a couple of row, the combo boxes didn't appear. The cells were
they suppose to be, showed dots on the cell lines. How do I get my combo
boxes back ?

Thanks in front.
Marcel

Dave Peterson

My bet is the comboboxes got resized when you hid the rows.

If you unhide the rows, maybe you can select the combobox by:

Showing the Drawing toolbar
click on the arrow icon
Use that to lasso the combobox (maybe make that lasso a little larger area than
you would usually expect.)

If you select the combobox, you'll see the drag handles. Resize that way.

You could also select all the shapes:
Edit|goto|special|objects
Then you should be able to tab between objects--watch the screen closely.

Marcel wrote:

Hello,

When unhiding a couple of row, the combo boxes didn't appear. The cells were
they suppose to be, showed dots on the cell lines. How do I get my combo
boxes back ?

Thanks in front.
Marcel


--

Dave Peterson


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com