| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Bypass macros in Read only
Is there some code that will bypass/disable certain macros if the file is opened with read only status
Thanks in anticipation, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Bypass macros in Read only
I don't think so, but you could put this in the beginning of the macros in
question: If ThisWorkbook.ReadOnly Then Exit Sub -- HTH. Best wishes Harald Followup to newsgroup only please "Lawlera" skrev i melding ... Is there some code that will bypass/disable certain macros if the file is opened with read only status? Thanks in anticipation, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Bypass macros in Read only
Thanks Harald - works a treat!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bypass Auto-Open Procedure | Excel Discussion (Misc queries) | |||
| Bypass a function in a Macro | Excel Discussion (Misc queries) | |||
| any way to bypass Excel Limit of 255 rows? | Charts and Charting in Excel | |||
| Oblect not found in macro - bypass | Excel Programming | |||
| In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well? | Excel Programming | |||
Linear Mode
