Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default form buttons on sheet collapse on unhide - sometimes

I have a sheet with multiple form buttons. They are placed in a hidden area. When the user chooses to unhide this area (a number of rows) the buttons, like the rows, reappear... usually.

Every so often, the all the buttons collapse into a single black line. They wind up on top of each other. If you select this line, you can re-size each "button" (they have no vertical dimension), and move them back to where they belong. A lot of work.

Why are these buttons doing this? What's the fix?

Here are the format parameters.

Obj pos - move and size with cells
Intern margin - automatic
protection - locked, locked text
scale - lock aspect ratio

Thanks

Excel 2010
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default form buttons on sheet collapse on unhide - sometimes



Write a macro to reset your buttons (here for buttons with topleftcell


Thank you... again.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default form buttons on sheet collapse on unhide - sometimes

IMO, any time you use buttons in hidden areas you can count on
unexpected behavior. I use cells that are formatted to look/feel/behave
like buttons so their position/appearance is reliably consistent when
the visibility of the area[s] they reside is toggled.

This, of course, requires using the Selection_Change event to determine
which 'button' was clicked and run the appropriate procedure via a
Select Case construct!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 59
Default form buttons on sheet collapse on unhide - sometimes

On Wednesday, January 15, 2014 9:12:29 AM UTC-6, GS wrote:
IMO, any time you use buttons in hidden areas you can count on
unexpected behavior. I use cells that are formatted to look/feel/behave
like buttons so their position/appearance is reliably consistent when
the visibility of the area[s] they reside is toggled.



I think I'll go your route next time. What a headache. I had to control visibility, placement and naming. Hiding form controls, at least buttons, is not something you want to do in Excel 2010. Never again. Thank you

http://www.excel-ticker.com/position...in-excel-2010/


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default form buttons on sheet collapse on unhide - sometimes

On Wednesday, January 15, 2014 9:12:29 AM UTC-6, GS wrote:
IMO, any time you use buttons in hidden areas you can count on
unexpected behavior. I use cells that are formatted to
look/feel/behave like buttons so their position/appearance is
reliably consistent when the visibility of the area[s] they reside
is toggled.



I think I'll go your route next time. What a headache. I had to
control visibility, placement and naming. Hiding form controls, at
least buttons, is not something you want to do in Excel 2010. Never
again. Thank you

http://www.excel-ticker.com/position...in-excel-2010/


Wel.., this issue is not specific to v2010. It happens regularly in any
version if the controls are positioned in areas that hide/unhide
(however caused). I started using cells disguised as 'controls' when I
was working on a worksheet based wizard style form. Each pseudo-control
cell was given a local scope defined name that reflected its 'menu
caption', and their click was queried in the Selection_Change event of
the worksheet they were used on...

Select Case Target.Address
Case Range("btn1").Address: Call btn1Procedure
Case Range("btn2").Address: Call btn2Procedure
...
End Select 'Case Target.Address

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel pivot tables - specific expand/collapse buttons visibility MichaƂ Lenartowicz Excel Discussion (Misc queries) 1 October 19th 09 09:48 AM
Help Needed: Pivot Expand/Collapse Buttons Not Showing For 2 Cubes 578117 Excel Discussion (Misc queries) 0 October 2nd 09 06:05 PM
Expand Collapse Buttons Keith H[_2_] Excel Discussion (Misc queries) 0 April 17th 09 08:47 PM
Expand/Collapse Buttons for hidden rows or colums Vineet Anand Excel Discussion (Misc queries) 2 March 30th 09 01:12 PM
Collapse/Expand Buttons in a Pivot Table CindyC3 Excel Worksheet Functions 0 July 23rd 08 01:20 AM


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"