Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thanks a lot NMiller the solution you suggested works well for me !!!
rb