+ Reply to Thread
Results 1 to 3 of 3

Prevent Editing after Date and Force Enable Macros

  1. #1
    Registered User
    Join Date
    04-07-2014
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2011
    Posts
    2

    Prevent Editing after Date and Force Enable Macros

    So I have a Workbook that I want to make read-only/protect after a certain date. I also want to force the user to have macros enabled. So far I have the following script, but despite changing it to read-only it doesn't seem to do anything. I have also tried to enable protection on the sheets after that date, but am getting errors. Can anyone help me out?

    -Eric

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Prevent Editing after Date and Force Enable Macros

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    04-07-2014
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Prevent Editing after Date and Force Enable Macros

    See attached....

    Basically START should be the only sheet visible if macros are disabled, and it should be hidden and the rest enabled if macros are enabled.

    Also after the date in the script I need to make Sheet un-editable after the date in the script.

    -Eric
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable cut, copy, paste and force enable macros
    By abhinavn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-19-2011, 02:11 PM
  2. Force Enable Macros with Password on Save
    By simmo86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2010, 11:30 AM
  3. force enable macros lag
    By FRIEL in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-07-2009, 02:13 PM
  4. [SOLVED] Force to enable macros
    By Denys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2006, 09:30 AM
  5. [SOLVED] How can force enable macros to be able to open my workbook?
    By kcdonaldson in forum Excel General
    Replies: 3
    Last Post: 12-05-2005, 02:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1