A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Q: locking some, but not all, properties of a cell



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2004, 02:28 PM
external usenet poster
 
Posts: n/a
Default Q: locking some, but not all, properties of a cell

Folks,

Is there a way of locking the format of a cell, but not
the contents?

We have a shared yearly planner type spreadsheet in which
cells are coloured to indicate vacation, on course, off
sick, etc, and may also contain key letters to indicate
Early or late shifts.

I would like to allow anybody to input shift changes, but
reserve changes in vacation (cell colour) for the
administrator.

Thanks - Mike.
  #2  
Old July 12th, 2004, 03:40 PM
Frank Kabel
external usenet poster
 
Posts: n/a
Default locking some, but not all, properties of a cell

Hi
AFAIK not possible with the build-in protection functionality. This
would require VBA (though checking for a color change is difficult and
would require for example the OnTime method). So in total you may use
something different:
- indicate holidays also with an entry
- use conditional formating for showing colors depending on your entry


--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Folks,

Is there a way of locking the format of a cell, but not
the contents?

We have a shared yearly planner type spreadsheet in which
cells are coloured to indicate vacation, on course, off
sick, etc, and may also contain key letters to indicate
Early or late shifts.

I would like to allow anybody to input shift changes, but
reserve changes in vacation (cell colour) for the
administrator.

Thanks - Mike.


  #3  
Old July 12th, 2004, 04:35 PM
MikeC
external usenet poster
 
Posts: n/a
Default locking some, but not all, properties of a cell


-----Original Message-----
Hi
AFAIK not possible with the build-in protection

functionality. This
would require VBA (though checking for a color change is

difficult and
would require for example the OnTime method). So in total

you may use
something different:
- indicate holidays also with an entry
- use conditional formating for showing colors depending

on your entry


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks for the suggestion, Frank, but if it was all
dependant on data entry into a cell, I couldn't stop users
from entering vacation letters while still allowing them
to enter shift letters.

I can, of course, change the way the spreadsheet works,
but what I need is to allow everybody to enter one set of
criteria while preventing all but the administrator from
entering a different set of criteria. I thought about
using two sets of cells, a protected one for holiday
planning and the other (unprotected) for shift planning,
but there isn't enough space on the screen without
scrolling. It wouldn't look as professional!

Incidentally, I'm not frightened by Excel Basic, if you
have some ideas to give me.

Mike.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
**Trying to use answer from another formula cell in another formula KIMBERLY Worksheet Functions 1 April 27th, 2004 06:22 PM
Lookup and highlight matching cell with colours JE McGimpsey Worksheet Functions 0 March 5th, 2004 04:03 PM
Link or paste cells based on Date in cell Ayanna Worksheet Functions 0 December 16th, 2003 07:10 PM
Value in one cell changes the Text Properties in another...... DoD_au Worksheet Functions 4 December 16th, 2003 08:39 AM
Question on LOGIC ?? - PLEASE HELP PM Worksheet Functions 17 November 28th, 2003 10:13 AM


All times are GMT +1. The time now is 12:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.