Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I secure all tabs in excel 2003 at once?
I have made a lot of tabs en secured them. When I want to change something I
have to unsecure the tabs one by one. I would like to secure and unsecure them all together if possible. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I secure all tabs in excel 2003 at once?
Hi Marisca, Download ASAP utilities (free) from asap-utilities.com. This should enable you to do what you want. Ed -- EdMac ------------------------------------------------------------------------ EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736 View this thread: http://www.excelforum.com/showthread...hreadid=529557 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I secure all tabs in excel 2003 at once?
Use a macro.
Sub ProtectAllSheets() Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Protect Password:="justme" Next n Application.ScreenUpdating = True End Sub Sub UnprotectAllSheets() Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Unprotect Password:="justme" Next n Application.ScreenUpdating = True End Sub Gord Dibben MS Excel MVP On Tue, 4 Apr 2006 03:35:01 -0700, marisca wrote: I have made a lot of tabs en secured them. When I want to change something I have to unsecure the tabs one by one. I would like to secure and unsecure them all together if possible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) |