Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Sheets
I've tried searching (I'm sure others have had this question) but I can't
seem to find the answer... I want to protect workbook with multiple worksheets so that the formulas cannot be disturbed (and in fact hide sheets) but at the same time allow the workbook to be linked to other workbooks (and thus, allow users to change the links). I can protect it OR I can change the links...but I can't figure out how to do both. Any advice? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Sheets
what happens if you put a tick in the insert hyperlinks option when
protecting the sheet ? "Joyce" wrote: I've tried searching (I'm sure others have had this question) but I can't seem to find the answer... I want to protect workbook with multiple worksheets so that the formulas cannot be disturbed (and in fact hide sheets) but at the same time allow the workbook to be linked to other workbooks (and thus, allow users to change the links). I can protect it OR I can change the links...but I can't figure out how to do both. Any advice? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Sheets
I met the same problem. But I do by side way:
1. Open a new file: click open a new file to the tool bar 2. Select all of your sheet 3. Copy and paste to the new file; click at the left top conor of the new sheet( the whole sheet becomes black colour) 4. Leave and save the original files 5. At remaining new file, Click Edit tool bar; select "Select option", select "Value to paste" Completed "Joyce" wrote: I've tried searching (I'm sure others have had this question) but I can't seem to find the answer... I want to protect workbook with multiple worksheets so that the formulas cannot be disturbed (and in fact hide sheets) but at the same time allow the workbook to be linked to other workbooks (and thus, allow users to change the links). I can protect it OR I can change the links...but I can't figure out how to do both. Any advice? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protecting Sheets
protect the worsheets but NOT the workbook . . this will allow you links to
work . .I had the exact problem. Mike Sawchuk "Joyce" wrote: I've tried searching (I'm sure others have had this question) but I can't seem to find the answer... I want to protect workbook with multiple worksheets so that the formulas cannot be disturbed (and in fact hide sheets) but at the same time allow the workbook to be linked to other workbooks (and thus, allow users to change the links). I can protect it OR I can change the links...but I can't figure out how to do both. Any advice? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protecting Sheets in Excel So Others Can't See Certain Sh | Excel Worksheet Functions | |||
Protecting individual sheets | Excel Discussion (Misc queries) | |||
Protecting Multiple Sheets | Excel Discussion (Misc queries) | |||
Protecting multiple sheets | Excel Discussion (Misc queries) | |||
Protecting sheets | Excel Discussion (Misc queries) |