+ Reply to Thread
Results 1 to 4 of 4

Change On-Click Error Message

  1. #1
    Forum Contributor
    Join Date
    02-24-2008
    Location
    UK
    MS-Off Ver
    2012 and 2016
    Posts
    123

    Change On-Click Error Message

    I have set up a workbook with a number of sheets that requires entries to be made via command buttons on a specific sheet. I do not want the user to be able to change data in the sheets without using the command buttons. I have therefore protected the relevant sheets (locked). When the user tries to input data in a locked cell the usual "this cell is protected......." message appears as one would expect. However, I want to display a more useful message that directs the user to the sheet with the command buttons. Can anyone help me with the VBA code to do this?

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,012

    Re: Change On-Click Error Message

    Apparently not as per these resources (that include a workaround) :

    http://www.xtremevbtalk.com/excel/22...d-message.html

    http://www.2013.net/blog/index.php?/...n_excel_sheet/

  3. #3
    Registered User
    Join Date
    08-09-2015
    Location
    CzR
    MS-Off Ver
    MS Office 2013
    Posts
    41

    Re: Change On-Click Error Message

    I should place the warning on the top of each sheet, with text "To edit this sheet, go on the sheet '... name ...'" Users are not stupid (at least some of them) and they learn soon what to do.

    (As far as I know myself, I'd extend the warning text into

    To edit this sheet, go on the sheet '... name ...'
    Here you can edit directly the light-blue cells only.

    with no light-blue cells in the sheet, of course )

  4. #4
    Forum Contributor
    Join Date
    02-24-2008
    Location
    UK
    MS-Off Ver
    2012 and 2016
    Posts
    123

    Re: Change On-Click Error Message

    Thanks for the responses - I will give it a try tomorrow and let you know the outcome.

+ 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. Need help to change ComboBox error message
    By nohero in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-18-2016, 06:39 PM
  2. Replies: 1
    Last Post: 05-08-2014, 12:36 PM
  3. Replies: 1
    Last Post: 10-29-2013, 08:06 PM
  4. Change Default Error Message VBA
    By johnph in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2012, 11:41 AM
  5. Error message is To Continue saving as a micro – free workbook, Click Yes”.
    By amarendra19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-01-2011, 08:40 AM
  6. Error message is To Continue saving as a micro – free workbook, Click Yes”.
    By amarendra19 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2011, 08:34 AM
  7. [SOLVED] How to change and error message to text
    By NEWB in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2005, 05:25 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