Macros

[imported_unknown]

How can I run a macro on a protected worksheet?

 

[Colo]

Hi dougm,

I cannot see where your problem is.
Assumed you would like to input text or value into cells in protected worksheet.
Before run your macro, why don't you unprotect your sheet via macro?

 

[gareth]

It should not be a problem to run the macro in a protected workbook.
Or try this code.

=-=-=-=-=-=-=-=-=-=
Sub unlock_workbook()
'|=-=-==-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=|
'| Code by Gareth Lombard 26/09/2002 |
'|=--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-|
Dim i As Integer
Dim j As Integer
Dim k As Integer
Dim l As Integer
Dim m As Integer
Dim n As Integer
On Error Resume Next
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
For l = 65 To 66
For m = 65 To 66
For i1 = 65 To 66
For i2 = 65 To 66
For i3 = 65 To 66
For i4 = 65 To 66
For i5 = 65 To 66
For i6 = 65 To 66
For n = 32 To 126
ActiveWorkbook.Unprotect Chr(i) & Chr(j) & Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr
If ActiveWorkbook.ProtectStructure = False And ActiveWorkbook.ProtectWindows = False Then
Exit Sub
End If
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
End Sub
=-=-=-=-=-=-=-=-=-=-=-=-=-

Copy this code in your personal workbook buddy.

 

[imported_unknown]

Fantastic! Thanks Gareth.