vbe-disclaimer

  • Thread starter group changes of spreadsheet
  • Start date
G

group changes of spreadsheet

I want to set up a work book so that when it opens the user can not go any
further with it until they tick a disclaimer.Once this disclaimer has been
accepted thje work book opens up and the user can open all sheets
 
R

RB Smissaert

How about a simple Msgbox in Private Sub Workbook_Open() ?
This is in the ThisWorkbook module.

RBS



"group changes of spreadsheet"
 

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

Text Box Scroll Bars do not appear until you click in the text box 3
Using a disclaimer in excel 3
User Form Appears Blank 2
Phantom workbooks in VBE in Excel 2007 1
Auto_open from Worksheet Object Code 1
Book suddenly opens with no visible sheets 6
Macro - New Workbook 1
Prevent VBE from opening on errors? 4

Top