Would anyone know how to set up a code for the workbook to open with a disclaimer? The rest of the worksheets would open once the ACCEPT button is pressed. Operating Excel 2011 for Mac.
- disclaimer is a worksheet (rather than dialogue box)
- if ACCEPT is not pressed (eg EXIT is pressed instead), the worksheet closes
- ideally would need to work in Excel 2010/11 for both Windows and Mac
Thanks and regards
Hi firefly and welcome to the forum,
I think this link is close to your problem.
http://www.ozgrid.com/VBA/auto-run-macros.htm
The idea is basically,
You need to put code behind the ThisWorkbook module which is triggered by the Workbook_Open() Event.
You need to build a Screen or Userform that pops up using code from this event and after pressing a button or key the open workbook is completed or the file is closed.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks