+ Reply to Thread
Results 1 to 2 of 2

Macro to ensure Read-Only users don't save the workbook

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

    Macro to ensure Read-Only users don't save the workbook

    So I have made my workbook so if you do not have a password you open it in the "read-only" view. My problem is the read-only users can save as a copy and blow up our shared folder with copies. My original plan was to have a password protecting the save and save as button but I recently had problems with it.

    Please Login or Register  to view this content.
    My question is either can someone figure out why the first line of this code is sending an error, or secondly help me figure out a macro that would disable the save and save as button and the closing save for any "read-only" user. Thanks

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

    Re: Macro to ensure Read-Only users don't save the workbook

    This would be my overall macro

    Please Login or Register  to view this content.

+ 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. [SOLVED] Ensure DTPicker works for all users
    By Dragman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2013, 05:56 PM
  2. Make Workbook Read Only and not allowed to Save and Save As
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-30-2012, 10:37 AM
  3. Save a workbook in read only
    By Macdave_19 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-23-2009, 06:42 AM
  4. [SOLVED] Some users sharing a workbook getting read only message
    By owl37 in forum Excel General
    Replies: 1
    Last Post: 08-04-2006, 11:20 AM
  5. want to 'share' a workbook but Says Read only'when others try save
    By Danielle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2005, 08:05 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