ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   protect sheet question (https://www.excelbanter.com/excel-programming/380181-protect-sheet-question.html)

JG

protect sheet question
 
When I protect the sheet at the end of my macro I would like the locked
cell not to be selectable. What do I need to add into my Macro? I would
like the only the unlocked cells to be selectable. Below is what I
currently have.

ActiveSheet.Protect DrawingObjects:=True, Contents:=True,
Scenarios:=True, Password:="####"


Thank you for your suggestions

JG



All times are GMT +1. The time now is 03:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com