+ Reply to Thread
Results 1 to 5 of 5

Need help with my force enable macros code being autosaved

  1. #1
    Registered User
    Join Date
    01-30-2015
    Location
    Albany, NY
    MS-Off Ver
    Whatever the client has
    Posts
    8

    Need help with my force enable macros code being autosaved

    Okay so I am no way a macros person and have barely used until the other day. A client has a shared workbook that needs to be password protected, but have a read only option. I then made the save buttons password protected so they couldn't save it as a copy. This macro I found online doesnt show them other sheets until they enable macros. My problem is it wants to auto save and asks for a password but not everyone will have the password. I see the macro has this situation covered but it's not working for me. Help would be greatly appreciated!!!
    Please Login or Register  to view this content.
    Last edited by FDibbins; 02-03-2015 at 04:14 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,110

    Re: Need help with my force enable macros code being autosaved

    Hi, welcome to the forum

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I will add them for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-30-2015
    Location
    Albany, NY
    MS-Off Ver
    Whatever the client has
    Posts
    8

    Re: Need help with my force enable macros code being autosaved

    Thank you for that information, I will be sure to do that next time!! Any help people!?!?! I was also thinking about potentially making it available for a "don't save" button on the sheet when it asks for a password at exit

  4. #4
    Registered User
    Join Date
    01-30-2015
    Location
    Albany, NY
    MS-Off Ver
    Whatever the client has
    Posts
    8

    Re: Need help with my force enable macros code being autosaved

    This is what I have now, I got rid of the password at the bottom but i am having a lot of trouble with the saving feature. I can't have read only users saving this doc at all, whether overwriting it or saving as a copy

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-30-2015
    Location
    Albany, NY
    MS-Off Ver
    Whatever the client has
    Posts
    8

    Re: Need help with my force enable macros code being autosaved

    Help from anyone?

+ 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. Prevent Editing after Date and Force Enable Macros
    By efaden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2014, 03: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