Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro's
Hi, Is there anyway to stop an Auto_Close macro from running when the file is
in read-only mode? Thanks, Jane |
#2
|
|||
|
|||
Change the macro to test exit
Sub Auto_Close() If Thisworkbook.Readonly Then Exit Sub Else 'do your stuff End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "JaneC" wrote in message ... Hi, Is there anyway to stop an Auto_Close macro from running when the file is in read-only mode? Thanks, Jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting Macros | Excel Worksheet Functions | |||
Enabling macros | Excel Discussion (Misc queries) | |||
sorting with macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
The available macros list in XL; how to suppress filename from showing | Excel Discussion (Misc queries) |