Thread: Outlining works in XP not in 2000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Metallo[_6_] Metallo[_6_] is offline
external usenet poster
  
Posts: 1
Default Outlining works in XP not in 2000
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 canno
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/ungrou
function work in 2000, but I don't know what and where.

Thanks for your help
Ale

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

Reply With QuoteReply With Quote