I ran a macro against a number of Excel workbooks to correct and error that I had found with some forms we use for recording time.
The problem is that I put the incorrect syntax into the macro, strangely it still ran ?
Syntax I should have used - ActiveSheet.Protect Password:="password"
Here is the syntax that I actually used - ActiveSheet.Protect Password = "password"
Spot the difference, any ideas what password will have been applied to my sheet ?
Any help appreciated.
The problem is that I put the incorrect syntax into the macro, strangely it still ran ?
Syntax I should have used - ActiveSheet.Protect Password:="password"
Here is the syntax that I actually used - ActiveSheet.Protect Password = "password"
Spot the difference, any ideas what password will have been applied to my sheet ?
Any help appreciated.