I'm trying to write VBA to save a worksheet that contains 50 ComboBoxes and I would like the save worksheet. When the saved worksheet is opened it needs to be locked so that it cannot be edited.
I'm trying to write VBA to save a worksheet that contains 50 ComboBoxes and I would like the save worksheet. When the saved worksheet is opened it needs to be locked so that it cannot be edited.
How about using a trigger value in an out of focus cell or hidden worksheet that goes to 1 if the combo boxes have changed. Then in the workbook_open event read the value of the trigger cell such that If 1 then set locked property for each combo box to True?
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks