macro security

  1. S

    Force macro enabling to access the workbook

    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
  2. J

    Macro security frustrations!

    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...
  3. E

    EXCEL 2010 – Add-in, vba reference and macro security issue

    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...
  4. D

    Macros in SharePoint

    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...
  5. B

    Macros run then wont run after "save as"

    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...
  6. D

    Macro Security Settings - No Access?

    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...

Some videos you may like

This Week's Hot Topics