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
|