View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How to Know Selected Sheets

dim wks as worksheet

for each wks in activewindow.selectedsheets
'your code
next wks



dbarelli wrote:

I'm making a form to protect all sheets or all selected sheets with a
password but trying this I found a problem.
How can I know all selected sheets at moment of begin the action to
apply code only to them ?

Thanks and Regards
Daniel.

--
dbarelli
------------------------------------------------------------------------
dbarelli's Profile: http://www.excelforum.com/member.php...o&userid=31275
View this thread: http://www.excelforum.com/showthread...hreadid=570888


--

Dave Peterson