Hello Dear Thanks to provide us Explanation. Actually i have cheked it for ctrl c ctrl v ctrl x
i agree that anyonr cany use copy cut paste from formula bar. i have to check it out. thanks to provide me bug. Happy to Help :) Shyam On Wed, Mar 10, 2010 at 8:29 PM, Excel 009 <excelmodel...@gmail.com> wrote: > Hi Shyam and Paul, > > Thank you for your input. The main problem I brought up is not the > user will not enable the Macro; it is how to clear the "copied" items > in the Clipboard pane programmatically. > > Shyam, as I have mentioned prior, I did ran the macro and it works > well, but when the clipboard pane is opened/displayed, one can still > copy the items using the copy/cut/paste functions from the ribbon/ > toolbar and paste the items from the pane. > > Why don't you guys try to do that and you will know what I am talking > about. > > To replicate the issue: > > 1. Run the code that Shyam provide. > (You will see that you cannot copy and paste item using the hotkeys. > You may click on the copy/cut/paste icons from the ribbon/toolbar, but > you will not be able to paste the copied items.) > > 2. Open the Clipboard pane. Click on the copy/cut/paste icons from > the ribbon/toolbar. This time, you will see the copied items appear > in the pane and you can paste the items by clicking on the items. > > > Excel 009 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
