+ Reply to Thread
Results 1 to 5 of 5

If first 6 letters of file name is "Master, no entries allowed

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    If first 6 letters of file name is "Master, no entries allowed

    If user of the form does not follow instructions (to copy form & save in another folder with another name) user entering data in master is given message “This form must be saved in job folder before entries are allowed!”
    Need macro to issue this warning if data entered into any of the 14 open cells of "Master"
    Thank you

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: If first 6 letters of file name is "Master, no entries allowed

    If Left(ThisWorkbook.Name, 6) = "Master" Then MsgBox "Save Workbook In Different Folder With Different Name First.":Exit Sub

    Re: Use an Worksheet_Change event on these cells, "any of the 14 open cells"
    Last edited by jolivanes; 09-19-2021 at 06:39 PM.

  3. #3
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Re: If first 6 letters of file name is "Master, no entries allowed

    Thank you.
    Want you to know I am out of town and will not get to it for over a week.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,516

    Re: If first 6 letters of file name is "Master, no entries allowed

    Thanks for letting us know. Very much appreciated.

  5. #5
    Forum Contributor
    Join Date
    07-02-2012
    Location
    Florida
    MS-Off Ver
    Home -Excel 2007, Work 2016
    Posts
    254

    Re: If first 6 letters of file name is "Master, no entries allowed

    I am sure my lack of knowledge is the reason I could not get what you sent to work.
    Questions -
    is there something that should precede your "If Left ..." like I use when for a message when a file is opened - like Private Sub Workbook_Open() ??
    Or does the fact that i did not put your "Re: Use an Worksheet_Change event on these cells, "any of the 14 open cells" " in with your If statement ?
    THANK YOU!!!!!!!!!!

+ 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. Open the last saved file paste in master file"
    By Mohan Chalageri in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-03-2020, 02:39 AM
  2. VBA Code to fetch files in a folder and merge into a "Master file" - Please assist!
    By ClarkKyle in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 05-24-2017, 04:14 AM
  3. [SOLVED] Copy contents from "Child" file to a "Master"
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 02-13-2014, 09:44 AM
  4. [SOLVED] Move Non-Zero row entries up to occupy Zero row entries. Rows deletion not allowed
    By chancw in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-08-2013, 03:57 AM
  5. Opening 4 excel files, copying set table data and pasting into "master file".
    By Belloni in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-29-2012, 09:50 AM
  6. Replies: 3
    Last Post: 11-05-2010, 03:06 PM
  7. stop users from saving their file over "master" if same name
    By ruddojo in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-01-2006, 12:50 AM

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