+ Reply to Thread
Results 1 to 5 of 5

VBA to disable save and save as based on condition

  1. #1
    Registered User
    Join Date
    09-29-2005
    Posts
    74

    VBA to disable save and save as based on condition

    In the attached file, if Column C (Custody Account Number) has a value in it than Column E (Asset Manager Account Number) must also have a value. If this condition is NOT meant than the file cannot be "Saved" or "Save As".
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: VBA to disable save and save as based on condition

    hi,

    try this

    Please Login or Register  to view this content.
    Please be as complete as possible in your asking so it may save use all the time to rework the solution because you didn't give all the requirements. If you have a layout in mind please work it out first so we can adapt our solution to it. Thanks.
    If you have been helped, maybe you could click the *

  3. #3
    Registered User
    Join Date
    09-29-2005
    Posts
    74

    Re: VBA to disable save and save as based on condition

    Nice work! Can you also add on if there is a data in Column E, than there also must be data in Column C?
    And also if the C and E are blank allow it to save/saveas.
    Last edited by Scorpvin; 02-19-2021 at 05:18 PM.

  4. #4
    Valued Forum Contributor
    Join Date
    09-30-2018
    Location
    Vlaams Brabant Belgium
    MS-Off Ver
    365
    Posts
    456

    Re: VBA to disable save and save as based on condition

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-29-2005
    Posts
    74

    Re: VBA to disable save and save as based on condition

    Thank you so much!

+ 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. disable save/save as if condition is not met
    By thoandros in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-20-2021, 10:28 AM
  2. [SOLVED] Disable SAVE, SAVE AS & CTRL+S once Macro is executed
    By RIZVI in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2019, 08:24 AM
  3. Replies: 1
    Last Post: 04-29-2016, 11:55 AM
  4. If condition met disable save and send
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2015, 10:18 AM
  5. Disable Save As and Save - enable Save via button
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-07-2011, 05:42 PM
  6. Disable/Enable Save,SaveAs & Sendto in File Menu based on condition
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2011, 04:43 AM
  7. disable save and saveas but have submit button to save file as work
    By briant97 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-04-2010, 12:32 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