| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically determining if workbook is opened as Read Only
I have a data extraction macro that I run monthly and it takes a while to
run, so I periodically open it in another Excel instance as Read Only during the extraction to get an indication on how much is left to extract. Unfortunately, I also have a workbook open event that asks if I want to run the macro, which fires whether it's read only or not. I don't want this message displayed if the workbook is opened as read only. Is there some way to do that? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide Custom Command Bar if Workbook opened Read-Only | Excel Programming | |||
| Programmatically determining if worksheet is protected | Excel Programming | |||
| stop excel file opened as read only if already opened by another u | Excel Programming | |||
| Determining if workbook is already opened by someone else? | Excel Programming | |||
| How to read sheet of currently opened workbook | Excel Programming | |||
Threaded Mode
