Jump to content
Sign in to follow this  
hazed

Excel - know when book is in readonly mode

Recommended Posts

hazed

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
kjactive

Hallo hazel

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

Property type

A Boolean value.

Syntax

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  

×