View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Etrnal168 Etrnal168 is offline
external usenet poster
 
Posts: 1
Default Activesheet < Sheets("Name")


Hello guys, can I get some help with macros?

I am trying to write a line that says

If activesheet < Sheets("blahblah") then
exit sub

But of course, that didn't work. What should be the correct code?

Also, sometimes when show the user an input box asking them to typ
something then select OK or Cancel, when the users try to move the box
the box doesn't refresh and their entire screen ends up with the shado
of the box; like a trail of the message box. Is there a way t
eliminate that?

Thanks

--
Etrnal16
-----------------------------------------------------------------------
Etrnal168's Profile: http://www.excelforum.com/member.php...fo&userid=2513
View this thread: http://www.excelforum.com/showthread.php?threadid=38700