User Form on Opening of Sheet

I am trying to create a User Form when an Excel file is opened. The content
of which will be Terms & Conditions. These will be detailed s I would
require a Taskbar to scroll down. I'm not sure how I can go about it. If any
one has any suggestions or better still sample which I could look at. The
specifics of what I want to do are

1) Appear on Opening
2) Have a scroll bar on right hand side
3) Have to command buttons "Accept" and "Decline"
4) If "Decline" is clicked,then a Dialog box appears stating "You cannot
access this File with agreeing to all terms" - once then the user clicks
"OK" file closes.
5) If user clicks "Accept". Cell AA1 records the Date and Time stamp of
acceptance


Thanks

Hi John

See
http://support.microsoft.com/default...b;EN-US;829070

Open the Form in the workbook open event
http://www.cpearson.com/excel/events.htm




--
Regards Ron de Bruin
http://www.rondebruin.nl



"John" <[email protected]> wrote in message news:[email protected]...
>I am trying to create a User Form when an Excel file is opened. The content of which will be Terms & Conditions. These will be
>detailed s I would require a Taskbar to scroll down. I'm not sure how I can go about it. If any one has any suggestions or better
>still sample which I could look at. The specifics of what I want to do are
>
> 1) Appear on Opening
> 2) Have a scroll bar on right hand side
> 3) Have to command buttons "Accept" and "Decline"
> 4) If "Decline" is clicked,then a Dialog box appears stating "You cannot access this File with agreeing to all terms" - once then
> the user clicks "OK" file closes.
> 5) If user clicks "Accept". Cell AA1 records the Date and Time stamp of acceptance
>
>
> Thanks
>
>
>