Check Box (active X)

sharvey

New Member
Joined
Aug 13, 2010
Messages
4
How can I limit further progression into a workbook by using a check box? (such as a terms and conditions pop up or page)
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,775
Office Version
  1. 365
Platform
  1. Windows
Hi, and Welcome to Mr Excel
You could insert a userform (with the checkbox on it, along with an OK button, and some text instructing the user to accept your terms by checking the box) into the VBA section of your project, then insert a line into the _Open event of the workbook to show the userform modally.
Once the user clicks the OK button, if the checkbox is checked the workbook continues, if it's not then use the......
Code:
thisworkbook.close
....line to close the book.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,911
Messages
5,598,819
Members
414,260
Latest member
joishe

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top