+ Reply to Thread
Results 1 to 2 of 2

hide info tab / vba to turn off the edit anyway prompt when the file is mark as final

  1. #1
    Registered User
    Join Date
    02-12-2015
    Location
    hong kong
    MS-Off Ver
    2010
    Posts
    2

    hide info tab / vba to turn off the edit anyway prompt when the file is mark as final

    hi, when a file is marked as final, then user view it as read-only without editing ability in 2007. however, in 2010, users are alerted that they can change it by clicking the edit anyway button.
    1. how do i disable the edit anyway prompt? or
    2. how do i hide the info tab in the file backstage view so that users are not easy to turn it back to edit mode? or

    3. actually, mark as final is pretty good but someone wanted that no editing is possible for users. is there a way to save a file to read-only without edit ability to users anyway? protect sheets by sheets with a password work but there're over 10 files, each with over 10 sheets to work on. It's not efficient.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: hide info tab / vba to turn off the edit anyway prompt when the file is mark as final

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    http://www.excelforum.com/excel-prog...-as-final.html

+ 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. hide info tab / vba to turn off the edit anyway prompt when the file is mark as final
    By JPMAM_j911091 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-12-2015, 04:38 AM
  2. How can I mark as final for Excel 2003?
    By ha suong in forum Excel General
    Replies: 3
    Last Post: 08-20-2013, 10:29 PM
  3. turn of save prompt
    By Phooey in forum Excel General
    Replies: 1
    Last Post: 02-09-2013, 02:32 PM
  4. Replies: 5
    Last Post: 07-06-2012, 08:25 AM
  5. edit macro that is pasting info to check column for duplicate info
    By roth_nj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2009, 05:55 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