Macro should not Run when Excel Sheet is Protected

C

Chakradhar

Some of the defined Macros should not work when a Sheet is Protected and only
the specific Users should have access
 
F

Frank Kabel

Hi
you could check in the macro if the sheet is protected. e.g. directly
from the VBA help:
If Worksheets("Sheet1").ProtectContents = True Then
MsgBox "The contents of Sheet1 are protected."
End If
 
Top