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

Good Morning Ray,

Thank you for your directions and with respect to you question, yes - the 
file could be closed but equally it could be open and being used by others - 
does this help?

Regards,

Dave

----- Original Message ----- 
From: "Ray Blake" <ray@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, December 24, 2004 6:14 AM
Subject: [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
> *************************************************************
> 


*************************************************************
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: