Paste Value Toolbar Icon
Can you call the PasteValue Toolbar Icon in a macro to execute.
Bottom line I am trying to Paste Value and still be able to Undo if needed. Thank you, Steven |
Paste Value Toolbar Icon
Nice idea but I don't think that's going to work, the Undo I mean. But have
a go - (one of the toolbars must include the PasteValues button, customize toolbars if necessary) Dim cbt As CommandBarButton Set cbt = CommandBars.FindControl(ID:=370) ' PasteValues If cbt.Enabled Then cbt.Execute End If Regards Peter T "Steven" wrote in message ... Can you call the PasteValue Toolbar Icon in a macro to execute. Bottom line I am trying to Paste Value and still be able to Undo if needed. Thank you, Steven |
Paste Value Toolbar Icon
Hi,
As Peter mentions the undo part is tricky. See this article on the subject. http://www.jkp-ads.com/Articles/UndoWithVBA00.asp Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Steven" wrote in message ... Can you call the PasteValue Toolbar Icon in a macro to execute. Bottom line I am trying to Paste Value and still be able to Undo if needed. Thank you, Steven |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com