Good day friends :)
I have an excel workbook with one of its hidden (XlVeryHidden) sheets contains a link to my web site and gets updated every time the workbook is opened and once in 15 minutes. When I will publish some encrypted information on my website (It can be a message to all the user or to a specific user or it can be a *VBA code to run*) the data will be decrypted by the workbook and used by the workbook. Now the problem is that as it is important for me to keep the project locked, I am not able to import the code from the worksheet to the code module. Please help me out soleve this problem and consider if the following are possible 1) Import the code to the module while the project remains locked 2) Unlock and lock the project programmatically 3) Insert two projects in a workbook one of which I can leave unprotected 4) Insert a macro sheet (?!) I am thanking you in advance and It will be of great help! If I will be able to do this, I can make automatic updates to my workbooks and send pop up messages etc. when I would have distributed the workbook to many people. :) Hemant Hegde --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
