Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
John
 
Posts: n/a
Default workbook protection

hi, im doing the advanced ecdl speadsheets on officexp excel. Theres one
thing that i dont understand. When i goto Tools, Protection, Protect
Workbook and then apply protection to the Structure and Windows and choose
my passwords, why is it that im still able to modify cells, delete formulas,
insert columns and rows etc? The only thing i cant do is insert a
worksheet. Im confused as applying protection in the same way for
Worksheets gives me more protection than applying protection in a workbook
using the Tools.

Any advice on this matter is appreciated

John


  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi John

worksheet and workbook protection are two completely different things.
in brief:
- worksheet protection protects the contents of the sheet - and is applied
on a sheet by sheet basis
- workbook protection protects the structure of the workbook

so basically, if you just apply worksheet protection you can stop people
deleting / overtyping your formulas but they can still delete the sheet -
workbook protection is necessary to stop them deleting the sheet.

So in most cases you need to apply worksheet protection to each sheet to
protect its contents AND workbook protection to protect the book itself.

hope this helps
Cheers
JulieD

"John" wrote in message
...
hi, im doing the advanced ecdl speadsheets on officexp excel. Theres one
thing that i dont understand. When i goto Tools, Protection, Protect
Workbook and then apply protection to the Structure and Windows and choose
my passwords, why is it that im still able to modify cells, delete
formulas, insert columns and rows etc? The only thing i cant do is insert
a worksheet. Im confused as applying protection in the same way for
Worksheets gives me more protection than applying protection in a workbook
using the Tools.

Any advice on this matter is appreciated

John



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
find links to another workbook Patricia Excel Discussion (Misc queries) 1 January 21st 05 10:33 PM
copy COLUMN from 1 worksheet to another (in a different workbook) DavidB Excel Discussion (Misc queries) 3 January 15th 05 03:47 PM
copy a workbook from other workbook with lot of sheets wit... Vai Excel Discussion (Misc queries) 1 January 3rd 05 11:27 PM
Shared workbook protection zeek Excel Discussion (Misc queries) 1 December 13th 04 02:30 PM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 03:02 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"