help in VBA Code to hide sheet tabs in an active workbook.

Wrox Programmer Forums

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
help in VBA Code to hide sheet tabs in an active workbook.

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

May 17th, 2013, 07:20 AM

excel_jac

excel_jac is offline

Registered User

Join Date: May 2013

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Post

help in VBA Code to hide sheet tabs in an active workbook.

Hi i need a code to hide the sheet tabs from the workbook only the horizontal and vertical scroll bar should be shown.

any help in this regard will be appreciated.

thanks

Old

May 19th, 2013, 12:02 AM

Shasur

Shasur is offline

Friend of Wrox

Join Date: Sep 2005

Posts: 812

Thanks: 1

Thanked 53 Times in 49 Posts

Default

Hi

Please have a look at Hide Sheet Tabs using VBA / Hide Excel Sheet Tabs (2007/2010)

Hope it helps

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy Excel ListObjects from active workbook to a new Excel workbook using vba	dearnemo385	Excel VBA	1	April 29th, 2012 12:56 PM
Open Workbook,Copy Sheet,Move Sheet, Close/Save	ptrussell2009	Excel VBA	0	June 13th, 2008 02:28 PM
How to hide VBA code	james gold	Excel VBA	12	November 14th, 2005 10:59 AM
Hide VBA code when forwarding macro	sh333384	Excel VBA	7	September 2nd, 2004 10:23 AM
Code to populate multiple sheet into workbook	kud	Excel VBA	0	June 9th, 2004 11:37 AM