acfalcon2001

I have added a user control into an Excel Actions Pane. When opened up the entire user control cannot be seen unless the user manually widens the actions pane. I know I can't programmatically change the width of the Actions Pane. Is there anyway to move the actions pane programmatically to the bottom of the spreadsheet so it is wider (I tried docking it and anchoring it and neither worked) If not that is there a way so that if the entire control is not visible that the actions pane will show a horizontal scrollbar (I tried setting AutoScroll to true and that didn't work) Any ideas

Thanks, Adam



Re: Visual Studio Tools for Office Actions Pane

Douglas H. Troy

You should be able to change the orientation of the action panes. See the following article regarding this: How To: Manage Control Layout







Re: Visual Studio Tools for Office Actions Pane

Misha Shneerson - MSFT

Or to be even more specific

from Actions Pane Overview.

Resizing the Actions Pane

You cannot directly change the size of an ActionsPane because the ActionsPane is embedded in the task pane. However, you can programmatically change the width of the task pane by setting the Width property of the CommandBar that represents the task pane. You can change the height of the task pane if it is docked horizontally or is floating. Programmatically resizing the task pane is generally not recommended because the user should be able to select the task pane size that best suits his or her needs. However, if you must resize the width of the task pane, you could use the following code to achieve this task.

Visual Basic
Me.CommandBars("Task Pane").Width = 200
Repositioning the Actions Pane

You cannot directly reposition the ActionsPane because it is embedded in the task pane. However, you can programmatically move the task pane by setting the Position property of the CommandBar that represents the task pane. Programmatically repositioning the task pane is generally not recommended because the user should be able to choose the task pane position on the screen that best suits his or her needs. However, if you must move the task pane to a particular position, you could use the following code to achieve this task.

Visual Basic
Me.CommandBars("Task Pane").Position = _
  Microsoft.Office.Core.MsoBarPosition.msoBarLeft