Does protecting a workbook shut off VBA code?

S

Stilla

At this site, you guys helped me out on some code to automatically name tabs
from an entry on the worksheets. Works great, thanks!

When I protect the workbook, however, the code does not work. Did I do
something wrong, or does this normaly happen?

I have to protect the workbook for various reasons. Actually, that is why I
needed the tabs to be named automatically.

Any insights welcome!
 
D

David D

When you protect a worksheet/workbook, even VBA becomes limited.

For example, if a sheet is protected and you use VBA to add a row, you'll
get a runtime error.

You need to add code to your VBA routine that will unprotect the sheet, do
its thing, and then protect it again.

Sheets("whateverthename").UnProtect
....
Sheets("whateverthename").Protect

Hope that helps.
 
Top