You could hide all sheets and set password protection. then, in the VBA macros, unprotect the sheets. Set Password protection on your VBA code.
then, the ONLY Way for the user to see the sheets is for the macros to be turned on. You could create a cover sheet that tells the user to turn on macros, perhaps gives instructions on how to do so. In the startup macro (Workbook_Open or Auto_Open), you would select the appropriate sheet and the user doesn't have to see the cover. BTW... the macros being set to 'disabled' isn't necessarily a Microsoft issue. It's YOUR COMPANY's DECISION (or system Administrator's decision) to deploy it with these settings. however, now that it's deployed, the decision is done and not easily fixed automatically! hope this helps. paul ________________________________ From: Hemant Kalia <hmt....@gmail.com> To: excel-macros@googlegroups.com Sent: Thursday, August 27, 2009 7:13:21 AM Subject: $$Excel-Macros$$ Macros problem in office 2007 Hi Friends i recently started using Office 2007 and it seems that this version of office is simply not pro Macros I use a excel file that has a macro in it. The file had multiple sheets and each sheet is relevant to a specific person. the macro links the computer user name ( the one with which you log in ) and checks for authorisation set in the macro. So if i have mentioned Mr A in the Macro then when he receives the file in mail and opens it he can only see sheet A ( he cannot copy the data , or modify it or add new sheets to the file etc. if Mr Z open the file he sees only sheet z the rest of the data remains hidden and cannot be opened unless you open the file on a computer logges in with a specific user name. Now the problem is that in office 2007 the default settings are of Macro being disabled. So if the file is sent to a person with office 2007 , then he has access to all the data. I have tried most options, ( added digital certificate to the file etc) . Its not possible for me to call all associates and ask them to turn on their macro in office 2007. I would like to know if anyone has any ideas on this - essentially i want to send multiple sheets but or file but i want to set user authorisations in it. pls refer to screenshots. If anyone has any solution , pls help me. i tried going to properties of the file and tried modifying the security permissions - but the security works only on the creators computer - on sending by mail it fails. i have already checked the Information Rights management available for Microsoft exchange. pls see links below - if anyone has used it pls guide me. http://office.microsoft.com/en-us/help/HA101029181033.aspx?pid=CL100605171033 http://office.microsoft.com/en-us/outlook/HA011801361033.aspx -- Regards Hemant Kalia --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 5,200 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 -~----------~----~----~----~------~----~------~--~---