[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


----- Original Message ----- 
From: "Ray Blake" <ray@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Thursday, December 23, 2004 10:53 PM
Subject: [mso] Re: Excel 2000 - Use of Cell Formatting in Formula


> The first question has a solution in VBA, using the change event of the
> worksheet. I've posted an example file for how to use the change event
> in the Excel VBA group - you can learn more here:
>
> http://groups.yahoo.com/group/ExcelVBA/
>
> I've read your second question a couple of times and I'm not sure I
> understand it. Want to have another go?
>
> 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: 23 December 2004 21:13
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel 2000 - Use of Cell Formatting in Formula
>
>
> Evening all...
> ...here is a re-post because I don't think my original hit the system (I
> never received a copy on posting).
>
> At work we use Excel 2000 whilst at home I have Office XP - what I need
> to do is incorporate cell formatting in a formula - can it be done?
>
> I have in Column A, cells which will contain either the Letter 'A', 'B'
> or are completely empty except for the validation statement and I need
> to be able to switch on or off cell locking in two other cells, If the
> letter 'B' is input the dependant cells need to be locked - so to give
> an example:
>
> Contents of Cell A1 = 'B' then cells B2:B3 need to be locked;
> conversely, if cell A1 holds 'A' or is completely empty (with exception
> of validation) cells B2:B3 need to be unlocked.
>
> Further to this problem i now have another....
>
> Not having used Visual Basic, can a Macro or Visi-Basic script be used
> which will enable users of a dependant Workbook clear cells in another
> Workbook when that Workbook it is  open or closed?
>
> I would appreciate your collective help - please
>
> Best wishes for the Festive Season.
>
> 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: