View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Maria J-son[_2_] Maria J-son[_2_] is offline
external usenet poster
 
Posts: 15
Default xlVeryHidden

If you want to be sure the user can't see it, you can use
"xlSheetVeryHidden" adn to show it again use "xlSheetVisible". Here with
codename of the sheet intestead of the name of the sheet otherwise exchange
Sheet1. with Worksheet("Sheet1").

Sub VeryHideSheet
Sheet1.Visible = xlSheetVeryHidden
End sub

Sub ShowSheet
Sheet1.Visible = xlSheetVisible
End sub


/regards


"jk" skrev i meddelandet
...
Hello,
What is the code used to hide a sheet in the workbook?

Thanks