Thread: VB code
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DJ DJ is offline
external usenet poster
 
Posts: 13
Default VB code

I have some VBA code that loops thru sheets and protects
them (or unprotects dependant on a variable).
Unfortunately, everytime it runs- excel thumbs thru the
sheets and you can see the process happen (similar to if I
recorded a macro). Most of the time the code happens in
the background without visibly thumbing thru sheets, is
there a way to hide what the code is doing in this
particular case or does it need to have the sheet
activated in order to protect it?

BTW- I hope I'm not abusing this forum by asking too many
questions :| They've just been building up and now I have
a place to get them answered

thnx in advance