Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I know the code to protect and unprotect my sheets or work book.
and i know you can set a range to be able to be editted. but does that reset every time you protect and unprotect and reprotect the sheet is it really as simple as i just need to go into "Allow Edit ranges" button in Review tab on the sheet I want and then leave the Protect and unprotect VBA code in my macro alone and it iwll always remember? Or do i have to add more code to my Sheet protection in my macro to allow editting?
Example I want to leave W2:AK50 to be able to be editted when i open the file or use any of the other macros i have to transfer data.
and i know you can set a range to be able to be editted. but does that reset every time you protect and unprotect and reprotect the sheet is it really as simple as i just need to go into "Allow Edit ranges" button in Review tab on the sheet I want and then leave the Protect and unprotect VBA code in my macro alone and it iwll always remember? Or do i have to add more code to my Sheet protection in my macro to allow editting?
Example I want to leave W2:AK50 to be able to be editted when i open the file or use any of the other macros i have to transfer data.