Results 1 to 2 of 2

Thread: Excel 2010 hide Read Only messages

  1. #1
    Junior Member
    Join Date
    Aug 2013
    Posts
    1
    Rep Power
    0

    Excel 2010 hide Read Only messages

    I have an application in Excel2010 which uses VBA to access an SQL database. This application is for multiple users so I don't want the "Read Only" message to appear when a user opens the file because the data the user enters will be sent to the database regardless. So how do I hide the read only message using VBA so users are not confused?
    Thank you
    Derek H.

  2. #2
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Save the file as Excel macro-Enable Template (.xltm)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Excel 2003 Classic Menu in Excel 2007-2010
    By Excel Fox in forum Classic Menu
    Replies: 7
    Last Post: 09-10-2014, 10:29 PM
  2. How To Protect Hide Formula In Excel
    By paul_pearson in forum Excel Help
    Replies: 1
    Last Post: 04-10-2013, 08:33 AM
  3. Data Sortin_ MS Excel 2010
    By blake85 in forum Excel Help
    Replies: 2
    Last Post: 03-01-2013, 11:37 AM
  4. Replies: 1
    Last Post: 02-14-2013, 11:08 AM
  5. Email merge unique messages to groups and individuals
    By RagingWahoo in forum Excel Help
    Replies: 3
    Last Post: 10-14-2012, 11:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •