Thread: How to create a view option (or hide/unhide preselected cells) (Repost from Misc)
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Turquoise_dax[_4_] Turquoise_dax[_4_] is offline
external usenet poster
  
Posts: 1
Default How to create a view option (or hide/unhide preselected cells) (Repost from Misc)

I tried it, (adjusting column and criteria, of course!), and when I
click the button, it hides all rows (2-12) while only the 8 and 11
contained the criteria.

On the other hand, I am a newbie at trying to programm buttons, so
maybe I do something wrong right from the start...

(I used the tool to create the button, I assigned a macro, and I went
in visual basic, simply cutting/pasting your code, getting rid of the
comments and adjusting column letter and criteria.)


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=552401

Reply With QuoteReply With Quote