Jump to content

Excel - know when book is in readonly mode


hazed
 Share

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
Link to comment
Share on other sites

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

Link to comment
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
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...