LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Adding a Check Mark commant to the Menu

I have found the following instructions on the MS online help but it is a
little over my head. I have two questions that I need to ask to get started
and then I can fumble though the rest. First, I do not understand step !.
What does it mean to insert a new module? Second, In step 2 where is the
menu editor command? I don't see it under tools in Excel.

1. Insert a new module in a workbook.
2. To add a command called "Database" below the Toolbars command on the View
menu, choose the Menu Editor command from the Tools menu.

For more information about using the Menu Editor, see pages 242-244 of the
"Visual Basic User's Guide."
3. Select a portion of the worksheet that you want to be the database view
and give it the assigned name "Database_View." Repeat this procedure for the
worksheet view, and give that worksheet selection the defined name
"Worksheet_View."
4. Switch to the Visual Basic module, and enter the following code:
Sub DatabaseView()
With MenuBars(xlWorksheet).Menus("View").MenuItems("Dat abase")
.Checked = Not .Checked 'toggles check mark on/off
If .Checked Then
'Switch to Database View
Application.Goto "Database_View", True
Else
'Switch to Worksheet View
Application.Goto "Worksheet_View", True
End If
End With
End Sub


5. Using the Menu Editor, assign the DatabaseView macro to the Database
command.
6. Activate the worksheet.
7. Choose Database from the View menu.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make the check mark boc bigger on the check box? srod Excel Discussion (Misc queries) 0 October 6th 08 09:52 PM
How can I add active tick mark/check mark boxes in excel? gerberelli Excel Discussion (Misc queries) 2 May 3rd 08 05:16 PM
Increase size of a Forms Check Box (click on to enter check mark) 718Satoshi Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Menu Item check mark?? Derrick[_3_] Excel Programming 1 April 1st 05 06:36 PM
Adding a check mark to the custom made toolbar/menu continue...... aiyer[_59_] Excel Programming 0 September 2nd 04 12:52 AM


All times are GMT +1. The time now is 02:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"