-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
Check Box (active X)
- Thread starter sharvey
- Start date
sykes
Well-known Member
- Joined
- May 1, 2002
- Messages
- 1,775
- Office Version
-
- 365
- Platform
-
- 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......
....line to close the book.
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.closeSimilar threads
- Question
- Solved
Watch MrExcel Video
Forum statistics
Share this page
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.
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".
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.
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.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back