Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have been asked to put code in an excel spreadsheet to be used for a
template on secure spreadsheets. There have been personal files opened from someone within the company during the evening hours (from home). Files are stored on fileserver and folders secured based on user, so it can only be users who have the authority to the folder. Think that should give a good ideal who is opening the documents. I have created modules in vbe to log user and timestamp upon opening the spreadsheet. I also have another module to automatically send an email with filename, user, timestamp. Email is sent without the user knowing it by using our email fileserver and microsoft schema. My problem is, it was requested to change the page color of the email to pink (as in a warning). I have the following code but I'm not able to figure what keyword and code to use. I not at all familiar with vb code in excel. Any help would be appreciated - Thanks! With iMsg Set .Configuration = iConf .To = " .CC = " .BCC = " .From = " " .Subject = "WARNING!!! WARNING!!! WARNING!!!" .fields.Update .TextBody = strbody ???? .Background = vbMagenta .send End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why do page breaks change in excel when spreadhseet sent as email | Excel Discussion (Misc queries) | |||
How to change the color of a page | Excel Programming | |||
Page Number Color In Page Break Preview | Excel Discussion (Misc queries) | |||
change font color whenever click a page of multipage control | Excel Programming | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |