Unprotect the sheet in your code, then reprotect it would be one way.

I am not in Excelforum and clicking on your link brings up nothing.

--
Regards,
Tom Ogilvy

"Metallo " wrote in message
...
Tom,

Here are the Workbook_Open Event code and the Macro (Module)

Once I run the macro and click to group/ungroup it says that I cannot
use the command on a protected sheet.
This happens only in W2K (OFFICE 2000).

It works perfectly in XP (OFFICE2003)

I'm sure something can be added to the Macro to let the group/ungroup
function work in 2000, but I don't know what and where.

Thanks for your help
Alex

Attachment filename: private sub workbook and macro.txt
Download attachment:
http://www.excelforum.com/attachment.php?postid=617443
---
Message posted from http://www.ExcelForum.com/