Go into your workbook and press ALT+F11. Now on the left it should have icons for SHeet1, Sheet2, Sheet3 and This Workbook
Double click "This Workbook", then at the top of the blank page you'll see two drop down boxes. One says General, and the other one says Declarations. You change the General one to 'Workbook' and paste the code onto the blank page
how can i make this message box which apears show the current settings ie when someone has made shanges to the setiings saved and exits and the next person who uses the program will want to know what the new settings wíll be, i want the message box to show the current settings, ie referance to cells which have the possibilyty of being changed
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.