MrAbattoir Posted February 28, 2013 Share Posted February 28, 2013 Hi, i need to find a way to open an excel document but warn the user if it has opened as read only. Currently a user clicks on a button in a GUI to open an excel document, this works fine but... If someone else opens the document whilst another user still has it open, it opens as a read only version (no warnings apart from the window title) A lot of people do not read the read only part of the window title and continue to make changes to the sheet. This annoys them Link to comment Share on other sites More sharing options...
water Posted February 28, 2013 Share Posted February 28, 2013 Do you use the Excel UDF to open the workbook? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now