Hi,
I want to protect an workbook strucutre, preventing users from adding new sheets. But I don't want the file to be protected with a password to open it.
For that, I am using Workbook_Protect action without password and with LockStructure. The excel structure is protected and has the add sheet option disabled, but when opening the file it requests a password.
Does anyone know a way to protect the structure without requesting a password to enter the file?
You're experiencing this because Workbook_Protect with LockStructure still sets a structure protection password—even if left blank—triggering Excel to prompt for one when opening. To avoid the password prompt, you’ll need to set protection without enabling structure lock, or use a known non-blank password programmatically to manage the protection explicitly.