Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does protecting a workbook shut off VBA code?
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Does protecting a workbook shut off VBA code?
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. -- -David D "Stilla" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Often-Used Code not working in a new Workbook | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |