| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing of a workbook is in read only mode
Hi,
I have three macros in my workbook however I only want these macros to be allowed to run if the workbook is protected by being read-only. This would mean if any of the macros run then it would check to see the status of the workbook first - could anyone advise how to acheive this? Thanks, GLT. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing of a workbook is in read only mode
Hi,
the test is: if thisworkbook.ReadOnly = true then ... OR if workbooks(sName).readonly=true HTH Philip "GLT" wrote: Hi, I have three macros in my workbook however I only want these macros to be allowed to run if the workbook is protected by being read-only. This would mean if any of the macros run then it would check to see the status of the workbook first - could anyone advise how to acheive this? Thanks, GLT. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| [Read-Only] [Compatibility Mode] | Setting up and Configuration of Excel | |||
| Read-Only Compatibility Mode | Excel Discussion (Misc queries) | |||
| Read-Only Mode | Excel Discussion (Misc queries) | |||
| No changes during Read-Only mode | Excel Programming | |||
| Read only mode | Excel Programming | |||
Linear Mode
