VBS script / MACROS arghhh!?

date posted 17th July 2001 13:36

Hi forum people,

I have a wee problem. I am a graphic designer (no that isn't the problem!) I
have reluctantly trained myself up in MS Excel for various techy projects
for my client (http://www.c-pro.net). the latest project has me stumped.
Basically the client has a secure admin area on their site. In this area the
client's technicians can download beautiful excel admin forms to their
heart's content... on each of these forms is a MACRO assigned to a graphic.
The code is as follows:

Private Sub Picture_Click ()
ActiveWorkbook. SendMail Recipients: [EMAIL REMOVED]

The idea being that they fill out their forms and 'SUBMIT' them to the Admin
HQ (temporarily [EMAIL REMOVED]

The problem seems to be that the MACRO seems to effect all open workbooks.
My client was happily typing away on a confidential PAYE structure document
in Excel... he also downloaded a timesheet from the site as a test and
SUBMITTED it to me... only problem... I received the confidential
document... OOPS!

How do I ensure the above doesn't happen? can the code above
(ActiveWorkbook) be changed to talk to JUST the downloaded document???...
can I get back to Photoshop now please?

regards

Adam