Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default workbook protection

I need to protect several workbooks from being modified (to do this a sheet
at a time would take forever)- I want to password protect them - there is a
help entry for "set password to modify a workbook" but (and this is big but)
the information is NOT for Excel 2007 - it looks like 2003. This is what is
in the 2007 Excell Help and on the Excel Help on line. Is there any way to
do this in 2007??

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default workbook protection

Not sure where this goes in 2007 but in 2003 right click the sheet tab, view
code paste it in and run it

Sub protectem()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect Password:="Mypass"
Next ws
End Sub

Mike

"jolowe" wrote:

I need to protect several workbooks from being modified (to do this a sheet
at a time would take forever)- I want to password protect them - there is a
help entry for "set password to modify a workbook" but (and this is big but)
the information is NOT for Excel 2007 - it looks like 2003. This is what is
in the 2007 Excell Help and on the Excel Help on line. Is there any way to
do this in 2007??

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 206
Default workbook protection

This would be in the "SaveAs" properties for the workbook. There are 2
options: WriteResPassword and Read Only. WriteResPassword will let you
modify if you give the password. Read Only will not let anyone modify it.
The only way would be to save the file as a different name, modify it, and
then saveas the original book name, or over-write the read-only book.

Mike F
"jolowe" wrote in message
...
I need to protect several workbooks from being modified (to do this a sheet
at a time would take forever)- I want to password protect them - there is
a
help entry for "set password to modify a workbook" but (and this is big
but)
the information is NOT for Excel 2007 - it looks like 2003. This is what
is
in the 2007 Excell Help and on the Excel Help on line. Is there any way
to
do this in 2007??



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 857
Default workbook protection

Hi,

You can also get to the proper location in 2003 by choosing Tools, Options,
Security and enter a Password to Modify.

Cheers,
Shane Devenshire
Microsoft Excel MVP
Join http://setiathome.berkeley.edu/ and download a free screensaver to help
search for life beyond earth.

"jolowe" wrote in message
...
I need to protect several workbooks from being modified (to do this a
sheet
at a time would take forever)- I want to password protect them - there is
a
help entry for "set password to modify a workbook" but (and this is big
but)
the information is NOT for Excel 2007 - it looks like 2003. This is what
is
in the 2007 Excell Help and on the Excel Help on line. Is there any way
to
do this in 2007??

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
Workbook protection Baldyman Excel Discussion (Misc queries) 2 December 7th 07 09:49 PM
workbook protection sherobot Excel Worksheet Functions 2 August 30th 07 11:34 PM
Workbook protection Bonbon Excel Worksheet Functions 8 April 27th 06 01:54 PM
Workbook Protection AEK Excel Discussion (Misc queries) 2 June 23rd 05 01:49 AM
workbook protection John New Users to Excel 1 January 22nd 05 01:55 PM


All times are GMT +1. The time now is 10:51 AM.

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"