How to make a macro run only if not READ ONLY

[jgriffith]

I have a macro already that refreshes data sources in a workbook via an ODBC connection to my SQL server. Only a few users have access to that ODBC connection, but many other users open the workbook in read only mode.

Is there a way that i can have the macro set to run only if it is NOT READ ONLY?

Thanks,
Jeremiah

[Richard Buttrey]

Hi,

You could use the GetAttr syntax to return the read only file attribute and direct your macro accordingly.
i.e.

Please Login or Register  to view this content.

will return 1 if the file is read only.

The full attribute list is:

Please Login or Register  to view this content.

[Andy Pope]

You can check the Readonly property of the workbook and exit the macro if true.