Thank you so much for your kind words! I'm glad you found the explanation clear and helpful. 😊 We have additional free Excel training if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
I have a question about Encrypting the workbook with a password. Scenario is that I've set the password, shared the file with one person, then instead of removing the current password, I choose to update the password. Will the password change affect the person who has the old password?
What about if I need to hide all formula at all worksheets and give allow for input data. I need to activate this order for all worksheets I have it . I tried by kuttools but not work good
You can try this: 1. Select the range of cells or columns that you want to allow for editing/data input 2. Right-click and select Format Cells 3. Go to the Protection tab and uncheck "Locked" 4. Enable Protect Sheet This step will leave the selected range "unprotected" or unlocked.
Hello, I would like to protect the workbook, but I want to leave a row of boxes for the client to clink on to pick options to upgrade if they would like. How do I do that?
Great Video, very clear and concise explanation , thank you
Excellent clear explanation - thank you
Thank you so much for your kind words! I'm glad you found the explanation clear and helpful. 😊
We have additional free Excel training if you need it 👉
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel
Thank you for this!!
No problem 😊
I have a question about Encrypting the workbook with a password. Scenario is that I've set the password, shared the file with one person, then instead of removing the current password, I choose to update the password. Will the password change affect the person who has the old password?
What if I want others to view but restrict entire workbook any kind of changes/edits?
Can i simply encrypt only worksheet?
What about if I need to hide all formula at all worksheets and give allow for input data.
I need to activate this order for all worksheets I have it .
I tried by kuttools but not work good
You can try this:
1. Select the range of cells or columns that you want to allow for editing/data input
2. Right-click and select Format Cells
3. Go to the Protection tab and uncheck "Locked"
4. Enable Protect Sheet
This step will leave the selected range "unprotected" or unlocked.
@@SimonSezIT thanks alot what about if I need to make this process on more than spreadsheets at one time not onr by one.
Hello, I would like to protect the workbook, but I want to leave a row of boxes for the client to clink on to pick options to upgrade if they would like.
How do I do that?
You need to uncheck the Locked box of those cells that you want to leave editable. It should be under Protection in the Format Cells option