ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can't Group or Ungroup in Protected Cells (https://www.excelbanter.com/excel-programming/292016-cant-group-ungroup-protected-cells.html)

Dupi

Can't Group or Ungroup in Protected Cells
 
I have a problem with Group and Ungroup. In a protected
rows or columns, I can't do Group and Ungroup. Can anybody
help me with some macros that can resolve this? Thanks a
bunch in advance.

BrianB

Can't Group or Ungroup in Protected Cells
 
The macro code needs to include a line at the beginning to unprotect th
sheet and another at the end to protect again.

If you do not have the password you cannot do this.

Otherwise I suggest you record a macro of your actions and come back i
you need any further help - copy/paste the code in the message

--
Message posted from http://www.ExcelForum.com


Dupi

Can't Group or Ungroup in Protected Cells
 
Hi, Brian.
Thanks for the reply. Can you give me example how to do
it?. I mean .. I'm new to VBA Macros..

What do you mean by include a line?. I tried it, by
putting "_______
or "----" can't help it.

Thanks,
-----Original Message-----
The macro code needs to include a line at the beginning

to unprotect the
sheet and another at the end to protect again.

If you do not have the password you cannot do this.

Otherwise I suggest you record a macro of your actions

and come back if
you need any further help - copy/paste the code in the

message.


---
Message posted from http://www.ExcelForum.com/

.



All times are GMT +1. The time now is 10:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com