[mso] Re: Excel 2000 - Use of Cell Formatting in Formula

1. Look in the 'Files' section.
2. When you say 'open or closed' go you mean open and in use by another
person? If so, I think you may have issues with trying to do this.

Ray

------------------------------------
GR Business Process Solutions
Ray Blake
Head of Software Design
ray@xxxxxxxxx
Braedon
Newell Road
Hemel Hempstead
Herts HP3 9PD
tel: 01442 396518
fax: 01442 389353
mobile: 07834 226601
------------------------------------


-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
Behalf Of David Lee
Sent: 24 December 2004 01:53
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000 - Use of Cell Formatting in Formula


Hi Ray,

I have accessed the site (registered first) but can't find your posting
:-(

With respect to my second query...

I've a set of related workbooks, one being the 'Master' where
appointments 
are recorded by one group of users from which the five other workbooks
take 
their information from and are  'Box 1', 2, 3, 4, & 5 and these users
will 
need to clear appointments once an interview has been completed.

In an attempt to minimise the number of people accessing the 'Master' I
was 
hoping to use a macro (most probably VB script) to allow these users to 
clear appointments without accessing the 'Master' directly and
irrespective 
of the state of the Master, whether it is 'open' or 'closed'

With the number of appointments involved I would assume that the Box
users 
would need to have a facility to input information such as 'Master', Box

Number, day of the week and appointment time. Assuming the offsets could
be 
included in the script I think this would be sufficient information to
clear 
a record.

From the appointment 'Time' in the Master the following cell references
need 
to be cleared:

With the appointment time in Col A:
Name = Col B
Number = Col C
In addition, Col E needs to be re-set to 'No' (a validated cell).

I hope I've explained the problem a little better this time :-)

Thnk you for you help,

Regards,

Dave

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: