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++.

×

Ad

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

×

Ad
  • 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

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

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:

1 Answer

My boss recorded her daughter playing the piano - what kind of file is it and can it be shortened?


You have to check the exstension, to do this follow these steps:
  1. In Windows 2000 or Windows XP open My Computer
  2. Click Tools
  3. Click Folder Options
  4. Click View tab
  5. Uncheck the box that says Hide file extensions for known file types.
Or
  1. In Windows XP click on Start
  2. Click Control Panel
  3. Click Folder Options
  4. Click View
  5. Uncheck Hide extensions for known file type.
If you want to shot/cut your file, you can use freeware tools - Audio File Cutter

May 16, 2011 | Zarboo Software SpeakEasy Voice Recorder

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

My pop-up suggested I open and view files using Windows Explorer which I did. This resulted in a loss of my Vsafe sign-in and I have no access to any of my files. Is there anything that can be done?


Hi suey,

If youre lucky, your files are only hidden.

In windows explorer (my computer), go to tools, then folder options. In the "view" tab;

- click 'show hidden files and folders'

unclick "hide extensions...' and 'hide protection...'

Hope this works,

Cheers,

kc

Feb 21, 2011 | Verbatim ® Store `n` Go USB Flash Drive,...

4 Answers

How can i view hidden files in windows xp?


Kindly follow the following steps to view your hidden files in your PC...

1. Double click & Open the 'Windows Explorer / My Computer'

2. From the file menu bar select 'Tools'

3. Select 'Folder Options'

4. Select the 'View' Tab on the Option Window

5. In that tab you will find 'Hidden Files & Folders' with a folder icon

6. Select the 'Show Hidden Files and Folders' by selecting the radio button.

7. Then select 'Apply'

Now you will be able to view the hidden files & folders in your system. I have enclosed the screen shots for your better reference.


ec7e812.jpg

8b2017d.jpg

8097ecf.jpg

Jun 14, 2010 | Microsoft Windows XP Professional SP2

3 Answers

How do i switch off ms word 2007 auto correct?


Open ms word 2007 then go to tools -> autocorrect
then disable check box for which you not want autocorrect.

Aug 24, 2009 | Microsoft Office 2003 Basic Edition...

2 Answers

I use ms word 2003, is there any options which highlight all the spacing errors in the doc, for Eg. double spacing mistakes between two words..


I use Word 2003 and it automatically checks spelling AND spacing between words.

Under Tools>Options>Spelling&Grammer tab check the boxes that say "Check spelling as you type", "Always suggest corrections", "Check Grammar as you type", and "Check Grammer with spelling".

Apr 21, 2009 | Computers & Internet

1 Answer

Renaming files


from the folder options go to the view tab and tick on the hide the extensions of known file type.

Apr 09, 2009 | Computers & Internet

1 Answer

Changing my file to other format


goto my computer
on menu bar >tools
>folder options> view tab
uncheck hide extensions of known file types
apply >ok


browse to your file using windows explorer
right click it >rename >
add /edit extension to <filename> .doc
or .rtf etc as desired.
enter
try reopening in ms word
regards
Mayank

Nov 28, 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...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

490 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18425 Answers

Alun Cox

Level 3 Expert

2678 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...