Why not just have the protection turned off while the macro runs and the last line of code turns it back on
'Something like that...![]()
Sub pwd ActiveSheet.UnProtect Password:="Password" "your code" ActiveSheet.Protect Password:="Password" end sub
Why not just have the protection turned off while the macro runs and the last line of code turns it back on
'Something like that...![]()
Sub pwd ActiveSheet.UnProtect Password:="Password" "your code" ActiveSheet.Protect Password:="Password" end sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks