Thread: hide and unhide worksheets when a set button on a form is clicked
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JBeaucaire[_133_] JBeaucaire[_133_] is offline
external usenet poster
  
Posts: 1
Default hide and unhide worksheets when a set button on a form is clicked

When you VIEW CODE on the first button, the code would be:

Code:
--------------------
Sheet1.VeryHidden = False
Sheet2.VeryHidden = False
Sheet3.VeryHidden = True
Sheet4.VeryHidden = True

--------------------


Bet you can figure the others out now. (wink)


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=44676

Reply With QuoteReply With Quote