98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Group/Ungroup on protected sheet
Group/Ungroup on protected sheet
Resolved · Urgent Priority · Version 365
Tue 6 Jul 2021, 13:15Delegate Tsudoi said...
Tsudoi has attended:
Excel PowerPivot course
Excel VBA Introduction course
Group/Ungroup on protected sheet
Hi,
I have an Excel workbook with one of the sheets having certain areas password-protected but I want to allow group & ungroup rows and columns. It's only one sheet that has such a protection but if VBA code will do the trick, please advise the coding?
Thanks!
Tue 6 Jul 2021, 16:41Trainer Dennis said...
RE: Group/Ungroup on protected sheet
Hi Tsudoi
Please check out the below website for advice on how to enable group/ungrouping
https://www.thespreadsheetguru.com/the-code-vault/groups-expand-collapse-sheet-password-protection
Regards
Dennis
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:COUNT function vs COUNTA functionThe COUNTA function works in the same way as the COUNT function, except that it will count cells that contain text (labels) and also cells that contain numbers (values). The COUNT function will only count cells that contain numbers. Blank cells are not counted by either the COUNT or the COUNTA function. |
