View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I Run Macro on Opening if user is not the "Last Saved By" U

If you have a Workbook Open Event macro, include lines like:

i = ActiveWorkbook.BuiltinDocumentProperties(3)
j = ActiveWorkbook.BuiltinDocumentProperties(7)
If i = j Then
Else
'run your first time code
End If
--
Gary''s Student - gsnu200745


"MikeZz" wrote:

Subject says it all.

Basically, I want to run a macro that applies various filters if a new user
opens the file. If it's the same user that saved the file before, I assume
they don't want the view to change.

Thanks,

MikeZz