Macro's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, Is there anyway to stop an Auto_Close macro from running when the file is
in read-only mode? Thanks, Jane
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

delete macros 1
Concatenate Text... with spaces 2
Expand/collapse toolbar ribbon 6
Help with function, not sure which one 4
auto close in Excel 2007 4
Run Macro If Cell have "x" value 0
Auto_Close() not running 3
Password protected macro 3

Back
Top