View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave ferris Dave ferris is offline
external usenet poster
 
Posts: 7
Default hide and unhide worksheets when a set button on a form is clic

many thanks for the quick reply sorry about the delay in replying but i have
only just managed to see my ownpost let a lone your reply.
thank you

"JBeaucaire" wrote:


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