Macro button is not working in a Protected page..

[akinkaraman]

Macro button is not working in a Protected page.. Is there any solution to able the button in a Protected page?

 

[Hui]

In your code you have to Unprotect the worksheet
the reprotect it again when finished

You need something like this at the start:

SheetName.Unprotect Password:=yourPassword

And this at the end:

SheetName.Protect Password:=yourPassword

 

[akinkaraman]

I am doing something wrong but I couldn't get it. It is crashing my Excel.

Could you please check my file?

The password of protected cells is 1234

 

[Hui]

Change the sub as shown below:

Sub Start_Clock()
With Sheets("Clock")
  .Unprotect Password:="1234"
  .Range("C3").Value2 = Now
  .Protect Password:="1234"
End With

dtime = Now + TimeSerial(0, 0, 1)
Application.OnTime dtime, "Start_Clock"
End Sub

or see attached

 

[akinkaraman]

It is working but it slows the computer very much now.

 

[Hui]

because you have asked it to update every 1 second

So every second it has to unprotect the worksheet
Update the time
Protect the worksheet
do other stuff

I'd try 2, 5 or 10 seconds