Conditional protection

K

Ken_Hosking

Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there a way to apply or turn off protection to nominated Excel cells depending on the value of a nearby cell? I guess I could write a macro, but then others using Excel 2008 would not be able to use the spreadsheet.
 
J

John_McGhie_[MVP]

Not that I am aware of: protection can be set only by keystrokes or a macro,
to the best of my knowledge.


Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
Is there a way to apply or turn off protection to nominated Excel cells
depending on the value of a nearby cell? I guess I could write a macro, but
then others using Excel 2008 would not be able to use the spreadsheet.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top