+ Reply to Thread
Results 1 to 6 of 6

Macro to remove the option to save as if file was open as read only?

  1. #1
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Macro to remove the option to save as if file was open as read only?

    Macro to remove the option to save as if file was open as read only?

    Running Excel 2003 with Windows 7

    I have a workbook that I have set up with security to recommend open as read-only and if not there is a password that has to be entered so changes can be made to it. But when I open it as read-only and try to close out it give me an option to save-as. Is there a way to remove this option so when everyone is closing out it just closes it with out giving anyone any options to save or save-as when it is opened as read-only?

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,212

    Re: Macro to remove the option to save as if file was open as read only?

    Hi,

    You can fool Excel into thinking the workbook has been saved and doesn't need to be saved with a line of code like:
    Please Login or Register  to view this content.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-27-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    43

    Re: Macro to remove the option to save as if file was open as read only?

    Hi,

    This should do it:

    http://www.excelforum.com/excel-prog...read-only.html

    Cheers,
    Dom

  4. #4
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Macro to remove the option to save as if file was open as read only?

    I didn't get it to work but I got this to work but I'm still getting the pop up box asking if I want to save before I close when its open as read only.
    Please Login or Register  to view this content.
    Last edited by extremecorvette; 06-02-2011 at 01:26 PM.

  5. #5
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Macro to remove the option to save as if file was open as read only?

    I found my way around this by just locking the excel sheet and making people put a password in to be able to edit it. This way I'm the only one that can edit it.

  6. #6
    Registered User
    Join Date
    02-14-2011
    Location
    Muscatine, Iowa
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Macro to remove the option to save as if file was open as read only?

    It would be nice to have a macro that sees its open as read only and after x amount of time it closes the file with out saving.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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