automating Excel 2002 Task Pane
 

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??

automating Excel 2002 Task Pane
 

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 *


"Dennis Sacca" wrote in message
...
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??

automating Excel 2002 Task Pane
 

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?????


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!