There really isn't a way to ensure a user doesn't disable macros. AND THERE SHOULDN'T BE. Consider this: Evil, destructive, phychotic individuals have embraced Excel and VBA as a method to distribute viruses. Microsoft has provided the opportunity to allow only macros from "trusted" publishers. Users that routinely receive Excel files from others should KNOW whether the file contains macros, and only enable the macros for those files that he expects to have macros. That way, if a virus infects a computer, and sends out emails to the addresses in the address book and includes an infected file and a message that says "here is the file you requested" or "here is an update to the data", the user will at least have a CHANCE of not receiving the infection.
However, if it was simply a matter of adding some code that overrides this setting, then why even bother with macro security? If you want to GUARANTEE that the user has the macros enabled and running, I would suggest that you create a sheet that says something like: "You must have macros enabled to use this file, please exit and re-open with macros enabled" then, hide all other sheets, protect the document and vba project (with a password). then, in the workbook_open macro, unprotect the document, unhide the appropriate sheets and hide the cover sheet. This will at least ensure that the end user cannot OPEN the file without macros running. However, if he knows anything about VBA, he could still find a way around it... Paul ________________________________ From: rf1234 rf1234 <rfhyd1...@gmail.com> To: excel-macros@googlegroups.com Cc: excelmodel...@gmail.com Sent: Wed, March 10, 2010 5:43:32 AM Subject: Re: $$Excel-Macros$$ How to clear clipboard effectively? 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 -- ---------------------------------------------------------------------------------- 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
