Can we code this?

  • Thread starter Thread starter Phil Hageman
  • Start date Start date
P

Phil Hageman

Chip, Thanks - it works! Can I ask you this - I have an
Auto_Open Sub (below). Can this be modified to
automatically switch the user's security to Medium when
they open this workbook, then reset it to high on close?

Sub Auto_Open()
Application.ScreenUpdating = False

For Each ws In Worksheets
If ws.Visible = xlSheetVisible Then
ws.Select
Application.GoTo ws.Range("A1"), True
ActiveWindow.DisplayGridlines = False
End If
Next

Worksheets("Scorecard").Select
Application.AutoPercentEntry = True
Application.ScreenUpdating = True

End Sub

Thanks, Phil
 
Phil,

Chip has answered the question, but just think about it, what sort of
security would it be if you could do that?
 
Imagine the thousands of virus writers out there just sitting quietly, watching this thread and
praying that Chip can give you some magic to really do that. <vbg>
 
You are right - I'm getting out of line here. I will
educate the user. Thanks for setting me straight.
 
Hi Phil,
Not sure what your trying to accomplish, but you might want to look into
user profiles to control who can run macros.
 
This is the answer! Thanks Myrna.
-----Original Message-----
Perhaps you should investigate Digital Signatures. If you
sign your workbooks, the user can set
his security to medium, then open your workbook. They
will told that the code has been signed by
you and given (1) the option to run macros or not, and
(2) to "always trust macros from this
source".

Once they answer the latter affirmatively, they can set
their security back to High and still
open your workbooks.
 
Back
Top