This is a non-persistent setting that must be reset while resetting
sheet protection each time any workbook containing the subject sheet is
opened. VBA is required and so you may have to rethink how your project
files are managed to make this work.
This would require your users to have an addin installed that will
reset this feature -EITHER- whenever the subject sheet is activated,
-OR- when a workbook containing the subject sheet is opened. This will
require the sheet is 'tagged' with a means of identifying it so only
sheets with that tag get processed.
I use a local scope defined name ("uiProtect") to hold this 'tag', and
its RefersTo holds that sheet's specific protection settings in a
delimited string. If the name exists then protection is reset when the
workbook containing it is opened. (I use the 'UserInterfaceOnly'
setting so I don't have to toggle protection when making changes to
locked cells. This is a non-persistent setting and so must be reset
each runtime)
Project workbooks do not contain macros, but they are *entirely*
managed by the project addin, meaning that they can't even be opened
without using the addin's 'Open' menuitem.
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion
---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com