Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Task within Excel To Send Emails | Excel Discussion (Misc queries) | |||
Task Pane in Excel | Excel Discussion (Misc queries) | |||
Excel - task pane | Excel Discussion (Misc queries) | |||
Excel Task Pane | Excel Discussion (Misc queries) | |||
how do i get my task pane up in excel | New Users to Excel |