Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Franklin Hall on Jan 17 In MS Office Category.

How can I hide a single sheet from a workbook?

Question Answered By: Kawakib Mansour on Jan 17

Sorry, I didn't realise you were after code for it. That's simply how you
do it from the Excel menu.

This command button code hides Sheet2

Option Explicit

Private Sub CommandButton1_Click()
Worksheets("Sheet2").Visible = False
End Sub

This Question has 5 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on How can I hide a single sheet from a workbook? Or get search suggestion and latest updates.

Related Topics:

Max number of sheets in workbook?
reconcile data from samew workbook but in different sheet
MOVING SHEETS BETWEEN WORKBOOKS
script for checking hidden linking to other workbook, dll, ocx
hide sheet
Populate a combo box into a hidden sheet
Hide sheet tabs
Auto Hide & Unhide summary sheet thru VBA
Hyperlink to a hidden sheet
Hide sheets
Change Workbook's Name
Opening Drill Down Data of Pivot Table in Single Sheet
Prob running workbook activate code when workbook is opened by anot
Save a single sheet as a separate file
Save a single sheet in Tab or Text Format
Next Workbook or Previous Workbook
Making a Workbook as an Active Workbook without opening it
Run Macor in a closed workbook and refer to the closed workbook
Retrieve data from Sheet with SQL and put it in Another sheet
unprotect the sheet, insert hyperlink & then protect the sheet

Tagged:how can hide single sheet from workbook

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us