Question about Operating Systems

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

How to convert 2007 excel sheet into 2003 excel sheet


if you have excel 2007 you can save the file into excel 2003 compatibility

if you have excel 2003 need download compatibility pack from this page
http://www.microsoft.com/downloads/en/details.aspx?familyid=941b3470-3ae9-4aee-8f43-c6bb74cd1466&displaylang=en
install it and success!

Feb 22, 2011 | Operating Systems

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 | Operating Systems

1 Answer

Describe the each part of microsoft excel 2207


anmolsxn_0.gif
Parts of the Excel 2007 Screen

Active Cell In an Excel 2007 worksheet, the cell with the black outline. Data is always entered into the active cell.
Column Letter Columns run vertically on a worksheet and each one is identified by a letter in the column header.
Formula Bar Located above the worksheet, this area displays the contents of the active cell. It can also be used for entering or editing data and formulas.
Name Box Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.
Row Number Rows run horizontally in an Excel 2007 worksheet and are identified by a number in therow header.
Sheet Tab Switching between worksheets in an Excel 2007 file is done by clicking on the sheet tab at the bottom of the screen.
Quick Access Toolbar This customizable toolbar allows you to add frequently used commands. Click on the down arrow at the end of the toolbar to display the toolbar's options.
Office Button Clicking on the Office Button displays a drop down menu containing a number of options, such as open, save, and print. The options in the Office Button menu are very similar to those found under the File menu in previous versions of Excel.
Ribbon The Ribbon is the strip of buttons and icons located above the work area in Excel 2007. The Ribbon replaces the menus and toolbars found in earlier versions of Excel.
Here are the main parts of Microsoft Excel 2007. Thank you for using Fixya !!!

Nov 15, 2010 | Microsoft Windows XP Professional

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 fix Error 8E5E05F6


Try the following:

1. Enable Hidden Files and Folders:
1. A. Windows XP :
1. a.i. Click on “Start”, click “My Computer”
1. a.ii. On the “Tools” menu, click on “folder options”.
1.a.iii. On the “view” tab, locate “Advanced settings” and then follow these steps:
Check the option “Show Hidden files and folders”
Clear the option, “Hide protected operating system files check box”.
Clear the option, “Hide file extensions for know file types check box”.
1. a.iv. Click ok and close the window.
1.B. Windows Vista :
1.b.i. Click on “Start”, click “My Computer”
1.b.ii. In the Explorer window, click “Organize”
1.b.iii. Choose “Folder and Search Options”.
1.b.iv. In the folder options window, click on “View” tab
1.b.v. Select the option “Show hidden files and folders” click “ok”.

2. Delete Windows Live Contacts folder :
2. a. Click on “Start”; double click on “My computer”
2. b. Browse to the location
Windows XP:
C:\Documents and Settings\<Your Windows logon name>\Local settings\Application Data\Microsoft
Windows Vista:
C:\Users\<Your Windows logon name>\App Data\Local\Microsoft
2. c. Delete “Windows live contacts folder” completely.
Note: Ensure to exit Windows live Messenger from the task manager before deleting Windows live contacts cache folder, otherwise you will get an error prompting that you can’t delete the folder .
2. d. Try signing into Windows Live Messenger.

Sep 19, 2009 | Microsoft Windows Vista Home Premium with...

2 Answers

How to coonectivity excel sheet with visual basic with coding


Here is ur solution :
http://support.microsoft.com/kb/257819

Thanks,
Mukund
www.Einfochips.com

May 20, 2009 | Microsoft Windows XP Professional With...

1 Answer

Need Formula


TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. $
SQL Database Migration $
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! $
CSV Converter $

IMPORTING
Import SQL Into Excel-SQL Tester $
Import Excel Into Access $

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

1 Answer

Asking


Hi Mykk

If you are using Microsoft windows then follow the following steps to hide any files and folder:

1. Right click the file or folder that you want to hide
2. Go to Properties
3. Now in the Attribute Section (Below the size of files or folder)
4. Now You'll be able to see two check box option i.e. "Read-only" & "Hidden".
5. Now check mark the Hidden Option in Attribute Section.
6. Click Apply Button.
7. Confirm the option to apply settings to Subfolder & files(This confirmattion is asked only if you are hiding any folder).
8. Click OK.

9Now you'll be seeing that the folder or file's color has been changed that means you have hidden file or folder Successfully.

10. Now Go to "Tools" in menu bar
11. Click "Folder options"
12. Go to "View" Tab
13. Now in Hidden files and folder optin below Select the redio box i.e. "Do not show hidden files and folders"
14. Click Apply button
15. Click Ok


To Unhide your files or folder follow the steps from 10-15, by just making changes in step 13.
You just have to select the radio box i.e. "Show hidden files and folders.
(Rate me after you have got ur solution)

-Thanx
-Romy

Aug 03, 2008 | Microsoft Windows Vista Ultimate Edition

1 Answer

WINDOWS OFFICE FILE RENAME PROB.


When you rename a word file you need to keep the .doc file extension for it to open again in word. .xls for excel etc.

You may not have the file options visible in windows explorer. Go to tools > folder options > view and untick "hide file extensions for known file types.

If you mess it up you can open via windows explorer. Right click the file and choose openwith and select the appropriate program.

Feb 28, 2008 | Microsoft Windows XP Professional for PC

2 Answers

Folder option hide in xp


open my computer... at tools menu click folder options... then click view tab and click the button show all hidden files and folders...

Jan 21, 2008 | Microsoft Windows 98 for PC

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

487 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...