I am using Excel 2007 and have built a workbook that uses a lot of VBA in the background. My problem centers around forcing the user to enable macros.
Our security folks have set up rules on the use of macros which only allows the user to enable the macros. I researched the use a digital signature to get around this issue, but the security rules apparently nullify the signature. Every time the workbook is changed the signature is lost. Then, I turned to having a warning worksheet being the only worksheet visible and the Workbook_Open process hide it and make the rest visible and then reverse this at the close. This worked great until I had to turn on sharing / tracking. For some reason, when the workbook is opened, with sharing turned on, it blows through the warning worksheet. It briefly displays it (see it in a flicker), hides it, and then makes the rest of the worksheets visible. Has anyone else run into this situation? If so, how did you get around it. Thanks in advance. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
