Jump to content
Sign in to follow this  

Excel - know when book is in readonly mode

Recommended Posts


Sorry wrong Forum :P

I need to update a shared Spreadsheet. Unfortunately other's may have it opened already. Using Excelcom.au3 I open, update and get out. But sometimes when i open it it is in a readonly mode, if it is i need to do something else. Is there a easy way to find out at or shortly after opening a spreadsheat with excom.au3 if one has Read/Write access.?

Edited by hazed

Share this post

Link to post
Share on other sites

Hallo hazel

I thing that your looking for the DesignMode property (Spreadsheet)

Property type

A Boolean value.


object.DesignMode [= value]

value A Boolean value. - the proprty is a both setting and return command...

kjactive :P

Share this post

Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.