Hello Dear Suppose we have write a macro for book1 using excel 2003, when we send it to another user who have excel 2007 or if he Disable or not allowing the macro using
Tools->Macro->Security then the problem occurs,best way is forcely run macro at startup or openning mode of workbook. Hope It Will Work Happy To Help :) Shyam On Wed, Mar 10, 2010 at 3:59 AM, Excel 009 <excelmodel...@gmail.com> wrote: > Hi Shyam, > > Thank you for your help. I used similar code to disable the copy/cut/ > paste on the key combination and on the toolbar and right click. It > works well. However, when one has the clipboard pane opened, one can > still copy and paste using the command in the pane. When I used 2003, > I can pretty much disable all the copy/cut/paste functionality. > However, one can always open the 2003 file in Excel 2007, open the > clipboard pane, copy or cut using the command on the ribbon, and paste > the copied object by clicking on the object inside the pane. As it is > not easy to modify the ribbon (through changing in XLM), I did not > look into that option. > > The easiest way to avoid user from copy the current content to other > workbooks, if possible, is to empty the clipboard as it will ease all > the possible ways (ex: insert the copy/paste command from toolbar > option into the workbook) that people use the copy/paste functions. > So again, we are back to our starting point - how to empty the > clipboard programmatically. > > Kavita showed a method to do this, but it does not work as it cannot > stop the copied object to appear on the clipboard. > > For AJ, this method applies the effect at the Excel "application > level" and not on Excel "workbook level". How can we set it up so > that the users will have this option setting on their end without > asking them to do this on their own? Also, how can we stop them from > turn the functionality back on? > > > 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
