I have some code to protect a sheet which prevents the user from un-hiding columns:
wsh.protect password:="xxx", AllowFormattingCells:=True, userinterfaceonly:=True
however i have also used in other sheets
wsh.Protect Password:="xxx", AllowFormattingCells:=True, userinterfaceonly:=True...
I created a macro that opened & updated links on a password protected master wb linked to 10 slave wb.
See link below:
My current issue is... when I make changes to...