"Group" in the subject line

Alastair_Ching 

The issue you're experiencing might be related to the workbook being in a grouped state, where certain functionality is restricted. To resolve this, you can try ungrouping the sheets and see if it restores the functionality. Here's how you can do it:

1. Ungroup Sheets:
• Right-click on one of the sheet tabs at the bottom.
• If the sheets are grouped, you should see an option like "Ungroup Sheets" or "Ungroup."
2. Remove Sheet Grouping via VBA:
• If the right-click method doesn't work, you can try running a VBA (Visual Basic for Applications) code to ungroup the sheets.
• Press Alt + F11 to open the VBA editor.
• In the editor, go to Insert > Module to create a new module.
• Copy and paste the following code into the module:

Sub UngroupSheets()
    On Error Resume Next
    ActiveWorkbook.Sheets.Ungroup
    On Error GoTo 0
End Sub

• Run the code by pressing F5 or selecting Run from the menu.

3. Check for Workbook Protection:

• It's also possible that the workbook is protected, which could restrict certain actions.
• Go to the Review tab and check if there is an option to "Unprotect Workbook." If so, click it and provide the password if required.

4. Check for Macro Security:

• Some features might be disabled due to macro security settings. Ensure that macros are enabled.
• Go to File > Options > Trust Center > Trust Center Settings.
• In the Trust Center, click on Macro Settings and choose the appropriate setting. Ensure that "Enable all macros" is selected if you trust the source of the workbook.

After trying these steps, check if the functionality is restored. If the issue persists, there might be other specific settings or configurations in the workbook that need to be examined.

However, without more information about your specific situation, it's difficult to say for sure that this will solve the problem. Try changing the steps as suggested and see if that fixes the problem. The text, steps, code was created with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.