Results 1 to 9 of 9

remove all save options from just one workbook

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    365
    Posts
    152

    remove all save options from just one workbook

    I have a save button running a macro that validates before saving. Is there a way to remove all other save options (alt f a, ctrl s, the toolbar save button, etc.) but just from this one workbook?

    A while ago I tried playing with a code that did this but it did it through out excel. not cool

    I assume that I need a case statement that says something like
    case.sheet="filename"
           remove save options
    case else
    end
    I really don't know vb just playing with a couple of reports for our local volunteer fire department trying to simplify things.

    Thanks for your help
    Last edited by 2funny4words; 04-23-2009 at 09:12 AM.

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