How to allow edit object after protecting the excel file in code?
ActiveSheet.Protect Password:=pw
After the file is protected and click on one of the checkboxes, the window message pops up saying 'protected and realy only", I have to click OK then continue for editing. I would like to avoid that message pops up.
ActiveSheet.Protect Password:=pw
After the file is protected and click on one of the checkboxes, the window message pops up saying 'protected and realy only", I have to click OK then continue for editing. I would like to avoid that message pops up.