Codeing for hiding sheet

[jk]

Hello,
What is the code used to hide a sheet in the workbook?

Thanks

[Bob Flanagan]

Just record a macro of that action and you will get the code.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"jk" <jk@discussions.microsoft.com> wrote in message
news:54358926-3B0D-4812-B06F-4D801703E7D5@microsoft.com...
> Hello,
> What is the code used to hide a sheet in the workbook?
>
> Thanks

[Maria J-son]

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" <jk@discussions.microsoft.com> skrev i meddelandet
news:54358926-3B0D-4812-B06F-4D801703E7D5@microsoft.com...
> Hello,
> What is the code used to hide a sheet in the workbook?
>
> Thanks

[Tushar Mehta]

In article <54358926-3B0D-4812-B06F-4D801703E7D5@microsoft.com>,
jk@discussions.microsoft.com says...
> Hello,
> What is the code used to hide a sheet in the workbook?
>
> Thanks
>
In addition to the suggestions you've already received, you may want to
check the discussion at
Very Hidden Worksheets
http://www.dailydoseofexcel.com/arch...en-worksheets/

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions