View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Strong-arm tactic for enabling Macro

Hari,

Please just forget I stuck my head in here.
Your code works, mine has problems.

Regards,
Jim Cone
San Francisco, CA

"Hari" wrote in message ...
Hi Jim,
Thnx for getting in to the thread.
I actually couldnt understand what David M and urself are suggesting.
I dont understand why we have to hide the sheets and unhide the sheets
within the same session.
I mean shouldnt hiding and unhiding have be done in different sessions. By
different sessions I mean user works on the sheet saves it and closes excel
(stage 1)then tomorrow or some other day open the sheet again (stage 2). Now
in this process wouldnt hiding be done at the completion of stage 1 and
unhiding be done at the starting of stage 2.
Im not able to understand why DM and urself are hiding and unhiding within a
single session. I am not able to understand the logic of doing so. If
possible may be u could give me the full code of what u are saying and may
be this will help me in understanding in where my thinking is going wrong.

Regards,
Hari
India


- snip -