Create a macro to show the collaboration pane

[#1]

Hi everybody,

I'm trying to create a button with a macro that opens the collaboration pane

I took a look into the api guide and found only those possibilities:

ShowBookmarksBar
ShowDesignBar
ShowMenuBar
ShowNavigationBar
ShowSheetsBar
ShowStandardBar
ShowStatusBar

Does anyone has any good idea about it ?

Thanks in advance

russianblue

[#2 · Accepted solution]

I didn't find anything in the API, but you could use keyboard shortcuts. The keyboard shortcut for the Collaboration Pane is F2.

You can create a macro to show it using:

Sub Collabo
 set objShell = CreateObject("WScript.Shell")
 objShell.SendKeys "{F2}"
End Sub

You must have Allow System Access in the Current Local Security drop-down.

[#3]

Thanks a lot NMiller the solution you suggested works well for me !!!

rb