Forum Discussion
kingmanmp4
Dec 22, 2020Copper Contributor
Grouping and ungrouping locked cells
Does anyone have any thoughts on how to enable users to use group and ungroup in a sheet with locked cells. Thanks
hrastashki
May 23, 2023Copper Contributor
HansVogelaar It might sound a silly question to you, but could you please advise where should I paste the macro code ?
HansVogelaar
May 23, 2023MVP
Press Alt+F11 to activate the Visual Basic Editor.
You should see a pane on the left hand side (the so-called Project Explorer) with something similar to this:
Double-click on ThisWorkbook.
Copy the code into the module window that appears.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open the workbook.