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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top