| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Protecting more than one worksheet in one workbook
I have multiple worksheets in one workbook which I want to protect the cells
from anyone being able to view the formulas within them but still be able to manipulate information within the spreadsheet. I also need to do this for every single sheet and password protect. Is there an easy way to do this with out going one by one and formatting the cells and then protecting the sheet? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Protecting more than one worksheet in one workbook
a loop?
for each ws in worksheets ws.doyourstuff next ws -- Don Guillett SalesAid Software "RobP" wrote in message ... I have multiple worksheets in one workbook which I want to protect the cells from anyone being able to view the formulas within them but still be able to manipulate information within the spreadsheet. I also need to do this for every single sheet and password protect. Is there an easy way to do this with out going one by one and formatting the cells and then protecting the sheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting all worksheets of a workbook | Excel Discussion (Misc queries) | |||
| Reference External Worksheets & Protect Worksheet / Workbook | Excel Worksheet Functions | |||
| Copying A Worksheet From Each Open Workbook to an new Workbook | Excel Worksheet Functions | |||
| copy worksheet to another workbook | Excel Discussion (Misc queries) | |||
Linear Mode
