Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Properties
I have button the refreshes pivots in template. However, when I hit the
button or open the template that's been used, the font size increases or decreases. How do fix it so that it doesn't change? What do these properties represent (those with ?)? ? Accelerator = ? AutoLoad = False AutoSize = False BackColor = &H800000012& BackStyle = 1 - fmBackStyleOpaque Caption = Refresh! Enabled = True Font = Arial ForeColor = &H80000012& ? Height = 34.5 (Button height or Font?) ? Left = 259.5 Locked = True MouseIcon = (none) MousePointer = 0 - fmMousePointerDefault Picture = (none) PicturePosition = 7-fmPicturePositionAboveCenter ? Placement = 2 PrintObject = True Shadow = False ? TakeFocusOnClick = True ? Top = 0.75 Visible = True ? Width = 84 WordWrap = False |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Properties
When you're in the properties dialog box you can move to any property field
and press F1 to get help about the selected property. You'll get a fuller description and you won't have to wait for someone to reply to all those questions. Hope this helps... -- Kevin Backmann "FredL" wrote: I have button the refreshes pivots in template. However, when I hit the button or open the template that's been used, the font size increases or decreases. How do fix it so that it doesn't change? What do these properties represent (those with ?)? ? Accelerator = ? AutoLoad = False AutoSize = False BackColor = &H800000012& BackStyle = 1 - fmBackStyleOpaque Caption = Refresh! Enabled = True Font = Arial ForeColor = &H80000012& ? Height = 34.5 (Button height or Font?) ? Left = 259.5 Locked = True MouseIcon = (none) MousePointer = 0 - fmMousePointerDefault Picture = (none) PicturePosition = 7-fmPicturePositionAboveCenter ? Placement = 2 PrintObject = True Shadow = False ? TakeFocusOnClick = True ? Top = 0.75 Visible = True ? Width = 84 WordWrap = False |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Command Button Properties
Hi Kevin,
Thanks. The F1 help on some, but not others. Some only shows the same Object Model Overview which didn't help at all. like AutoLoad, , The others I figure is the button location and size. "Kevin B" wrote: When you're in the properties dialog box you can move to any property field and press F1 to get help about the selected property. You'll get a fuller description and you won't have to wait for someone to reply to all those questions. Hope this helps... -- Kevin Backmann "FredL" wrote: I have button the refreshes pivots in template. However, when I hit the button or open the template that's been used, the font size increases or decreases. How do fix it so that it doesn't change? What do these properties represent (those with ?)? ? Accelerator = ? AutoLoad = False AutoSize = False BackColor = &H800000012& BackStyle = 1 - fmBackStyleOpaque Caption = Refresh! Enabled = True Font = Arial ForeColor = &H80000012& ? Height = 34.5 (Button height or Font?) ? Left = 259.5 Locked = True MouseIcon = (none) MousePointer = 0 - fmMousePointerDefault Picture = (none) PicturePosition = 7-fmPicturePositionAboveCenter ? Placement = 2 PrintObject = True Shadow = False ? TakeFocusOnClick = True ? Top = 0.75 Visible = True ? Width = 84 WordWrap = False |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Button properties blank: protection problem? | Excel Discussion (Misc queries) | |||
button properties | Excel Discussion (Misc queries) | |||
Command Button Control Properties | Excel Discussion (Misc queries) | |||
command button properties | Excel Worksheet Functions | |||
Spinner Button properties | Excel Discussion (Misc queries) |