ExcelBanter - Unlocking Macro in protected sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Unlocking Macro in protected sheet (https://www.excelbanter.com/excel-programming/344097-re-unlocking-macro-protected-sheet.html)

hwolf60

Unlocking Macro in protected sheet

Start your macro with
ActiveSheet.Unprotect

and end it with
ActiveSheet.Protect DrawingObjects:=True, Contents:=True
Scenarios:=True

Good luc

--
hwolf6
-----------------------------------------------------------------------
hwolf60's Profile: http://www.excelforum.com/member.php...fo&userid=1749
View this thread: http://www.excelforum.com/showthread.php?threadid=48008

All times are GMT +1. The time now is 01:48 AM.