automating Excel 2002 Task Pane

  • Thread starter Thread starter Dennis Sacca
  • Start date Start date
D

Dennis Sacca

Does anyone know if you can programatically disable the
Excel 2002 Task Pane permanently. I can turn off the Task
Pane programatically, but it re-appears for cut/copy/paste
functions. The user interface of the clipboard on the
task pask has options which can control this, but I need
to control it programatically. Any ideas?????

P.S. Application.DisplayClipboardWindow does not appear to
work. Has anyone else tried it with success??
 
Hi Dennis,

CommandBars("Task Pane").Enabled = False

should do it for the current Excel session. But if you want this to be the
default state every time you open Excel, you'll need to put it into
something like a Personal.xls Auto_Open procedure.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
Thanks for the reply, but your sugesstion did not work. If you
cut/copy/paste, then the clipboard in the task pane re-appears. Any
other ideas?????
 
Back
Top