View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default VBA error in Excel 2003

Hi Vbjenny,

The following code has been used successfully in Excel 2000 for several
years. My company is beginning to transition users to Excel 2003 and
users are calling me to fix errors on several parts of my code. Here
is one example:


I've seen trouble like this being caused by worksheet protection
(strictly in Excel 2003, the UserinterfaceOnly trick sometimes doesn't
seem to work). If you remove protection before the code and put it back
in place afterwards, I expect you'll be OK.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com