Macro to select all sheets
Macro starts
ActiveSheet.Unprotect Password:="justme"
Macro does its stuff
ActiveSheet Protect Password:="justme"
End Sub
On Wed, 26 Mar 2008 23:08:01 -0700, belvy123
wrote:
Hi Again
I am having one issue that i did not mention before
I have protection on all sheets to keep people from deleting formulas.
what do i need to add to this code to unprotect the sheets as the code trys
to clear the cells
Thanks
|