spalomino
03-03-2010, 02:41 PM
I have created a protected shared workbook but cannot perform sort macro. Each sheet is protected in the workbook. When taking it out of shared sorting is fine using the code below:
ActiveSheet.Unprotect Password:="password"
ActiveSheet.protect Password:="password"
Is there something similar I can use for a protected shared workbook?
Thanks
ActiveSheet.Unprotect Password:="password"
ActiveSheet.protect Password:="password"
Is there something similar I can use for a protected shared workbook?
Thanks