User Form on Opening of Sheet

J

John

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

accept and decline buttons in excel sheet emailed to me as attachm 4
Is this possible in Excel (User Form) 1
Opening Workbook from User Form 6
confirmation window once user clicks submit on user from 4
Scroll to Top of Sheet, When Sheet is FIRST Activated 3
forcing specific sheet opening upon launch of .xlsx file 4
user input recorded twice on excel sheet 7
form buttons on sheet collapse on unhide - sometimes 5

Top