Question about Computers & Internet

2 Answers

How to hide sheet tabs in MS Excel

Hi,
I am a new bee to MFC.I want to hide sheet tabs(By GUI ,Tools ->options -> View ->sheet tabs) of MS Execel using MFC. Any suggestions will be highly appreciable .

Thanks
Noufal k

Posted by on

  • noufalk Mar 10, 2008

    Thanks rossgb,
    I am not using Visual Basic ,but VC++/MFC.
    Actually my problem is how to solve that problem using VC++.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 10 Answers

Do you mean by Visual Basic / Macro?

if so this is what you need:

ActiveWindow.DisplayWorkbookTabs = False

Posted on Mar 08, 2008

  • Ross Brown Mar 08, 2008

    p.s. if you need to figure anything else out like this you can do this:

    Tools -> Macro -> Record new macro
    Name your macro and Click OK
    (a toolbar with a square and a picture of a table will appear)
    preform the action you want to do with VB
    click the square (on the macro toolbar)
    press Alt+F11 to go into Visual basic editor
    double click modules (on left toolbar)
    double click module1
    copy all the black text between "sub (macro name)! and "end sub"
    this code when run will do the action you just recorded in your macro

×

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Novelist:

    An expert who has written 50 answers of more than 400 characters.

    Champion:

    An expert who has answered 200 questions.

  • Expert
  • 202 Answers

Hi,

Why dont u just send the key combinations to the excel application for performing the same operation from ur MFC program

Otherwise, u have to register the VBA addin class for excel db access in ur MFC program and then pass ur commands just like as in macro

:)

Have a nice day

I hope, my suggestion was helpful

Posted on Mar 15, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

How do i fix corrupted excel file?


It's a critical problem for us, after unfortunately data file got corrupt due to virus infection, I faced such type problem.
Read something useful herehttp://www.filerepairforum.com/forum/microsoft/microsoft-aa/excel/691-%E2%80%8Bhow-can-i-repair-excel-file
Or use Excel Repair Toolbox http://www.excel.repairtoolbox.com/

Feb 01, 2015 | The Computers & Internet

Tip

Excel- Unhide All Sheets


Advanced Hide Options

When we hide worksheets using, still user can right click on tabs and un-hide the worksheets. For example, following example will hide the worksheet and user can un hide the sheets on right click on sheet tabs:
Sub sbHideSheet() Sheets("SheetName").Visible = False 'OR Sheets("SheetName").Visible = xlSheetHidden End Sub What if you do not want to permit users to un-hide worksheet, you can set the Visible property of worksheet to xlSheetVeryHidden and lock the VBA code. so that user can not un-hide the worksheet. The below example will hide the sheet and user can not see it in un hide worksheet dialog list.
Sub sbVeryHiddenSheet()
Sheets("SheetName").Visible = xlSheetVeryHidden
End Sub

on Dec 09, 2016 | Microsoft Excel for PC

Tip

Drive can,t open on double-click


hi there,

many times user face this type of problem.

first ,of all open -my computer > open tools tab > then folder option >then view tab click on "show hidden files"and uncheck "hide protected oprating system files" then ok

second , click on folder button (standred button) "it is up to address bar or next to search button"
now click on drive in left side explorer window now you can see folders in drive "delete" autorun.inf file in drive.

third, go in drive properties by right click on drive in explorer window,
click on "tools" tab click on "check now"
mark on automatically fix file system error and click start

it will start checking file system and fix it or it will ask fix it on next restart (it checkdsk command in windows gui mode )
after restart chkdsk start and your drive will again open on double-click.

on Jan 27, 2010 | Computers & Internet

1 Answer

How do I copy an excel sheet into word showing grid lines


Show or hide drawing gridlines Drawing gridlines appear only in Print Layout view.
  • On the View tab, in the Show/Hide group, select the Gridlines check box. " alt="Word Ribbon Image">

Sep 29, 2014 | Dell Computers & Internet

1 Answer

How do you create multiple splits/panes in an excel spreadsheet?


On the file menu, go to > Window > Split
You can only split the window once. You can drag/slide the window divider

If you want more than one pane, you can choose "new window" to open another, and another view of the same sheet. You can then use >Tools>Options to select different view options for each of these windows (i.e show grids or not).

Jan 27, 2013 | Apple iMac Computers & Internet

6 Answers

How do I unlock an excel spreadsheet which has password protection (lost). I am using Mac Excel not Windows


A) Open document > Select edit menu > choose select all > then choose copy from edit menu.
Open new document > edit menu> paste.
Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected.
Select save tab>choose and mark box>ask about properties
accept or Apply options and close.
Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.
If this does not work.
B)There are many 3rd party utilities which claim to reset forgotten word password:
The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the "Password to Open" and "Password to Edit" for you to view and edit the document freely.
http://www.recoverlostpassword.com/products/excelpasswordrecovery.html

May 06, 2010 | Microsoft EXCEL MAC UPGRADE 2008 Upgrade...

1 Answer

Microsoft excel is only opening blank (without any sheet or flie


Go to the tools menu click on options and the view tab under window options make sure everything is checked except page breaks and formulas.

Jan 16, 2009 | Microsoft Excel for PC

2 Answers

How to Crack Excell sheet's Password


http://www.straxx.com/excel/password.html

Mar 03, 2008 | Computers & Internet

3 Answers

Excel 2007


default.aspx?assetid=za790050001033Show All default.aspx?assetid=za790050011033Hide All
  1. Select the sheets on which you want to change the gridline color. default.aspx?assetid=za790050001033How?
    When you enter or change data, the changes affect all selected sheets. These changes may replace data on the active sheet and other selected sheets.
    To select Do this A single sheet Click the sheet tab. default.aspx?assetid=za060521711033 If you don't see the tab you want, click the tab scrolling buttons to display the tab, and then click the tab.
    default.aspx?assetid=za060521061033 Two or more adjacent sheets Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet. Two or more nonadjacent sheets Click the tab for the first sheet, and then hold down CTRL and click the tabs for the other sheets. All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.). Note If sheet tabs have been color-coded, the sheet tab name will be underlined in a user-specified color when selected. If the sheet tab is displayed with a background color, the sheet has not been selected.
    default.aspx?assetid=za790050001033Cancel a selection of multiple sheets
    To cancel a selection of multiple sheets in a workbook, click any unselected sheet.
    If no unselected sheet is visible, right-click the tab of a selected sheet. Then click Ungroup Sheets on the shortcut menu.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, click the color you want in the Color box. To use the default gridline color, click Automatic.

Jan 18, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

How can i change my old excel sheet password


Dear shiltu, you first have to remove your password. Press the old password and have access to the document. Now remove the password. Set new password and save it. You're done :)

if that has helped you please press fixya.

Dec 22, 2007 | Microsoft Excel for PC

Not finding what you are looking for?

Open Questions:

Computers & Internet Logo

Related Topics:

487 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

101711 Answers

David Payne
David Payne

Level 3 Expert

14160 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...