macro security

Hi ! I'm looking for a solution to block a 20.worksheets.workbook acces if the user dont activate is macro first. And after activation then he will see and have acces to the full workbook.. ? Any solutions ? Thank you very much and have a great day! Steve

Hi, I am incredibly new to programming in general, and especially to VBA. I'm having fun learning except for one really frustrating thing which I cannot seem to find a solution to anywhere. I started a project yesterday, ran the macros happily with no issues, but today, (as has happened before...

Hi<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a spreadsheet that uses a number of public functions from an add-in in cell formulas. These same public functions are also called in the macros of the spreadsheet and so the add-in is...

Hi All, I have an excel 2003 document containing several macros on a SharePoint site. However, a user who recently switched over to excel 2007 reported that these Macros no longer work. This user doesn't get any error message and the VBA code for the Macros are still in the worksheet. Also, he...

Today my 5 meg 2003 workbook decided to disable macros. I was working at a computer on our server that I have used many times. When I did a "save as" the the macros in the newly named file would not work due to security level. In order to get the Macros to work, I had to close Excel and reopen...

Someone using a template of mine has told me his colleague is unable to use them because they don't have access to change the Macros Security from High/Very High to Medium... they just can't find this option at all. I'm not yet sure what Excel version and don't have access to their computers...