View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default A couple of questions (formating & Collating worksheets)

Versions after XL2000 have additional protection options. Don't know if
that's the reason your code doesn't work as I only have xl2000 to hand.

Regards,
Peter T

"deelee" wrote in
message ...

Hi Peter - I have a new problem!

When I try the macro here at work (Excel 2000) it won't work!

I was working on my PC at home when I tried the Protect/Unprotect and
it worked; so my question is - should the macro I posted work on Excel
2000 or have I goofed somewhere?

Regards,

Dave


--
deelee
------------------------------------------------------------------------
deelee's Profile:

http://www.excelforum.com/member.php...o&userid=34866
View this thread: http://www.excelforum.com/showthread...hreadid=556391