LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Fancier Protect Sheets, Workbooks

I set up the following, attached to Icons on personal tool bar
( most is from this forum)

' ProtectionOff Macro
' Keyboard Shortcut: Ctrl+Shift+U
Dim ws As Worksheet
For Each ws In Worksheets
ws.Unprotect ("ABC")
Next ws
ActiveWorkbook.Unprotect (["DEF"])
End Sub

I have another one to PROTECT all sheets and workbook.

Questions:
1: Is there an icon I can use to Toggle between Protect / Unprotect?
(Instead of a seperate icon for each instruction)

2: Can the above be modified to check each sheets state before trying to
change it?
(It might be in the correct state already)
I'm afraid that trying to, for example, protect a sheet that is
protected already,
might cause a glitch, under certain circumstances.

3: Is there a way to visually and easily show the state of the active
sheet(s)
and workbook, (whether its protected or not), Perhaps by colour on the
icon(s)?
Or by having a message box pop up ( and fade away )
or ???????????

Thanks in advance for any help.


 
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
How to password protect multiple workbooks? bodeene Excel Discussion (Misc queries) 1 April 8th 10 09:51 PM
Linking to Password Protect Workbooks Paul Ferris Excel Discussion (Misc queries) 23 November 3rd 07 01:30 PM
password protect copies of workbooks dave caizley Excel Discussion (Misc queries) 1 September 21st 07 07:59 PM
Running macros with protect workbooks Duderino Excel Discussion (Misc queries) 1 April 18th 07 06:56 PM
Password protect a folder with several workbooks tbugs Excel Discussion (Misc queries) 1 August 7th 06 09:06 AM


All times are GMT +1. The time now is 04:20 AM.

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

About Us

"It's about Microsoft Excel"