worksheet protection

jeffreydbrown · Apr 26th, 2002, 02:05 PM

is there any way to protect all worksheets within a workbook at one time as opposed to protecting each sheet one at a time?

Mark O'Brien · Apr 26th, 2002, 02:19 PM

using VBA you can protect sheets easily.



Public Sub protectsheets()

  Dim oSheet As Worksheet

  

  For Each oSheet In Worksheets

     oSheet.Protect Password:= ""

  Next



End Sub

This protects them with no password.

Apr 26th, 2002, 02:19 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	using VBA you can protect sheets easily. Public Sub protectsheets() Dim oSheet As Worksheet For Each oSheet In Worksheets oSheet.Protect Password:= "" Next End Sub This protects them with no password. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 02:05 PM	#1
jeffreydbrown New Member Join Date: Apr 2002 Posts: 1	is there any way to protect all worksheets within a workbook at one time as opposed to protecting each sheet one at a time?