ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Activate/deactivate Office Clipboard in VBA (https://www.excelbanter.com/excel-programming/347438-activate-deactivate-office-clipboard-vba.html)

Peter Rooney

Activate/deactivate Office Clipboard in VBA
 
Good afternoon, all!

Can anyone tell me the correct syntax to use to do this? I was using

Application.CommandBars("Task Pane").Visible = True

which I obtained by recording, but when I include the command in my
Workbook_Open macro, I get an error.

Thanks in advance

Pete



All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com